RESTORE (Delta Lake on Databricks)
Note
Available in Databricks Runtime 7.4 and above.
Restores a Delta table to an earlier state. Restoring to an earlier version number or a timestamp is supported.
Syntax
RESTORE [TABLE] table_identifier[TO] <time_travel_version>
where
- table_identifier
[database_name.] table_name
: A table name, optionally qualified with a database name.delta.`<path-to-table>`
: The location of an existing Delta table.
<time_travel_version> =
TIMESTAMP AS OF <timestamp_expression> |
VERSION AS OF <version>
For more information about the RESTORE
command, see Restore a Delta table.