Architecture patterns of Azure Cosmos DB
summary
Shows five concrete patterns tying Azure Cosmos DB to Synapse: Synapse Link for Cosmos DB for near‑real‑time, no‑ETL analytics (analytical store is columnar; serverless SQL + Power BI queries >18,000 rows pay‑per‑scan), change feed processed with Mapping Data Flow (start‑from‑beginning, include system columns) into Azure SQL, Spark or parquet; mapping data flow demos write flattened rows to SQL and Power BI visuals update; custom partitioning (Preview) emits partitioned Parquet to ADLS Gen2 and enables partition pruning; all demos run end‑to‑end.
AI-written summary · about
chapters (6)
- 0:00Introduction and agenda
- 1:04Synapse link and change feed
- 3:06Architecture patterns
- 7:24Custom partitioning
- 9:53Demonstrations
- 26:05Conclusion and summary
related talks
15mUnleashing Potential: Design Patterns in Azure Cosmos DB
46mThe Ultimate Jigsaw - Architecting Azure Synapse Analytics
32mSynapse Serverless SQL Pool: SQL without database
49mAnalytics in SQL Server and Azure SQL Database
27mIntegrating Azure Cosmos DB with the Azure Ecosystem
54mSay Yes to NoSQL for the .NET SQL Developer
54mAn introduction to Azure Synapse Analytics!
53mAzure Synapse Analytics: Evolving Azure SQL Data Warehouse