brickster_2018
Databricks Employee
Databricks Employee

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')