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 |
+-----------------------------+-----+