- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-08-2025 07:07 AM
To retrieve data before 7 years, you do not need to change the delta.timeUntilArchived setting from 1825 days (5 years) to 2555 days (7 years). You can keep it as is. The procedure for restoring archived data is as follows:
-
Run
SHOW ARCHIVED FILES: Use theSHOW ARCHIVED FILEScommand to identify the files that need to be moved back to the hot tier. The syntax is:SHOW ARCHIVED FILES FOR <table_name> [ WHERE <predicate> ];This operation returns URIs for archived files as a Spark DataFrame.
-
Move Files Back to Hot Tier on Storage Side: Restore the necessary archived files following documented instructions from your object storage provider.
-
Update
delta.timeUntilArchivedSetting: If you need to access data older than the current archival threshold, update thedelta.timeUntilArchivedsetting to the new value (e.g., 2555 days for 7 years). This step ensures that Databricks recognizes the restored files as part of the active dataset.