Restoring a Delta Table to an Earlier State

Restore a Delta table to the state at a specific point in time:

RESTORE[TABLE][database_name.]table_name|DELTA.`obs_path`

[TO] TIMESTAMP AS OF timestamp_expression

Restore a Delta table to the state at a specific historical version:

RESTORE[TABLE] [database_name.]table_name|DELTA.`obs_path`

[TO] VERSION AS OF version_code

**Table 1** Parameters for restoring a Delta table
Parameter	Description
database_name	Name of the database, consisting of letters, numbers, and underscores (_)
table_name	Name of the table in the database, consisting of letters, numbers, and underscores (_)
obs_path	OBS path, indicating the storage location of the Delta table
timestamp_expression	Timestamp, which cannot be later than the current time, formatted as yyyy-MM-ddTHH:mm:ss.SSS
version_code	Version number in the query result in Viewing History Operation Records of a Delta Table

RESTORE delta_table0 TO TIMESTAMP AS OF '2020-10-18T22:15:12.013Z';
RESTORE delta.`obs://bucket_name/db0/delta_table0` VERSION AS OF 2;

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.