Databricks Unity Catalog Metastore

TugrulA
New Contributor II

Hey everyone,

I deleted my Unity Catalog metastore and now want to point it to another Azure storage account (ADLS). However, once a metastore is created, its storage location cannot be changed. Therefore, I deleted the existing metastore and created a new one with the path to my new storage account.

My organization—and Databricks Unity Catalog—supports only one region per metastore. Because of this, I had to delete and recreate the metastore. Unfortunately, all objects in the deleted metastore are gone. We still have the metadata in an Azure container, but it’s managed by Databricks and the folders are named with random UUIDs.

I have two questions:

  1. How can I restore all objects? Is it possible for the new metastore (with the same name) to automatically include all of the original objects?

  2. If I need to restore the objects manually, how can I identify which _delta_log metadata folder corresponds to which table?

Thank you in advance.