Skip to main content
Microsoft Idea

Synapse

New

Cross workspace joins.

Vote (5) Share
David Purdy's profile image

David Purdy on 18 Jan 2024 12:52:19

We are planning a data mesh architecture enabled by Fabric and dbt-cloud. Separate teams within our data warehousing group will develop tables and views in their own dbt projects. dbt models will be shared across teams when appropriate to enable consistency and efficiency. This is easy to do within dbt-cloud so long as all teams deploy to different databases in the same workspace (thanks to cross database querying). However, using one workspace prevents taking advantage of the potential for scale out across multiple fabric capacities. Enabling cross-workspace queries would solve this.

Comments (1)
David Purdy's profile image Profile Picture

Steve Howard (FABRIC) on 26 Jan 2024 14:56:03

RE: Cross workspace joins.

Hi David, the Fabric DW team is currently has this feature in our backlog and are reviewing capabilities for enabling it. Please continue to collect additional votes for this item from the community.