Where Do the Columns Come From?

Failed to add items

Sorry, we are unable to add the item because your shopping cart is already at capacity.

Add to basket failed.

Please try again later

Add to wishlist failed.

Please try again later

Remove from wishlist failed.

Please try again later

Adding to library failed

Please try again

Follow podcast failed

Unfollow podcast failed

Where Do the Columns Come From?

Listen for free

View show details

This Season's Biggest Deal | £0.99/mo for 3 months + £10 Audible bonus

£5.99/mo after 3 months - terms apply. Cancel monthly

Summary

Where Do the Columns Come From? Episode 40 • 2026-09-25 Duration: 9:19 Cosmos DB has no schema. Delta tables need one. When mirroring bridges the two, the replicator guesses — and the guess only ever widens. We trace where the bytes come from, why renamed properties leave ghost columns full of nulls, and what stop replication actually does. What we discuss How it actually works underneath the abstractionThe pattern we keep seeing in the fieldA real Reddit/Microsoft Q&A question unpackedWhere the obvious answer breaksRisks of the recommended pathF-SKU realism — what this actually costsWhen the rejected approach is actually rightThe concrete recommended architectureThe architectural principle to take home Key takeaways Somewhere right now a Cosmos container is taking writes.And match your Fabric capacity region to the Cosmos account.Three questions before you touch anything. Watch the episode The Fabric Friday video on this topic: https://youtu.be/KJUBmoNFICo From the video 13:19 The Discovered Schema16:20 Nested Data Arrives as a String18:47 Stop Is Not Pause2:53 Demo: Create the Mirror, Count the Rows Resources Mirroring Azure Cosmos DBCosmos DB mirroring FAQcontinuous backupCosmos DB mirroring limitationsMigrate an Azure Cosmos DB account from periodic to continuous backup modeMigrate from Azure Synapse Link to Cosmos DB mirroringAccess mirrored data in Lakehouse and notebooksHow to: Query nested dataConfigure private networks for Azure Cosmos DB Fabric MirroringtutorialMonitor Fabric mirrored database replicationMirroring public REST APICost of mirroringMirrored database in Fabric (all sources)Cosmos DB in Microsoft Fabric (native item) About the show AI-generated voices. Matthias — cloned voice. Fabia — designed AI co-host. See Matthias live on YouTube (Fabric Friday), at his meetups, and at conferences like FabCon. Hosted by Matthias Falland — Microsoft Data Platform MVP and community architect behind the Fabric Periodic Table. New episodes every Friday. Submit your case Have an architecture decision you are wrestling with? DM Matthias on LinkedIn — find him as Matthias Falland. Three to five sentences about the decision, your team size, and your current stack. We anonymize before airing. This podcast was generated by AI. Both voices are synthetic: Matthias is a cloned voice, Fabia is a designed AI co-host. Brand design based on fabricperiodictable.com.

No reviews yet