system.iceberg_history

System iceberg snapshot history

Description

This system table contains the snapshot history of Iceberg tables existing in ClickHouse. It will be empty if you don’t have any Iceberg tables 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.
• operation (Enum8(‘UNKNOWN’ = -1, ‘APPEND’ = 0, ‘OVERWRITE’ = 1, ‘DELETE’ = 2, ‘REPLACE’ = 3)) — Snapshot operation (APPEND, OVERWRITE, DELETE, REPLACE and UNKNOWN). The UNKNOWN status means either that we were unable to read the summary or that it is empty (it’s optional for v1). The correct ‘operation’ field is required
• summary (Map(String, String)) — Snapshot summary fields