These settings are available in system.settings and are autogenerated from source.
iceberg_delete_data_on_drop
Whether to delete all iceberg files on drop or not.
iceberg_delete_manifest_decode_concurrency
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
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
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. Last modified on August 24, 2026