Is it possible to change the Azure storage account of Unity Catalog?

[valjas]

We have unity catalog metastore set up in storage account prod_1. Can we move this to prod_2 storage account and delete prod_1?

Also, is it possible to rename the catalogs once they are created?

[Kaniz_Fatma]

Hi @valjas , Certainly! Let’s address your questions:

Moving Unity Catalog Metastore:

• Yes, you can move the Unity Catalog metastore from one storage account (e.g., prod_1) to another (e.g., prod_2).
• Follow these steps:
  1. Create a new Premium performance ADLS Gen2 storage account (prod_2) in the same region as your Databricks workspaces.
  2. Create a container in the new storage account and note the ADLSv2 URI.
  3. Create a service principal and generate a client secret for the service principal.
  4. Grant the new service principal the Storage blob data contributor role in the new storage account.
  5. Log in to the Databricks account console.
  6. Click Data.
  7. Click the metastore name and then click Edit.
  8. Update the ADLS Gen 2 path with the new storage container URI.
  9. Click Save to update the metastore with the new storage account.

Renaming Catalogs:

• Renaming catalogs within the same Unity Catalog is possible.
• Use the following SQL command to rename a table:USE my_catalog.my_schema; ALTER TABLE my_table RENAME TO my_new_table;
• Replace my_catalog, my_schema, my_table, and my_new_table with your actual catalog, schema, and tabl....

Remember to test these changes in a non-production environment first. Moving the metastore and renaming catalogs should be done carefully to avoid disruptions. 🌟