working with a Bronze Delta Lake and a Silver dataLake

[DebbieE]

I have created a Notebook and added the Bronze Delta Lake  to transform the data in there

Now I want to create Delta tables from them 

df.write.mode("overwrite").parquet('Files/Data/Silver/datatransformed.parquet')

However, this just creates a Filver Folder in the Delta Lake and I want to save to another data lake? SilverTrainingDL

Is there any way of doing this?

[frithjof_v · Accepted solution]

If you want to create delta table, you can use saveAsTable function.

https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-notebook-load-data

See also:

https://community.fabric.microsoft.com/t5/Data-Engineering/Writing-to-a-Lakehouse-in-different-works...

https://community.fabric.microsoft.com/t5/Data-Engineering/How-to-save-a-table-in-Fabric-Lakehouse/m...

[DebbieE]

Ah  It worked when I did this

df.write.mode("overwrite").option("overwriteSchema", "true").format("delta").saveAsTable("GoldTraininglh.dimContestant")

[jjaeger94]

If you add the Silver Lakehouse to your notebook and then

Copy the ABFS path to the files, that will be the path you want to use to write the file to.

[DebbieE]

I have the Bronze Lakehouse added but I dont know how to add another Lakehouse tob the notebook so i have two?

Ahhhh OK, You can add another one. Lets see if I can do the above......

When I right click on the Tables folder in the notebook all I get is refresh. No copy ABFS path because nothing is there yet.