Table Properties¶

Delta Lake allows setting up table properties for a custom behaviour of a delta table.

delta Prefix¶

All table properties start with delta. prefix.

SHOW TBLPROPERTIES¶

Table properties can be displayed using SHOW TBLPROPERTIES SQL command:

SHOW TBLPROPERTIES <table_name> [(comma-separated properties)]

sql("SHOW TBLPROPERTIES delta.`/tmp/delta/t1`").show(truncate = false)

+----------------------+-----+
|key                   |value|
+----------------------+-----+
|delta.minReaderVersion|1    |
|delta.minWriterVersion|2    |
+----------------------+-----+

sql("SHOW TBLPROPERTIES delta.`/tmp/delta/t1` (delta.minReaderVersion)").show(truncate = false)

+----------------------+-----+
|key                   |value|
+----------------------+-----+
|delta.minReaderVersion|1    |
+----------------------+-----+

ALTER TABLE SET TBLPROPERTIES¶

Table properties can be set a value or unset using ALTER TABLE SQL command:

ALTER TABLE <table_name> SET TBLPROPERTIES (<key>=<value>)

ALTER TABLE table1 UNSET TBLPROPERTIES [IF EXISTS] ('key1', 'key2', ...);

sql("ALTER TABLE delta.`/tmp/delta/t1` SET TBLPROPERTIES (delta.enableExpiredLogCleanup=true)")

sql("SHOW TBLPROPERTIES delta.`/tmp/delta/t1` (delta.enableExpiredLogCleanup)").show(truncate = false)

+-----------------------------+-----+
|key                          |value|
+-----------------------------+-----+
|delta.enableExpiredLogCleanup|true |
+-----------------------------+-----+