Restores for Databricks

You can restore Databricks Unity Catalog database objects to recover from deletion, corruption, or to create out-of-place copies for validation.

Restore database objects

Restore tables, schemas, views or entire catalogs under Unity Catalog. You can recover to different workspace, catalog, or schema under the same Databricks account.

To restore database objects, follow these steps:

From the Command Center navigation pane, go to Protect > AI & Analytics.
Click the Databricks instance.
Next to recovery points section, select the metastore.
Select a recovery point, and then click Restore.
Select Restore Database Objects, and then click Submit.
In the Backup content section, click the Databricks workspace.
Select the catalog, schema or table, and then click Restore.
Select Destination Databricks Account and Destination Metastore.
In the Table details section, for Destination, specify the destination workspace, catalog, schema and table.

You can restore data to any existing workspace. You can specify a new or existing catalog, schema, and table. Specify values in the following format based on the selected restore object hierarchy:
- <workspace_name>/<catalog_name>
- <workspace_name>/<catalog_name>/<schema_name>
- <workspace_name>/<catalog_name>/<schema_name>/<table_name>
The Use optimal number of restore streams toggle is enabled by default and automatically sets the number of streams based on the size of the selected data. To configure streams manually, disable the toggle and enter a value in the Number of streams box.
To overwrite data on the destination metastore, select the Unconditionally overwrite if it already exists check box.

Selecting this option deletes existing catalogs and tables, and then recreates them from the backup. If a catalog is shared, the same action applies to all workspaces where the catalog is shared.
Click Restore.

Restore workspace

Recover your Databricks workspace from backup, including all the supported objects.

To restore database objects, follow these steps:

From the Command Center navigation pane, go to Protect > AI & Analytics.
Click the Databricks instance.
Next to recovery points section, select the metastore.
Select a recovery point, and then click Restore.
Select Restore Workspace, and then click Submit.
In the Backup content section, select the Databricks workspace, and then click Restore.
Select Destination Databricks Account and Destination Metastore.
Specify the destination workspace.

Note

Workspaces cannot be overwritten, if the original doesn't exist then you can use the same name. Else, specify a new name for the workspace to recover.
In the Destination Cloud Credentials section, the Azure app registration credentials are auto-populated. Do the following:
- For Subscription ID, enter the subscription ID of the destination Databricks account.
- For Resource Group Name, enter the resource group name of the destination Databricks account.
The Use optimal number of restore streams toggle is enabled by default and automatically sets the number of streams based on the size of the selected data. To configure streams manually, disable the toggle and enter a value in the Number of streams box.

Use the Unconditionally overwrite if it already exists check box to control whether existing catalogs and tables are replaced at the destination metastore.

Scenario	Option not selected	Option selected
Workspace with its own catalogs and tables	Restores all catalogs and tables.	Restores all catalogs and tables.
Workspace that uses shared catalogs	Restores the workspace configuration. Existing shared catalogs and tables are not modified.	Deletes shared catalogs and tables and restores them from the backup. This action can affect other workspaces that use the shared catalogs.
Workspace with both its own catalogs and shared catalogs	Restores the workspace configuration and workspace-specific catalogs and tables. Existing shared catalogs and tables are not modified.	Restores the workspace configuration and all catalogs and tables. Deletes shared catalogs and tables and restores them from the backup. This action can affect other workspaces.

Click Restore.