Set up docs MCPDescription
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 snapshotsnapshot_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 requiredsummary(Map(String, String)) — Snapshot summary fields