SHOW TABLE PROPERTIES

Returns the configuration properties (tblproperties) stored in a Delta table's metadata, displayed as key-value pairs.

Category: table-infoDeltaForge extension

Syntax

SHOW TABLE PROPERTIES <table>

Description

## Overview SHOW TABLE PROPERTIES reads the configuration map from a Delta table's metadata and returns all key-value pairs as a result set. Table properties control Delta-specific behaviors such as auto-optimization, log retention, deletion vectors, change data feed, and custom application metadata. ## Behavior The engine opens the Delta table, reads the latest snapshot metadata, and extracts the configuration map. The result set has two columns: | Column | Type | Description | |--------|------|-------------| | key | UTF8 | The property name (e.g., delta.autoOptimize.autoCompact, delta.logRetentionDuration). | | value | UTF8 | The property value as a string. | All properties stored in the Delta metadata configuration map are included. Properties are returned in their stored order. ### Common Properties | Property | Description | |----------|-------------| | delta.autoOptimize.autoCompact | Enables automatic file compaction after writes. | | delta.autoOptimize.optimizeWrite | Enables write optimization (bin-packing). | | delta.logRetentionDuration | How long commit log entries are retained (e.g., "interval 30 days"). | | delta.deletedFileRetentionDuration | Minimum age of deleted files before VACUUM can remove them. | | delta.enableChangeDataFeed | Enables Change Data Feed (CDC) for the table. | | delta.enableDeletionVectors | Enables deletion vectors for metadata-only deletes. | | delta.clusteringColumns | Comma-separated list of liquid clustering columns. | | delta.bloomFilter.* | Bloom filter configuration per column. | Custom properties set by users via ALTER TABLE SET TBLPROPERTIES are also included. The execution result message reports the table name and the total number of properties returned. ## Compatibility SHOW TABLE PROPERTIES follows the same syntax as the Delta Lake SHOW TBLPROPERTIES command. It is also compatible with the standard SQL SHOW TABLE PROPERTIES syntax.

Parameters

Name	Type	Description
`table`		Specifies the name or path of the Delta table whose properties to display. The table must be registered in the session via CREATE DELTA TABLE or OPEN DELTA TABLE. Fully qualified names (zone.schema.table) are supported.

Examples

-- List all properties of a table
SHOW TABLE PROPERTIES warehouse.sales.orders;

-- Check properties after setting auto-optimize
SHOW TABLE PROPERTIES gold.analytics.revenue;

-- Inspect properties of a table with bloom filters
SHOW TABLE PROPERTIES warehouse.inventory.products;

Pitfalls

If a table has no properties set, the result set will be empty. This is normal for tables created without TBLPROPERTIES and never modified with ALTER TABLE SET TBLPROPERTIES.
Properties are stored as string values. Boolean properties like delta.enableChangeDataFeed are stored as the strings "true" or "false", not as native boolean values.
Internal Delta properties (e.g., delta.minReaderVersion, delta.minWriterVersion) are managed through the protocol, not through tblproperties. Use DESCRIBE DETAIL to see protocol version information.