Accessing Dataware house from another workspace

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