Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there, I've been struggling to find good documentation on how to read data from a lakehouse in one workspace and after applying some transformations, write it to a different lakehouse in a different workspace. Is this possible? I have the following workspaces:
WORKSPACE_BRONZE that contains LAKEHOUSE_BRONZE
WORKSPACE_SILVER that contains LAKEHOUSE_SILVER
LAKEHOUSE_BRONZE has a CSV file in the files section. I have a notebook and have added both lakehouses to the notebook. I have some code like this to read the file:
Solved! Go to Solution.
You can use the fully qualified path to write to a Lakehouse in another workspace.
Please see this article, it helped me:
https://murggu.medium.com/databricks-and-fabric-writing-to-onelake-and-adls-gen2-671dcf24cf33
So, to write to a table (new or existing) in a Lakehouse in another workspace, I think it is possible to write it like this:
You can use the fully qualified path to write to a Lakehouse in another workspace.
Please see this article, it helped me:
https://murggu.medium.com/databricks-and-fabric-writing-to-onelake-and-adls-gen2-671dcf24cf33
So, to write to a table (new or existing) in a Lakehouse in another workspace, I think it is possible to write it like this:
Thank you so much!
Hi @AdamFry ,
Glad to that your issue got resolved. Please continue using Fabric Community on your further queries.
For syntax and stuff, trying asking Copilot or ChatGPT. I usually get pretty good feedback.
Apologies for not using the code block for the code in my post, I tried editing my post to add it but I got an invalid html error so hopefully this is ok posted as is.
Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
5 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
16 | |
8 | |
3 | |
3 | |
3 |