/

/

Data warehouse

Data warehouse

Data warehouse

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.

Also known as

warehouse; DWH; BigQuery; Snowflake

In practice

In a level-2 architecture the warehouse is the third corner: tracking feeds Bloomreach Engagement, 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.

Discuss this term

A question, a bug, or outdated info? Tell us — it goes straight to the team, and we keep the glossary current.