Skip to main content

Description

This system table contains the metadata files of Iceberg tables existing in ClickHouse, with one row per metadata file. It will be empty if you don’t have any Iceberg tables in ClickHouse.

Columns

  • database (String) — Database name.
  • table (String) — Table name.
  • timestamp (DateTime64(3)) — Date & time when this metadata file was made current.
  • file (String) — Path of the metadata file.
  • latest_snapshot_id (Nullable(UInt64)) — Id of the latest snapshot at the time of this metadata file.
  • latest_schema_id (Nullable(Int32)) — Schema id of the latest snapshot.
  • latest_sequence_number (Nullable(Int64)) — Sequence number of the latest snapshot.