These settings are available in system.settings and are autogenerated from source.
iceberg_delete_data_on_drop
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.9 | 0 | New setting |
Whether to delete all iceberg files on drop or not.
iceberg_delete_manifest_decode_concurrency
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.8 | 4 | New 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 featureVersion history
| Version | Default value | Comment |
|---|---|---|
| 26.7 | 30 | New 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
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.5 | 1000 | New setting |
Threshold for compaction data files in iceberg.
iceberg_orphan_files_older_than_seconds
Experimental featureVersion history
| Version | Default value | Comment |
|---|---|---|
| 26.4 | 259200 | New 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
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.4 | 0 | New setting. |
Query Iceberg table using the specific snapshot id.
iceberg_timestamp_ms
Version history
| Version | Default value | Comment |
|---|---|---|
| 25.4 | 0 | New setting. |
Query Iceberg table using the snapshot that was current at a specific timestamp.