A lakehouse combines the inexpensive storage of a data lake with the features of a warehouse: ACID transactions, enforced schema, version history and high-performance SQL queries. It relies on open table formats on top of columnar files, such as Delta Lake or Apache Iceberg, and avoids duplicating data between lake and warehouse.
Example
CREATE TABLE ventes USING DELTA AS SELECT * FROM brut.ventes;