Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

on YouTube ↗20m

" summary

Compares three offerings by concrete tradeoffs: Azure Data Factory is a standalone orchestration and ETL service good for cross-vendor architectures, but mapping data flows and data movement can be costly; Azure Synapse is the earlier unified platform with a dedicated SQL data warehouse for PB-scale control and a cheap option via serverless SQL cost <£1/month on small workloads; Microsoft Fabric is a SaaS built on OneLake with workspace-level governance, lakehouse-first storage, and optional reserved capacity pricing for predictable monthly costs.

AI-written summary · about

" chapters (7)

1. 0:00Introduction and context
2. 1:52Azure Data Factory overview
3. 3:03Azure Synapse Analytics
4. 8:01Introduction to Microsoft Fabric
5. 11:14Choosing the right tool
6. 14:38Pricing models comparison
7. 17:17Future outlook and Q&A

" related talks

• 40mAzure Data Factory, Azure Databricks, or Azure Synapse Analytics? When to use what.Lisa Hoving · SQLBits 2023
• 50mMicrosoft Fabric Data Factory Q&AWee Hyong Tok, Olivia Shea, Nellie Gustafsson, Justyna Lucznik, Shawndell Elfring, Miquella de Boer, Chris Finlan, Cristin Ford, Mark Kromer, Martin Lee, Piero Morano · Microsoft Build 2023
• 27mModernize your data integration to enable petabyte scale analytics with Microsoft FabricWee Hyong Tok, Shireen Bahadur · Microsoft Build 2023
• 19mAccelerate your data potential with FabricSwetha Mannepalli · Microsoft Build 2023
• 55mAzure SQL database, Azure Synapse Analytics, Azure Databricks?Dinesh Kumar · Global Azure Virtual 2021
• 46mMicrosoft Fabric Synapse data warehouse Q&AOlivia Shea, Joanna Podgoetsky, Priya Sathy, Shawndell Elfring, Bogdan Crivat, Steve Howard, Faisal Mohamood · Microsoft Build 2023
• 20mChoosing the Right Data Store--An Overview of Azure Data Platform ChoicesJoey D'Antoni · SQLBits 2023
• 50mAzure Data Factory patterns and best practicesShirley Wang · SQLBits 2020