I’m currently in the process of migrating from one tenant to another, which includes Azure Databricks. In our current environment, we have three Databricks workspaces within the same subscription, all using a single Unity Catalog metastore backed by a storage account in the same subscription.

As part of the migration, these workspaces will be moved to separate subscriptions. One of my colleagues mentioned that a Unity Catalog metastore can be created per subscription. However, when attempting to create a second Databricks workspace in another subscription, it seems that the Unity Catalog metastore is more centralized — and that only one metastore can exist per region within a tenant.

Is the Unity Catalog metastore and the Databricks account console region-specific and unique per tenant? In other words, can there only be one Unity Catalog metastore per region in a tenant? I’m not very familiar with how this resource works, and I haven’t been able to find a source that explicitly confirms this — only indirect references.

-When attempting to create multiple metastores in a specific region, you may encounter the following error:

-This region already contains a metastore. Only a single metastore per region is allowed.

-Databricks recommends having only one metastore per region. Currently, Unity Catalog operates such that only one Unity Catalog Metastore can exist per region, and all workspaces within that region can be associated with it.

You can refer this documentation for work around.