Lakehouse vs. warehouse for big data
Introduction to Microsoft Fabric
Fiodar Sazanavets
Senior Software Engineer
Why Fabric has different data stores
Different work needs different storage
Lakehouses: raw and structured data
Warehouses store structured data
What is a lakehouse?
Like a flexible workshop
Raw files (CSV, JSON, Parquet) and tables
Useful for data engineering and data science
What is a warehouse?
Like a managed stockroom
Structured tables only
Designed for SQL-first analytics
Familiar to analysts and database users
Common lakehouse scenarios
Data arrives as files; originals kept
Transform files into tables
Common warehouse scenarios
Store curated business records
Use a consistent structure
The role of SQL for downstream analytics
Downstream analytics: work after data is stored
Querying, modeling, and reporting
Analyses need only a slice of the data
SQL defines which data to pull
How downstream analytics works
Data preparation layer: curated tables
Modeling layer: business metrics and relationships
Reporting layer: what end users read
Lakehouse vs. warehouse
Lakehouse
Stores raw files and tables
Read-only SQL analytics endpoint
Warehouse
Only stores tables
Full T-SQL, including INSERT and UPDATE
Let's practice!
Introduction to Microsoft Fabric
Preparing Video For Download...