Connecting Databricks data to Fabric Plan via OneLake shortcuts

Started by Omar Hassan · 1 year, 3 months ago · 3 replies · 2 views

Omar Hassan Participant

1 year, 3 months ago

Our actuals data lives in Databricks Unity Catalog. I want to surface it in Fabric Plan without moving the data. OneLake shortcuts seem like the right mechanism. Has anyone done this successfully?

3 Replies

Sort

Raj Subramaniam

Microsoft Fabric Consultant · CloudBridge Solutions · 1 year ago

Yes, OneLake shortcuts to Databricks are supported. Create a shortcut in your Fabric Lakehouse pointing to the Databricks Delta Lake path. The shortcut appears as a virtual table in OneLake that you can reference in your semantic model. No data copy, no pipeline needed.

Up

0

Marcus Delacroix

Senior BI Architect · Peak Logistics Europe · 1 year ago

One thing to verify: Databricks Unity Catalog external tables vs managed tables behave differently with OneLake shortcuts. Managed tables are more straightforward. For external tables, check the access path and make sure your Fabric credential has read access to the underlying storage.

Up

0

David Thornton

Director of Enterprise Analytics · Stellar Manufacturing · 1 year ago

We use exactly this pattern. The performance is very good because Fabric's Direct Lake engine reads Delta files natively. For large Databricks tables, partition pruning is important — make sure your shortcut leverages the Delta table's partition columns.

Up

0