jargon

Data engineering·Files, formats and table layers

the data is in typed, governed tables you query in SQL, and getting anything in means agreeing a schema first.

Data warehouse

Also calledwarehouse, analytical database

A managed analytical database holding modelled, typed data, optimised for large aggregate queries. You get transactions, a query planner, permissions and predictable performance in exchange for a schema up front and, historically, storage you could not read with anything else. The modern versions blur into the lakehouse, so the meaningful distinction is no longer where bytes live but whether writes are governed and typed.

Commonly confused with