topic Re: Fabric one lake migration in Warehousing & Analytics

Fabric one lake migration

Pilsner — Mon, 21 Jul 2025 09:02:48 GMT

We are trying to migrate our data from Fabric One Lake to the unity catalogue. Has anyone had experience with this before? Any pointers/ things to be aware of would be appreciated.

Re: Fabric one lake migration

SP_6721 — Mon, 21 Jul 2025 18:40:30 GMT

Hi @Pilsner ,

To migrate from Fabric OneLake to Unity Catalog, start by copying your data into ADLS Gen2, since Unity Catalog can't directly access OneLake. You can use Azure Data Factory or other ETL tools for this transfer. Once the data is in ADLS Gen2, you can register it as tables in Unity Catalog.

Re: Fabric one lake migration

nayan_wylde — Mon, 21 Jul 2025 20:17:02 GMT

There are lot of options to access data in UC in fabric either by mirroring or by creating shortcuts on the ADLS.

But there are limited options the other way round. Currently there is no way to access the fabric objects directly from databricks. One option is to try to create external location on top of the data lake where the fabric tables reside and create delta tables in UC. The other option is to create federated queries from Databricks. You can try out this option.

https://murggu.medium.com/running-federated-queries-from-unity-catalog-on-microsoft-fabric-sql-endpoint-1485da1d450b

Re: Fabric one lake migration

Pilsner — Wed, 30 Jul 2025 13:59:57 GMT

Hello @SP_6721 and @nayan_wylde

Thank you both for your replies, I appreciate the pointers. I'll definitely look into your suggestions of creating an intermediate step instead of migrating directly from Fabric to databricks.