Mirrored data with SQL endpoint
Mirrored data with SQL endpoint
Tables are stored as Delta Parquet files in the mirroring database. The SQL endpoint allows normal SQL queries.
Area: Integration (Fabric, Shopify, MDM). Status: preview. Developer relevance: medium. Airtime: 1 min across 1 video, demoed.
Status evidence
- 0:19 in "Introducing: Business Central Integration with Microsoft Fabric": "this is coming in public preview in version 29.x, likely 9 29.1"
Where they talk about it
- Introducing: Business Central Integration with Microsoft Fabric: 4:25 to 5:15, demo at 4:25 (called "Mirrored data in OneLake with SQL endpoint" there)
Quotes
- 4:46 "They're actually not SQL tables, they're Delta Parquet files" - Clarifies the real storage format behind the SQL endpoint in Fabric.
Caveats mentioned
- The tables are not SQL tables but Delta Parquet files
Documented features match
- No documented item matched. Not documented
Docs checked on 2026-10-02: the match is against Microsoft's what's new pages for the wave as they were on that date. Microsoft keeps filling the documentation, so "no documented item" can go stale. The wider product documentation on learn.microsoft.com was searched for this feature on the same date; the feature's data lists an article when one was found.
Tags: fabric, onelake, sql, delta-parquet
Generated by pipeline step 06. Source: YouTube auto-captions of the launch event videos, see the deep links. Not official.