Microsoft Fabric Synapse data warehouse Q&A
summary
Microsoft Fabric ships a lake‑centric data warehouse that stores tables as OneLake delta parquet, exposes a SQL endpoint with T‑SQL and stored procedure support, and runs on serverless compute with MPP distribution for elastic scaling rather than fixed clusters. Power BI can use view‑ordered Parquet for high performance, notebooks and Spark read the same files, and shortcuts let SQL query ADLS Gen2 or S3 without copying. CICD/Git, a Monitoring Hub, universal capacity billing, and migration tooling are available or on the roadmap; GA date is not yet announced.
AI-written summary · about
chapters (16)
- 0:00Introduction
- 3:00Recap of capabilities
- 4:50Integration
- 7:30Universal Capacity
- 16:34Existing Synapse customers
- 21:58Latency
- 27:38Feedback
- 28:37Datamarts
- 31:09MPP Engine
- 31:58What is the data warehouse
- 35:25Will Fabric replace Azure SQL
- 36:33Will Fabric work with Power BI
- 38:20What version of Delta is 23
- 40:41Can I access query using other tools like Tableau
- 41:33Handson lab
- 43:01Monitoring Hub
related talks
51mA Deep Dive into Microsoft Fabric Data Warehouse
44mUnify your data with OneLake and Microsoft Fabric
52mNavigating Microsoft Fabric - Choosing the Right Workload for Your Needs
50mFabric: What's new and what's next
22mData Lakehouse Vs Data warehouse in Fabric, which is right for you
30mDataEngBytes 2023 - BRI-T1-04 - Mimoune Djouallah
50mZero to Lakehouse in Microsoft Fabric
25mAzure SQL MI & Fabric Fusion: A speed-session