A Deep Dive into Microsoft Fabric Data Warehouse

on YouTube ↗51m

" summary

Microsoft Fabric Data Warehouse stores tables as Delta tables (Parquet + Delta log) on OneLake, queryable via a SQL analytics endpoint from SSMS/Azure Data Studio (no SQL auth, Entra auth only). Demos show Spark/lakehouse access, creating shortcuts to warehouse tables, and instant shallow clone (no data copy, just new Delta log). Mirroring via CDC to Delta is announced for end of Q1 preview; F2 capacity costs about $0.36/hr. Permissioning supports workspace and per-artifact grants plus normal T‑SQL GRANTs.

AI-written summary · about

" chapters (16)

1. 0:00Microsoft Fabric Data Warehouse intro
2. 1:30Fabric Data Warehouse service
3. 3:20Fabric workspace and warehouse setup
4. 7:15Fabric Data Warehouse myths
5. 11:29Tables stored as Delta files
6. 15:31Delta tables with Azure Storage Explorer
7. 21:53Connect to warehouse with SQL tools
8. 26:48Share data warehouse and lakehouse
9. 28:32Lakehouse and SQL analytics endpoint
10. 34:31Scaling SQL endpoints and shortcuts
11. 36:00Cloning tables in warehouse
12. 38:07Permissions and access sharing
13. 42:23Mirroring external data
14. 46:40Fabric cost and features
15. 47:44Future partitioning and limits
16. 49:10Closing remarks

" related talks

• 46mMicrosoft Fabric Synapse data warehouse Q&AOlivia Shea, Joanna Podgoetsky, Priya Sathy, Shawndell Elfring, Bogdan Crivat, Steve Howard, Faisal Mohamood · Microsoft Build 2023
• 44mUnify your data with OneLake and Microsoft FabricAbhishek Narain, Joshua Caplan, Harmeet Gill, Salil Kanade, Swetha Mannepalli, Aaron Merrill, Miwa Monji, Trevor Olson, Joanna Podgoetsky, Mark Pryce-Maher, Charles Webb · Microsoft Build 2024
• 47mData analytics for the era of AIPatrick Baumgartner, Amir Netz, Swetha Mannepalli, Miwa Monji, Arun Ulagaratchagan, Justyna Lucznik, Ron Chang, Thasmika Gokal, Nimrod Shalit, Nandini Srinivasan · Microsoft Build 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
• 30mDataEngBytes 2023 - BRI-T1-04 - Mimoune DjouallahMimoune Djouallah · DataEngBytes Brisbane 2023
• 44mDeep-Dive into Delta LakeGerhard Brueckl · Øredev 2025
• 48mAccelerate insights with real-time Azure SQL data and Microsoft FabricBob Ward, Anna Hoffman · Microsoft Build 2024
• 27mModernize your data integration to enable petabyte scale analytics with Microsoft FabricWee Hyong Tok, Shireen Bahadur · Microsoft Build 2023