Data lake vs data warehouse vs lakehouse, and ETL vs ELT.

Answer preview

These are three generations of analytical storage. A data warehouse stores curated, schema-on-write tables for BI; a data lake stores raw files of any shape cheaply, schema-on-read; a lakehouse puts warehouse-grade table semantics (ACID transactions, schema enforcement, time trav…