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.