The short answer
A data warehouse is a centralized analytics store of structured, governed tables optimized for SQL reporting and BI, not for running your app's transactions.
OLTP apps (Postgres, MySQL)
|
ETL / ELT / CDC
|
Data warehouse (Snowflake, BigQuery, Redshift, Synapse)
|
BI tools, analysts, metric layersTypical traits
- , or serverless SQL
- Star/snowflake schemas, facts and dimensions
- Strong typing, access control, documented marts
- Separated from production databases so heavy queries do not hurt apps
What you put there
Cleaned historical facts, dimensions, and business marts, not every raw forever (that often lives in a lake first).
Interview tip: "Warehouse = analytics SQL system fed from operational sources." Contrast with OLTP and with a raw data lake.