QuestionQ35

VerifiedPrepare data

You have a Fabric tenant that contains two workspaces named Workspace1 and Workspace2. Workspace1 contains a lakehouse named Lakehouse1. Workspace2 contains a lakehouse named Lakehouse2. Lakehouse1 contains a table named dbo.Sales. Lakehouse2 contains a table named dbo.Customers.

You need to ensure that you can write queries that reference both dbo.Sales and dbo.Customers in the same SQL query without making additional copies of the tables.

What should you use?

Explanation

Shortcuts are Fabric's purpose-built feature for cross-workspace and cross-lakehouse data access without copying tables. They create virtual references to data in different workspaces, allowing you to write a single SQL query that references tables from multiple lakehouses. Dataflows, views, and managed tables would all require actual data copies or complex workarounds.

Community Discussion

No comments yet. Be the first to start the discussion!