Building your own Fabric Open Mirroring Solution
Proposed session for SQLBits 2026TL; DR
Learn what Open Mirroring is, when to use it, and how it enables custom ingestion from any source. We’ll walk through the APIs step‑by‑step and build a full Open Mirroring solution live so you can confidently create your own.
Session Details
Open Mirroring is one of the most flexible and powerful ways to bring external data into Microsoft Fabric — but many users don’t yet realize when to use it, why it exists, or how to build their own solution. This session demystifies Open Mirroring from the ground up and empowers attendees to create a fully working solution live during the presentation.
We’ll start by breaking down the core concepts:
What Open Mirroring is and how it differs from native Fabric Mirroring
Ideal use cases — including SQL Server, SharePoint, files, and any source where customers need full control over ingestion
When teams should choose Open Mirroring over pipelines, Dataflows, or COPY operations
Next, we’ll walk through the underlying APIs step‑by‑step, exploring how Fabric manages metadata sync, delta file generation, refresh operations, and Lakehouse updates. From there, we’ll build a complete Open Mirroring solution live, showing exactly how to orchestrate extract, structure, and ingest operations in a repeatable and maintainable pattern.
By the end of the session, attendees will:
Clearly understand where Open Mirroring fits into the broader Fabric ingestion ecosystem
Know the architectural choices and trade‑offs when designing a custom mirroring pipeline
Walk away with practical code examples, patterns, and a blueprint they can adapt for their own data sources
If you’ve ever wanted to mirror data into Fabric from any system — even those not natively supported — this session gives you the roadmap. Bring your questions, bring your APIs, and let’s build your first Open Mirroring solution together.
We’ll start by breaking down the core concepts:
What Open Mirroring is and how it differs from native Fabric Mirroring
Ideal use cases — including SQL Server, SharePoint, files, and any source where customers need full control over ingestion
When teams should choose Open Mirroring over pipelines, Dataflows, or COPY operations
Next, we’ll walk through the underlying APIs step‑by‑step, exploring how Fabric manages metadata sync, delta file generation, refresh operations, and Lakehouse updates. From there, we’ll build a complete Open Mirroring solution live, showing exactly how to orchestrate extract, structure, and ingest operations in a repeatable and maintainable pattern.
By the end of the session, attendees will:
Clearly understand where Open Mirroring fits into the broader Fabric ingestion ecosystem
Know the architectural choices and trade‑offs when designing a custom mirroring pipeline
Walk away with practical code examples, patterns, and a blueprint they can adapt for their own data sources
If you’ve ever wanted to mirror data into Fabric from any system — even those not natively supported — this session gives you the roadmap. Bring your questions, bring your APIs, and let’s build your first Open Mirroring solution together.
3 things you'll get out of this session
Learn what Open Mirroring is good for.
Learn how to setup and build their own Open Mirroring solution.
Speakers
Mark Pryce-Maher (He / Him)'s other proposed sessions for 2026
F is for Fabric - 2026