Forum Discussion
Accessing Dataware house from another workspace
I have two workspaces: WSP_1 & WSP_2. I have a data warehouse in WSP_1 called DB_1 and a 2nd data Warehouse in WSP_2 called DB_2. I need to access in WSP_1 that I have access to DB_1 also have access to DB_2 . Select some rows from a table in DB-2 in WSP_2 into a table in DB_1 inside WSP_1. Access Datawarehouse from 2nd workspacev while working in 1st workspace
Thanks for your help
Hi vasalari ,
Thanks for reaching out to the Microsoft fabric community forum.
Currently direct querying between warehouses in separate workspaces isn't natively supported. You either have to copy the data from workspace 2 to 1 using pipeline, dataflows or notebook.
Or you can achieve your goal by leveraging Lakehouse shortcuts.
Create a New lakehouse in Workspace 1 and create a shortcut referencing the warehouse in workspace 2
Once that is done go to the required warehouse in workspace 1 and click on
Add the newly created lakehouse (SQL analytic endpoint) by clicking on + warehouse.
When the above steps are completed
we will have both the required tables in warehouse 1.
Now we can write queries on data as per your requirement.
For example:With this workaround we can achieve what you are trying to do.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
3 Replies
Hi vasalari
shortcuts will not work in your scenario.
Use a Data Pipeline, Dataflow, or Notebook to copy data from the Warehouse in WSP_2 (DB_2) into a Lakehouse in WSP_1.
Hello, Many thanks for your reply. Copying is out of question. Billiuons of records. I created a link lakehouse and it worked
Hi vasalari ,
Thanks for reaching out to the Microsoft fabric community forum.
Currently direct querying between warehouses in separate workspaces isn't natively supported. You either have to copy the data from workspace 2 to 1 using pipeline, dataflows or notebook.
Or you can achieve your goal by leveraging Lakehouse shortcuts.
Create a New lakehouse in Workspace 1 and create a shortcut referencing the warehouse in workspace 2
Once that is done go to the required warehouse in workspace 1 and click on
Add the newly created lakehouse (SQL analytic endpoint) by clicking on + warehouse.
When the above steps are completed
we will have both the required tables in warehouse 1.
Now we can write queries on data as per your requirement.
For example:With this workaround we can achieve what you are trying to do.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
