Fabric COPY JOB solved by the Mystery Machine
Proposed session for SQLBits 2026TL; DR
Zoinks! Join the gang as they chase down runaway datasets and unmask the secrets of Fabric Copy Job. Learn how full, incremental, and CDC copy tame multi‑cloud chaos and make zero‑ETL data movement feel like Saturday‑morning mystery solving!
Session Details
Zoinks! Your data is scattered across clouds, databases, and creepy old file stores — and every time you try to wrangle it, something goes bump in the night. But never fear!
In this session, the Mystery Inc. gang team up with Microsoft Fabric’s Copy Job to solve “The Mystery of the Missing Data” once and for all.
We’ll follow Scooby, Shaggy, and the gang as they chase down runaway Oracle tables, unmask sneaky CDC changes, and expose the real villain behind data duplication, latency gremlins, and multi‑cloud mayhem.
Copy Job takes center stage as the zero‑ETL hero delivering full loads, incremental loads, cross‑cloud distribution, SQL‑based filtering, and petabyte‑scale movement without the spooky pipelines lurking in the shadows.
Ruh‑roh? Not anymore. From BigQuery to SAP to Snowflake to SQL Server, you’ll see how Copy Job keeps your data flowing smoothly, efficiently, and (mostly) ghost‑free.
Jinkies!
Key Takeaways:
How Copy Job captures full, incremental, and CDC changes without the haunted‑house complexity
Multi‑cloud distribution (Azure, AWS, GCP, Snowflake) made simple enough for Shaggy
Using Copy Job in pipelines to orchestrate transformations, alerts, and downstream workloads
How Copy Job handles Oracle, SAP, BigQuery, and other “monster” data sources
In this session, the Mystery Inc. gang team up with Microsoft Fabric’s Copy Job to solve “The Mystery of the Missing Data” once and for all.
We’ll follow Scooby, Shaggy, and the gang as they chase down runaway Oracle tables, unmask sneaky CDC changes, and expose the real villain behind data duplication, latency gremlins, and multi‑cloud mayhem.
Copy Job takes center stage as the zero‑ETL hero delivering full loads, incremental loads, cross‑cloud distribution, SQL‑based filtering, and petabyte‑scale movement without the spooky pipelines lurking in the shadows.
Ruh‑roh? Not anymore. From BigQuery to SAP to Snowflake to SQL Server, you’ll see how Copy Job keeps your data flowing smoothly, efficiently, and (mostly) ghost‑free.
Jinkies!
Key Takeaways:
How Copy Job captures full, incremental, and CDC changes without the haunted‑house complexity
Multi‑cloud distribution (Azure, AWS, GCP, Snowflake) made simple enough for Shaggy
Using Copy Job in pipelines to orchestrate transformations, alerts, and downstream workloads
How Copy Job handles Oracle, SAP, BigQuery, and other “monster” data sources
3 things you'll get out of this session
How Copy Job captures full, incremental, and CDC changes without the haunted‑house complexity
Multi‑cloud distribution (Azure, AWS, GCP, Snowflake) made simple enough for Shaggy
Using Copy Job in pipelines to orchestrate transformations, alerts, and downstream workloads
How Copy Job handles Oracle, SAP, BigQuery, and other “monster” data sources
Speakers
Mark Pryce-Maher (He / Him)'s other proposed sessions for 2026
Building your own Fabric Open Mirroring Solution - 2026
F is for Fabric - 2026
She-Ra and the Masters of the Dataverse - 2026
Fabric for Muppets - 2026
Open Mirroring: Rick and Morty’s Guide to Zero‑ETL Across the Multiverse - 2026
SQL Server 1.0 Mirroring - 2026
SQL Server Mirror Mirror on the Wall… - 2026