Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
We are currently looking into moving our data warehouse to Fabric but we have some external data in an Azure SQL database. We'd like to integrate this data with Fabric without having to copy or move it. Is there a way to create a 'shortcut' (or equivalent of a linked server) in a Fabric Lakehouse or Warehouse to allow you to directly query the data that is in the Azure SQL database?
The only way I can think to query the same data from both environments is to store the data in ADLS and set it up as an external table in SQL. However the SQL database is running an established system that we can't change.
Thanks
Solved! Go to Solution.
It has been released (public preview) yesterday!
Mirroring - Microsoft Fabric | Microsoft Learn
Hi @MarkBurgess when do you need this up and running by? Mirroring in Azure SQL is on the Fabric roadmap but not available yet. There's no shortcut support for sql databases, so it may be that you'd need to incrementally export the data from the sql database to (as you say) azure data lake and then shortcut into fabric from there
Thanks @AndyDDC, good to know that mirroring is on the roadmap. Is there an approximate date?
It has been released (public preview) yesterday!
Mirroring - Microsoft Fabric | Microsoft Learn
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
51 | |
6 | |
4 | |
4 | |
3 |
User | Count |
---|---|
67 | |
12 | |
12 | |
6 | |
6 |