Table Properties

Delta table properties that control auto-optimize, deletion vectors, statistics, clustering, retention, and Universal Format.

Auto Analyze

• delta.autoAnalyze.columns
• delta.autoAnalyze.computeHistograms
• delta.autoAnalyze.enabled
• delta.autoAnalyze.minChangeRatio
• delta.autoAnalyze.minNewRows

Auto Optimize

• delta.autoOptimize.autoCompact
• delta.autoOptimize.enabled
• delta.autoOptimize.minSmallFiles
• delta.autoOptimize.optimizeWrite
• delta.autoOptimize.smallFileThreshold
• delta.autoOptimize.targetFileSize
• delta.autoOptimize.useZOrder
• delta.autoOptimize.zorderColumns
• delta.targetFileSize
• delta.tuneFileSizesForRewrites

Auto Vacuum

• delta.autoVacuum.enabled
• delta.autoVacuum.minOrphanBytes
• delta.autoVacuum.minOrphanFiles

Catalog

• delta.catalogManaged
• delta.catalogProvider
• delta.glue.database

Checkpointing

• delta.checkpoint.writeStatsAsJson
• delta.checkpoint.writeStatsAsStruct
• delta.checkpointInterval

Clustering

• delta.clustering
• delta.clusteringColumns
• delta.clusteringProvider
• delta.liquidClustering.enabled

Column Metadata

• delta.columnDefault
• delta.defaultExpression
• delta.generationExpression

Constraints

• delta.constraints.<name>
• delta.invariants

Core Features

• delta.appendOnly
• delta.cdc.retentionHours
• delta.columnMapping.maxColumnId
• delta.columnMapping.mode
• delta.enableChangeDataFeed
• delta.enableTypeWidening
• delta.typeChanges

Data Skipping

• delta.bloomFilter.columns
• delta.bloomFilter.fpp
• delta.bloomFilter.numItems
• delta.dataSkipping.bloomFilter.columns
• delta.dataSkippingNumIndexedCols
• delta.dataSkippingStatsColumns

Deletion Vectors

• delta.enableDeletionVectors

Feature Flags

• delta.feature.allowColumnDefaults
• delta.feature.checkConstraints
• delta.feature.domainMetadata
• delta.feature.generatedColumns
• delta.feature.icebergCompatV1
• delta.feature.icebergCompatV2
• delta.feature.icebergCompatV3
• delta.feature.identityColumns
• delta.feature.inCommitTimestamp
• delta.feature.invariants
• delta.feature.rowTracking
• delta.feature.timestampNtz
• delta.feature.typeWidening
• delta.feature.v2Checkpoint
• delta.feature.vacuumProtocolCheck
• delta.feature.variantType

Graph

• delta.forge.graph.autoUpdateCsr

Identity Columns

• delta.enableIdentityColumns
• delta.identity.allowExplicitInsert
• delta.identity.blockAllocationSize
• delta.identity.start
• delta.identity.step

Incremental Loading

• delta.forge.incremental.columns
• delta.forge.incremental.dateColumn
• delta.forge.incremental.dialect
• delta.forge.incremental.filter
• delta.forge.incremental.overlapDays

Log Retention

• delta.deletedFileRetentionDuration
• delta.logCompaction.maxLogFiles
• delta.logCompaction.minLogFiles
• delta.logCompactionEnabled
• delta.logRetentionDuration
• delta.setTransactionRetentionDuration

Parquet

• delta.parquet.compression.codec

Predictive Optimization

• delta.predictiveOptimization.enabled
• delta.predictiveOptimization.maxConcurrent
• delta.predictiveOptimization.minIntervalHours
• delta.predictiveOptimization.schedule

Protocol

• delta.isolationLevel
• delta.minReaderVersion
• delta.minWriterVersion

Row Tracking

• delta.enableRowLevelConcurrency
• delta.enableRowTracking
• delta.rowLevelConcurrency.maxDVBytes
• delta.rowLevelConcurrency.maxDVsToLoad
• delta.rowTracking.highWaterMark
• delta.rowTracking.preserved

Statistics

• delta.lastAnalyzeTime
• delta.lastOptimizeTime
• delta.lastVacuumTime
• delta.statistics.histograms

Universal Format

• delta.universalFormat.enabledFormats
• delta.universalFormat.icebergDeleteMode
• delta.universalFormat.icebergEqualityColumns
• delta.universalFormat.icebergRelativePaths
• delta.universalFormat.icebergVersion

Workload Awareness

• delta.workloadAware.enabled
• delta.workloadAware.preferredHours