> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System iceberg snapshot history

# system.iceberg_history

<h2 id="description">
  Description
</h2>

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.

<h2 id="columns">
  Columns
</h2>

* `database` ([String](/reference/data-types/index)) — Database name.
* `table` ([String](/reference/data-types/index)) — Table name.
* `made_current_at` ([Nullable(DateTime64(3))](/reference/data-types/index)) — Date & time when this snapshot was made current snapshot
* `snapshot_id` ([UInt64](/reference/data-types/index)) — Snapshot id which is used to identify a snapshot.
* `parent_id` ([UInt64](/reference/data-types/index)) — Parent id of this snapshot.
* `is_current_ancestor` ([UInt8](/reference/data-types/index)) — Flag that indicates if this snapshot is an ancestor of the current snapshot.