https://delta.io logo
y

Yatharth Maheshwari

01/05/2023, 7:29 AM
Hi all, How can I check the default table properties ? I want to check the default properties before I run the Alter table command, to be specific delta.logRetentionDuration
Also does this expression look fine. I find interval in the expressions quite odd.
Copy code
spark.sql(s"ALTER TABLE default.dpm_delta SET TBLPROPERTIES (delta.logRetentionDuration = 'interval 60 days') ")
👍 1
@abhijeet_naib / @Nick Karpov Can you please help with this.
n

Nick Karpov

01/05/2023, 8:05 PM
How can I check the default table properties ?
logRetention
(and many others configs) are not necessarily stored in the table metadata itself as default values. In this case specifically,
logRetention
default value is defined by the implementation (see DeltaConfig) when not explicitly stored in the table metadata
8 Views