UC Enablement in Databricks workspace for metastores in different region - Azure Cloud

[Nivethan]

Spoiler

We have a UC enabled on Databricks where we have two Metastores,

1. Metastore in West Europe region
2. Metastore in North America region

And Databricks workspace.

1. Workspace in West Europe region

And we want to have a single Databricks workspace for both Metastores in different region.

Existing Solution from Databricks:

Ideally, in Databricks we can’t have Metastore and workspace in different regions, also we can’t have multiple Metastores for one single workspace.

What could be potentially done?

But is there any other way / workaround that could be done inorder to access the different region metastore data in single region workspace?

[Yeshwanth · Accepted solution]

@Nivethan

A metastore is the top-level container for data in Unity Catalog. Unity Catalog metastores register metadata about securable objects (such as tables, volumes, external locations, and shares) and the permissions that govern access to them. Each metastore exposes a three-level namespace (catalog.schema.table) by which data can be organized. You must have one metastore for each region in which your organization operates. To work with Unity Catalog, users must be on a workspace that is attached to a metastore in their region.

Reference Doc: https://docs.databricks.com/en/data-governance/unity-catalog/create-metastore.html#:~:text=A%20metas....

Thank you.

[dkushari · Accepted solution]

Hi,

Cross region metastore and workspace (WS) is not possible. It is important to understand the use case and why you have certain data in a region where you do not have a compute (WS) or do not need a compute. Ideally have each region has their own WS and metastore and then use delta sharing for sharing data across, if data sharing is the use case here.