Walter_C
Databricks Employee
Databricks Employee

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:

  1. Run SHOW ARCHIVED FILES: Use the SHOW ARCHIVED FILES command 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.

  2. Move Files Back to Hot Tier on Storage Side: Restore the necessary archived files following documented instructions from your object storage provider.

  3. Update delta.timeUntilArchived Setting: If you need to access data older than the current archival threshold, update the delta.timeUntilArchived setting 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.