# Apache Iceberg

> A table format that many tools share. It hides how the files are split.

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

## Think of it like

It is like a list on a toy box. It says which toys are in the box today.

## Definition

Apache Iceberg is an open table format for huge tables in a data lake. It tracks which files make up the table, in layers of small files. Each change makes a new snapshot of the table. Many engines can use the same tables, such as Spark, Trino, Flink and Snowflake. It hides how files are split, so queries do not need to know. Old snapshots let you go back in time.

## Example

A bank keeps one Iceberg orders table. Its analysts query it from Trino while a Spark job writes new rows.

## Example code

```sql
CREATE TABLE lake.shop.orders (
  id BIGINT, ts TIMESTAMP, total DECIMAL(10,2))
USING iceberg
PARTITIONED BY (days(ts));
```

In Spark SQL. Files are split by day, but queries just filter on ts.

## Why it matters

It keeps data free of any one engine. You can change tools without moving the data.

## Common mistake

Never cleaning up old snapshots. Each one keeps old files alive, and storage costs climb.

## Three principles

- **Many engines.** One table, many tools.
- **Hidden partitions.** Queries need not know the file layout.
- **Snapshots.** Each change makes a version you can read.

## Related terms

- [Open Table Format](https://learn.benibix.com/term/data/open-table-format)
- [Delta Lake](https://learn.benibix.com/term/data/delta-lake)
- [Apache Hudi](https://learn.benibix.com/term/data/apache-hudi)
- [Data Lakehouse](https://learn.benibix.com/term/data/data-lakehouse)
- [Time Travel Query](https://learn.benibix.com/term/data/time-travel)

## 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/apache-iceberg
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.
