Forum Discussion
Kristian_nho
Helper I
Helper IHow to Use Fabric Lakehouse as External Data Source in Fabric SQL Database
Hello community, We are trying to use a MS Fabric lakehouse as an external data source within a Fabric SQL database. The goal is to create external tables that reference lakehouse data so we can use...
Hello all,
Thank you for your suggestions. After careful consideration, our team has decided to go with Fabric Warehouse instead of SQL Database. I am sure these suggestions will still be helpful for other users.
Thank you again.
HugoQueiroz-MSF
Microsoft Employee
Microsoft EmployeeKristian_nho During Ignite we announced the Public Preview of Data Virtualization for Fabric SQL Database, the end goal is offer a solution for the very problem you described. You can check the capabilities, demos and requirements here:
Data Virtualization in SQL Database - Microsoft Fabric | Microsoft Learn
Basically to can do OPENROWSET, OPENROWSET + Views or External Tables itself, depending on your requirements.