Accessing Dataware house from another workspace

[vasalari]

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

[v-nmadadi-msft · Accepted solution]

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

[nilendraFabric]

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.

[vasalari]

Hello, Many thanks for your reply.  Copying is out of question. Billiuons of records.  I created a link lakehouse and it worked