Skip to content
ClickHouse Docs

iceberg_* session settings

Autogenerated from ClickHouse system tables

These settings are available in system.settings and are autogenerated from the ClickHouse snapshot.

iceberg_delete_data_on_drop

Whether to delete all iceberg files on drop or not.

iceberg_manifest_min_count_to_compact

Minimum number of manifest files required to trigger manifest-only compaction via OPTIMIZE TABLE … MANIFEST. If the current number of manifest files is less than or equal to this threshold, compaction is skipped. Requires allow_experimental_iceberg_compaction to be enabled.

The default mirrors the documented default of the Iceberg table property commit.manifest.min-count-to-merge (100), see https://iceberg.apache.org/docs/1.5.2/configuration/.

iceberg_max_number_datafiles_to_compact

Threshold for compaction data files in iceberg.

iceberg_orphan_files_older_than_seconds

Default age threshold in seconds for orphan file removal in Iceberg tables. Files newer than this are not considered orphans. Used when the older_than argument is omitted from the remove_orphan_files() procedure call. Default is 259200 (3 days).

iceberg_snapshot_id

Query Iceberg table using the specific snapshot id.

iceberg_timestamp_ms

Query Iceberg table using the snapshot that was current at a specific timestamp.