Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
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
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