fabric warehouse vs databricks unity catalog

Hi arkiboys2 

 

The functionalities in Microsoft Fabric Data Warehouse are not exactly the same as those in Azure Databricks Unity Catalog. I am not sure if the features you are currently using in Databricks Unity Catalog can all find suitable alternatives in Fabric. 

 

For the security of Fabric warehouses, you can learn more from Security for data warehousing - Microsoft Fabric | Microsoft Learn. Basicly, you can use Fabric security (workspace roles, fabric item permissions) to manage user access and permissions to the entire warehouse. To manage more granular permissions within a specific warehouse, you can use standard T-SQL constructs to provide specific permissions to users.

 

However currently Fabric has some known limitations for warehouses and data pipelines. You might check the following documents to find out whether some functionalities that you are using are listed there. 

Data Warehouse Limitations - Microsoft Fabric | Microsoft Learn

Tables in data warehousing - Microsoft Fabric | Microsoft Learn

Data Factory limitations overview - Microsoft Fabric | Microsoft Learn

 

Hope this would be helpful. 

 

Additionally, Fabric now supports accessing Azure Databricks Unity Catalog tables directly through the Mirrored Azure Databricks Catalog feature, which is currently in public preview. If you want to do integrations with the data from Databricks Unity Catalog and other experiences in Fabic (e.g. Power BI), you could try this new feature.

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!