Hi
Unity Metastore can currently only be provisioned once for each Azure region. I have three environments in Azure each consisting of a separate Subscription and Resource Group (RG). Each RG contains a Databricks Workspace and a Storage Account holding data. This setup is provisioned using Terraform and each environment has its' own state file. Thus I would like to provision a Unity Metastore for each environment, which is not possible, since there can only be one metastore per region.
This means that only one of my environments can provision the Unity Metastore which will lead to my Terraform code being a huge mess as it should be environment aware. E.g. when running Terraform for the dev environment it would create the metastore and when running for production it would import the metastore as a Terraform data source (or vice versa).
What do others do to handle this issue?
