What is a data warehouse?

The database that takes a shop's orders is built to write one order at a time, quickly, all day. Ask it for last year's sales by region and month, and it has to read millions of rows while customers are still checking out. A data warehouse exists so that question has somewhere else to go.

Built for questions, not for transactions

A warehouse collects data from the systems that run the business (orders, payments, stock, the CRM) into one place, cleaned and arranged for analysis. It began as a tool for decision support: reports and dashboards for the people running the company.

Data goes in schema-on-write. Before a row is stored it must fit a table whose columns, types and meaning were designed in advance, usually around the questions the business asks. That up-front work is why warehouse numbers are trusted, and why reports on them are fast.

What the first warehouses could not do

The first generation ran as appliances in a company's own data centre, with storage and computing power in one box. You paid for enough of both to cover your busiest day, and as data grew, so did the bill.

They also only held tables. Video, audio and text documents could not be stored or queried at all. As more of a company's data took those forms, it went somewhere cheaper: the data lakeData LakeCheap storage that holds data of any kind in its raw form, usually as files in cloud object storage, to be cleaned and structured later..

For about a decade the usual answer was both. Everything landed in a lake, and a cleaned subset was copied again into a cloud warehouse such as Redshift or Snowflake. That meant 2 copies, 2 bills for storage and a warehouse always a load or 2 behind. Many warehouses also kept data in their own formats, which made moving it costly. The LakehouseLakehouseOne store for all of an organisation's data: cheap files in cloud storage, as in a data lake, with the tables, transactions and fast queries of a data warehouse on top. grew out of that 2-tier setup: warehouse tables and guarantees on top of cheap open files.

What still makes something a warehouse

The products have changed; the job has not. A warehouse, or the warehouse layer of a lakehouse, is the place where data has agreed columns, agreed meaning and enough checking that a finance team will sign off a number from it. In the medallionMedallion ArchitectureOrganising a lakehouse in 3 layers of rising quality: bronze for raw data, silver for cleaned and joined data, and gold for tables shaped for reports and AI. pattern those are the gold tables.

Why it matters for AI

An assistant that answers "what was revenue last quarter?" is only as good as what it reads. If it reads raw order events, it has to guess whether refunds count and which currency to use. If it reads the warehouse's agreed tables, those choices were made once, by people, and checked.

That is why the warehouse matters more with AI, not less. The tables, and a semantic layerSemantic LayerOne shared definition of business terms and metrics, such as revenue or active customer, that reports, dashboards and AI assistants all read instead of writing their own. that names the metrics on them, are what turn text-to-SQLText-to-SQLA model turning a question in plain words into a database query, so people can ask the data directly. It is only as right as its knowledge of the tables and their meaning. from a guess into a lookup.