Is it possible read data from lakehouse1 in workspace1 and write it to lakehouse2 in workspace2?

[srblodhi]

I have lakehouse1 in workspace1 and lakehouse2 in workspace2. I want to read data from lakehouse1, do some transformations in a python notebook, and write the modified data to lakehouse2. Is this possible? If yes, please give an example of how to achieve this. If No, is there a workaround, or widely used method to avoid this problem?

Thanks!

[Anonymous]

HI @srblodhi,

You can create a data pipeline with 'copy activity' to copy data from the 'workspace 1' - 'lakehouse 1' to the 'workspace2' - 'lakehouse 2'.(Config: Source, workspace1 -> SynapseTest -> Orders; Destination, workspace2 -> LakehouseTest25 -> Orders)

Regards,

Xiaoxin Sheng

[frithjof_v · Accepted solution]

Hi @srblodhi,

What @AndyDDC said. Here is also some example code:

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

[AndyDDC]

You can reference the lakehouse delta tables in workspaces by using the abfss path visible in each tables properties. You can then read and write using this path