Azure Synapse Link for Dataverse Implementation

on YouTube ↗21m

" summary

Azure Synapse Link for Dataverse continuously exports Dataverse into ADLS Gen2 and can optionally create a lake database (external tables built by the Apache Spark engine) that queries with serverless SQL; it guarantees a 15-minute SLA for changes and produces T-minus-one-hour snapshots for stable reads. Three export modes matter: In-place updates (no history), Append-only (history, partitions default to year for append), and Incremental refresh (new CSVs every >=15 minutes). Requirements: same region, ADLS public network enabled for initial sync, and expect occasional bulk-load errors while CSVs are being written.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 0:23Agenda
3. 1:03What is Synapse Link for Dataverse?
4. 14:20Advanced Configuration Options ปี
5. 14:53Key takeaways

" related talks

• 23mSynapse Link to SQL, bring your on-prem data aliveJosé Barbosa · SQLBits 2022
• 19mNever ETL again, thanks to Synapse Link. Really?Ben Weissman · SQLBits 2022
• 58mAzure Data Lake & Synapse Server less ArchitecturePrince Kher · Global Azure Virtual 2021
• 49mAzure Synapse AnalyticsJames Serra · SQLBits 2020
• 53mAzure Synapse Analytics: Evolving Azure SQL Data WarehouseMark Pryce-Maher, Artur Vieira · SQLBits 2020
• 46mThe Ultimate Jigsaw - Architecting Azure Synapse AnalyticsHeini Ilmarinen · Women Data Summit 2021
• 36mData Lakes with Azure DatabricksDustin Vannoy · Data Con LA 2020
• 54mAn introduction to Azure Synapse Analytics!Mahesh Balija · SQLBits 2020