# Data Lakehouse

> A data lake with warehouse tools on top. One copy of the data serves all.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Lakehouse, Lakehouse Architecture

## Think of it like

It is like a lake with a tidy shelf built on top. The water stays, but now you can find things.

## Definition

A data lakehouse puts warehouse features on top of a data lake. The data stays as open files, often Parquet, on cheap storage. A table format adds a log that tracks which files make up each table. That log brings safe updates, fixed schemas and time travel. So one copy of data can serve both reports and machine learning.

## Example

A team keeps its sales data as Iceberg tables in the cloud. Analysts query them with SQL. Data scientists train models on the same files.

## Why it matters

There is no need to copy data from a lake into a warehouse. One copy costs less, and the numbers agree.

## Common mistake

Thinking it is a product you buy. It is a design, built from open files, a table format and a query engine.

## Three principles

- **Open files.** Data stays in formats like Parquet.
- **A table layer.** A log makes files act like tables.
- **One copy.** Reports and AI read the same data.

## Related terms

- [Data Lake](https://learn.benibix.com/term/data/data-lake)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Open Table Format](https://learn.benibix.com/term/data/open-table-format)
- [Medallion Architecture](https://learn.benibix.com/term/data/medallion-architecture)
- [Apache Iceberg](https://learn.benibix.com/term/data/apache-iceberg)
- [Fabric Lakehouse](https://learn.benibix.com/term/data/fabric-lakehouse)

## Told apart from

- [Data Lake vs Data Lakehouse](https://learn.benibix.com/compare/data-lake-vs-data-lakehouse): People think a lakehouse is a new kind of store you buy. It is a data lake with a table format on top. The files stay in the same cheap place. The table layer adds safe updates, fixed shapes and old versions, so the lake can serve reports too.

![Three stores side by side. A warehouse holds only clean tables. A lake holds raw files of every kind. A lakehouse keeps raw files in a lake and adds a table layer on top so they can be queried like a warehouse.](https://learn.benibix.com/diagrams/warehouse-lake-lakehouse.svg)

---

Source: https://learn.benibix.com/term/data/data-lakehouse
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
