Delta log retention

User16826990884 — Fri, 25 Jun 2021 18:46:25 GMT

Is there an impact on performance if I increase the Delta log retention to 3000?

Re: Delta log retention

DD_Sharma — Fri, 14 Apr 2023 07:28:43 GMT

There will be no performance impact if you want to keep " Delta log retention to 3000". However, it will increase the storage cost so it's not advisable to use a large number until really needed for the business use cases.
The default delta.logRetentionDuration is 30 days.
You need to use ALTER table command to modify the existing property value.

%sql

ALTER TABLE table_name

SET TBLPROPERTIES ('delta.logRetentionDuration' = '<number_of_days> days')