Data warehouse

A data warehouse is the central database a company uses to store and query its analytics data. Common ones include BigQuery, Snowflake, Redshift, Databricks, and Postgres.

For agentic analytics the warehouse is the source of truth. The agent writes SQL and runs it against the warehouse to get real numbers, rather than working from a copy or a guess. An agent that cannot reach your warehouse cannot give you a real answer.

Why it matters for an agent

The warehouse holds the data, but it does not hold the meaning. The tables do not explain that revenue excludes refunds. That meaning comes from the semantic layer and the wider work of context engineering, which sit between the agent and the raw tables.