Skip to main content
Skip to main content
Edit this page

system.iceberg_history

This system table contain the snapshot history of Iceberg tables existing in ClickHouse. It will be empty if you don't have any Iceberg table in ClickHouse.

Columns:

  • database (String) — The name of the database the table is in.

  • table (String) — Table name.

  • made_current_at (DateTime) — Time when the snapshot was made current snapshot.

  • snapshot_id (Int64) — Snapshot id.

  • parent_id (Int64) - Snapshot id of the parent snapshot.

  • is_current_ancestor (Bool) - Flag that indicates whether this snapshot is an ancestor of the current snapshot.