Forum Discussion
working with a Bronze Delta Lake and a Silver dataLake
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
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:
4 Replies
- jjaeger94
Helper II
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
Community Champion
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.
- frithjof_v
Community Champion
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:
- DebbieE
Community Champion
Ah It worked when I did this
df.write.mode("overwrite").option("overwriteSchema", "true").format("delta").saveAsTable("GoldTraininglh.dimContestant")