A data warehouse is storage for data that has been cleaned, deduplicated, and modeled into tables with agreed meanings, ready for SQL queries and reporting. This is where “one version of the truth” lives and where BI dashboards point. When the marketing platform’s numbers and finance’s numbers disagree, the warehouse is the referee. Common platforms include BigQuery, Snowflake, and Redshift.
Category
Data Architecture
Also known as
warehouse; DWH; BigQuery; Snowflake
In practice
In a level-2 architecture the warehouse is the third corner: tracking feeds Bloomreach, raw events flow onward into the warehouse (often BigQuery), and computed attributes and audiences flow back into activation tools. History lives there at warehouse prices instead of platform prices, models train on it, and campaigns act on what it computes.