Question

You are an analytics engineer building a Fabric lakehouse. A partner team maintains a curated Delta table in a separate Fabric lakehouse in another workspace. Your reports must always reflect the partner team's latest data with no duplication of storage and no scheduled refresh to maintain. Which approach should you use to make this data available in your lakehouse?

Accepted Answer

Create a OneLake shortcut in your lakehouse that points to the partner team's Delta table

Answer

Use a Copy activity in a Data pipeline to load the table into your lakehouse Tables area nightly

Answer

Build a Dataflow Gen2 that reads the partner table and writes it to your lakehouse

Answer

Export the partner table to CSV and import it into your lakehouse Files section