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

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.