Restore Databricks objects and workspaces

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

To restore database objects, follow these steps:

1. From the Command Center navigation pane, go to Protect > AI & Analytics.

2. Click the Databricks instance.

3. In the recovery points section, select the metastore.

4. Select a recovery point, and then click Restore.

5. Select Restore Database Objects, and then click Submit.

6. In the Backup content section, click the Databricks workspace.

7. Select the catalog, schema or table, and then click Restore.

8. Select Destination Databricks Account and Destination Metastore.

9. 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. Use the following formats based on the object level:

   • <workspace_name>/<catalog_name>

   • <workspace_name>/<catalog_name>/<schema_name>

   • <workspace_name>/<catalog_name>/<schema_name>/<table_name>

10. The Use optimal number of restore streams toggle is enabled by default and automatically determines the number of streams based on data size. To configure streams manually, disable the toggle and enter a value in the Number of streams box.

11. To overwrite data on the destination metastore, select the Unconditionally overwrite if it already exists check box.

    Caution

    Selecting this option deletes existing tables in the catalogs before restoring them from the backup. If a catalog is shared, the same action applies to all workspaces which are mapped to such catalogs.

12. Click Restore.

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

To restore a workspace, follow these steps:

1. From the Command Center navigation pane, go to Protect > AI & Analytics.

2. Click the Databricks instance.

3. Next to recovery points section, select the metastore.

4. Select a recovery point, and then click Restore.

5. Select Restore Workspace, and then click Submit.

6. In the Backup content section, select the Databricks workspace, and then click Restore.

7. Select Destination Databricks Account and Destination Metastore.

   If the destination metastore does not have an existing credential with access to the destination staging storage, create a Databricks Access Connector in the destination region. The connector must have:

   • The same name as the destination workspace.

   • The Storage Blob Data Owner and Reader roles assigned on the destination staging storage.

8. Specify the destination workspace.

   Note

   Workspaces cannot be overwritten. If the original does not exist, you can reuse the same name. Otherwise, specify a new name.

9. In the Destination Cloud Credentials section, the Azure app registration credentials are auto-populated. Update the following fields:

   • 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.

10. 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.

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

    Caution

    When you select Unconditionally overwrite if it already exists, all the tables under existing catalogs are deleted and restored from the backup. This action can impact all workspaces which are mapped to such catalogs.

    Scenario	Option not selected	Option selected
    Workspace with only its own catalogs and tables	Restores all catalogs and tables.	Restores all catalogs and tables. Existing catalogs and tables are not modified.
    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.

12. Click Restore.