We have a UC enabled on Databricks where we have two Metastores,
- Metastore in West Europe region
- Metastore in North America region
And Databricks workspace.
- 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?