Skip to main content

​
Description

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) — Database name.
  • table (String) — Table name.
  • made_current_at (Nullable(DateTime64(3))) — Date & time when this snapshot was made current snapshot
  • snapshot_id (UInt64) — Snapshot id which is used to identify a snapshot.
  • parent_id (UInt64) — Parent id of this snapshot.
  • is_current_ancestor (UInt8) — Flag that indicates if this snapshot is an ancestor of the current snapshot.