Skip to main content
Version: current [25.x]

Supported Properties of Apache Iceberg Tables

You can use table properties to configure many aspects of Iceberg tables. The full list of table properties is here. Dremio supports the following subset of table properties, which you can set when you create or alter an Iceberg table:

PropertyDescriptionOption
commit.manifest.target-size-bytesThe target size when merging manifest files.8 MB
commit.status-check.num-retriesThe number of times to check whether a commit succeeded after a connection is lost before failing due to an unknown commit state.3
format-versionThe table’s format version (can be 1 or 2), as defined in the Spec.1
history.expire.max-snapshot-age-msThe default maximum age of snapshots to keep while expiring snapshots.432000000 (5 days)
history.expire.min-snapshots-to-keepThe default minimum number of snapshots to keep while expiring snapshots.1
write.delete.modeThe table’s method for handling row-level deletes. See Row-Level Changes on the Lakehouse: Copy-On-Write vs. Merge-On-Read in Apache Iceberg for more information on which mode is best for your table’s DML operationscopy-on-write (default) or merge-on-read
write.merge.modeThe table’s method for handling row-level merges. See Row-Level Changes on the Lakehouse: Copy-On-Write vs. Merge-On-Read in Apache Iceberg for more information on which mode is best for your table’s DML operationscopy-on-write (default) or merge-on-read
write.update.modeThe table’s method for handling row-level updates. See Row-Level Changes on the Lakehouse: Copy-On-Write vs. Merge-On-Read in Apache Iceberg for more information on which mode is best for your table’s DML operations‘copy-on-write’ (default) or ‘merge-on-read’
write.metadata.delete-after-commit.enabledControls whether to delete the oldest tracked version metadata files after commit.FALSE
write.metadata.previous-versions-maxThe maximum number of previous version metadata files to keep before deleting after commit.100
write.parquet.compression-codecThe Parquet compression codec. Allowed values: zstd, gzip, snappysnappy
write.parquet.compression-levelThe Parquet compression level. From the currently supported codecs only ZSTD allows setting the compression level.null

To view the properties that are set for a table, use the SQL command SHOW TBLPROPERTIES.