Comparison
Data warehousevsOLTP
Data warehouse
the data is in typed, governed tables you query in SQL, and getting anything in means agreeing a schema first.
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.
Full entry →OLTP
your queries touch a handful of rows by key, thousands of times a second, and each one has to come back in milliseconds.
The workload shape of an application database: small reads and writes by primary key, high concurrency, low latency per statement. Row-oriented storage and B-tree indexes exist for this shape. Running a analytical scan against the same instance is how one report takes the product down.
Full entry →