Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

iceberg_* session settings

These settings are available in system.settings and are autogenerated from source.

iceberg_delete_data_on_drop

Type
Bool
Default
0
Version history
VersionDefault valueComment
25.90New setting

Whether to delete all iceberg files on drop or not.

iceberg_delete_manifest_decode_concurrency

Type
NonZeroUInt64
Default
4
Version history
VersionDefault valueComment
26.84New setting bounding how many Iceberg delete manifest files are decoded concurrently before the first row is read. Before 26.8 one manifest was decoded at a time with the next one's fetch already in flight, so `2` is the closest equivalent of the previous behavior, which put the sum of their object storage round-trips on the critical path before the first row.

Maximum number of Iceberg delete manifest files decoded concurrently during query execution before any data file is read.

All delete manifests must be decoded before any data file is read, so this work sits on the critical path before the first row is returned. Decoding several at a time overlaps both the object storage round-trips and the per-row pruning work.

Higher values raise peak memory during query initialization when the Iceberg metadata files cache is disabled or full, since each in-flight manifest then holds its own decoded contents.

Must be greater than zero; 1 decodes the manifests one at a time.

iceberg_manifest_min_count_to_compact

Experimental feature
Type
UInt64
Default
30
Version history
VersionDefault valueComment
26.730New setting to control manifest compaction for Iceberg tables.

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.

iceberg_max_number_datafiles_to_compact

Type
UInt64
Default
1000
Version history
VersionDefault valueComment
26.51000New setting

Threshold for compaction data files in iceberg.

iceberg_orphan_files_older_than_seconds

Experimental feature
Type
UInt64
Default
259200
Version history
VersionDefault valueComment
26.4259200New setting for default orphan file age threshold

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

Type
Int64
Default
0
Version history
VersionDefault valueComment
25.40New setting.

Query Iceberg table using the specific snapshot id.

iceberg_timestamp_ms

Type
Int64
Default
0
Version history
VersionDefault valueComment
25.40New setting.

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

Navigation