Cross Workspace/Cross Warehouse · Learn Microsoft Fabric

Feb 6 • General

Cross Workspace/Cross Warehouse

I'm exploring using a warehouse instead of a lakehouse because it offers schema-level tracking with the deployment pipeline.

In my architecture, I'm loading data from the source into the warehouse (wh_level1) using DF Gen2. Now, I need to access the same data from warehouse (wh_level1) in another warehouse (wh_level2) from different workspace without creating additional copies, similar to how shortcuts work in a lakehouse.

I'm curious if there's a way to query data across workspaces. The Microsoft documentation mentions it, but it doesn't provide a detailed explanation of how to do this.

Refer: https://learn.microsoft.com/en-us/fabric/data-warehouse/tutorial-sql-cross-warehouse-query-editor

4 comments