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.