# Delta Lake

> A table format first made by Databricks. It is Parquet files plus a log of changes.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Delta Table, Delta Format

## Think of it like

It is like a diary next to a photo book. Each page says which photos came in or went out.

## Definition

Delta Lake is an open table format first built by Databricks. It stores data as Parquet files plus a folder called _delta_log. Each change adds a new entry to that log. The log gives safe, all-or-nothing writes, even with many writers. You can read the table as it was at any past version.

## Example

A job deletes one customer's rows to meet a privacy request. Delta writes new files and logs the change as version 42.

## Example code

```sql
CREATE TABLE orders (id BIGINT, total DOUBLE) USING DELTA;
DESCRIBE HISTORY orders;
```

Make a Delta table, then list every change the log has recorded.

## Why it matters

It is the main table format on Databricks. So a large share of lakehouse data is kept in it.

## Common mistake

Copying the Parquet files but not the _delta_log folder. The files are not the table without the log.

## Three principles

- **Parquet underneath.** The data is plain Parquet files.
- **The _delta_log.** A log of every change.
- **Versions.** Any past version can be read.

## Related terms

- [Open Table Format](https://learn.benibix.com/term/data/open-table-format)
- [Apache Iceberg](https://learn.benibix.com/term/data/apache-iceberg)
- [Apache Hudi](https://learn.benibix.com/term/data/apache-hudi)
- [Apache Parquet](https://learn.benibix.com/term/data/apache-parquet)
- [Time Travel Query](https://learn.benibix.com/term/data/time-travel)
- [OpenSharing](https://learn.benibix.com/term/data/opensharing)

## Told apart from

- [Apache Iceberg vs Delta Lake](https://learn.benibix.com/compare/apache-iceberg-vs-delta-lake): People think Iceberg and Delta Lake store data in different ways, and they do not. Both keep plain Parquet files and add a log of which files make up each version. Delta Lake began at Databricks and fits best there. Iceberg began at Netflix and is read by the widest mix of engines. Pick by the engines you run.

---

Source: https://learn.benibix.com/term/data/delta-lake
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.
