iceberg_* session settings

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_file_entries_queue_size

Capacity of the queue between the Iceberg data manifest decode tasks and the query, in data file entries. The decode tasks pause once the queue is full and the query is not consuming, so this also bounds the read-ahead. Must be greater than zero.

​

iceberg_manifest_decode_concurrency

Aliases: iceberg_delete_manifest_decode_concurrency Maximum number of Iceberg manifest files decoded concurrently while reading a table. Delete manifests are all decoded before any data file is read; data manifests are decoded while the list of data files for the query is produced, and new ones are decoded only as the query consumes already decoded entries. Decoding several manifests at a time overlaps the object storage round-trips and the per-entry pruning work. Higher values raise peak memory 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.