How far back can I Time Travel on a Delta table?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2021 01:29 PM
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2021 04:32 PM
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')

