Forum Discussion

Kristian_nho's avatar
Kristian_nho
Icon for Helper I rankHelper I
8 months ago
Solved

How 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...
Need Help
sql database
  • Kristian_nho's avatar
    Kristian_nho
    7 months ago

    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.

OnurOz's avatar
OnurOz
Icon for Resolver III rankResolver III
8 months ago

Hi Kristian,

 

I haven't tested this out but you might find this link interesting:

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azuresqldb-current&preserve-view=true&tabs=dedicated#c-create-an-external-data-source-for-bulk-operations-retrieving-data-from-azure-storage

In theory you can create a link to underlying data storage and use the OPENROWSET to do load the data into a table in SQL Server. Unfortunately you can't create an external table on top of a Blob Storage. It is just for doing bulk actions.

Btw, it would be nice if we could do what you've asked for, I suggest adding this as an idea to the product team. 

 

Best

Onur

😊 If this post helped you, feel free to give it some Kudos! 👍

✅ And if it answered your question, please mark it as the accepted solution.