https://community.databricks.com/t5/data-engineering/how-far-back-can-i-time-travel-on-a-delta-table/m-p/20396#M13751 <P>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. </P><P></P><P>The retention of the Delta log JSON files can be increased. </P><P></P><P>%sql</P><P>ALTER TABLE&nbsp;table-name&nbsp;</P><P>SET TBLPROPERTIES ('delta.logRetentionDuration'='40 days')</P> Thu, 24 Jun 2021 23:32:47 GMT brickster_2018 2021-06-24T23:32:47Z https://community.databricks.com/t5/data-engineering/how-far-back-can-i-time-travel-on-a-delta-table/m-p/20395#M13750 Thu, 24 Jun 2021 20:29:22 GMT https://community.databricks.com/t5/data-engineering/how-far-back-can-i-time-travel-on-a-delta-table/m-p/20395#M13750 User16826992666 2021-06-24T20:29:22Z https://community.databricks.com/t5/data-engineering/how-far-back-can-i-time-travel-on-a-delta-table/m-p/20396#M13751 <P>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. </P><P></P><P>The retention of the Delta log JSON files can be increased. </P><P></P><P>%sql</P><P>ALTER TABLE&nbsp;table-name&nbsp;</P><P>SET TBLPROPERTIES ('delta.logRetentionDuration'='40 days')</P> Thu, 24 Jun 2021 23:32:47 GMT https://community.databricks.com/t5/data-engineering/how-far-back-can-i-time-travel-on-a-delta-table/m-p/20396#M13751 brickster_2018 2021-06-24T23:32:47Z