Data Warehouse
A central repository of structured, cleaned data optimized for analytical queries. Snowflake, BigQuery, and Redshift are purpose-built data warehouses.
What is Data Warehouse?
A central repository of structured, cleaned data optimized for analytical queries. Snowflake, BigQuery, and Redshift are purpose-built data warehouses.
Data Warehouse is a advanced concept that sits in the Stream & Batch Processing area of system design. Engineers reach for it whenever they need to reason about real-world trade-offs in that space — not just for textbook correctness, but because real production systems at companies like Netflix, Amazon, and Google make these decisions every day.
If you want to go deeper than this definition — with diagrams, code, and a quiz to lock it in — work through the "Data Warehouse" lesson linked below. It walks through the why, the mechanism, the trade-offs, and how the giants actually use it in production.
Learn Data Warehouse in depth
Full interactive lesson with diagrams, code examples, real-world references, and a quiz.
Open the Data Warehouse lessonRelated lessons
Lessons that touch on Data Warehouse as part of a larger topic.
Bitmap Index
Bit arrays that make low-cardinality queries blazing fast, the secret weapon of data warehouses
intermediate · database types storage
Data Warehousing
Centralized repositories optimized for analytical queries, how companies turn raw data into business decisions
intermediate · database types storage
See also
Related glossary terms you might want to look up next.
Data Lake
A centralized repository that stores raw data at any scale in its native format. Unlike a data warehouse, data doesn't need to be structured or cleaned before loading.
ETL
Extract, Transform, Load: a pipeline that extracts data from sources, transforms it into the desired format, and loads it into a destination like a data warehouse.
Batch Processing
Processing large volumes of data in scheduled chunks rather than in real time. Think nightly reports, ETL jobs, and data warehouse loads.