cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How far back can I Time Travel on a Delta table?

User16826992666
Valued Contributor
 
1 REPLY 1

User16869510359
Esteemed Contributor

To time travel to a particular version, it's necessary to have the JSON file for that particular version. the JSON files in the delta_log have default retention of 30 days. So by default, we can time travel only up to 30 days.

The retention of the Delta log JSON files can be increased.

%sql

ALTER TABLE table-name 

SET TBLPROPERTIES ('delta.logRetentionDuration'='40 days')