You repeat a step-by-step procedure to set up a new Database Catalog for each tenant.
You must correctly enter your managed identity regular expression. You see how to recognize
a discrepancy in your entry and your actual managed identity.
When you create a new database catalog, you specify the managed identity you
created earlier. In the event of an invalid managed identity specification, the
following regular expression appears in the UI.
'\/subscriptions\/(.+?)\/resourcegroups\/(.+?)\/providers\/Microsoft.ManagedIdentity\/userAssignedIdentities\/(.+)', 'i'
An example that matches the regular expression is:
/subscriptions/<subsciption_id>/resourcegroups/<resource_group>providers/Microsoft.ManagedIdentity/userAssignedIdentities/<managed-identity-name>
- subscriptions: Your subscription ID
- providers: Microsoft.ManagedIdentity (required value)
- resourcegroups: Your resource group
- userAssignedIdentities: Your managed identity name.
Repeat the following steps for each tenant.
-
Click Data Warehouse > Database Catalog > ADD NEW.
-
In New Database Catalog, enter the complete description of the managed identity
you created earlier.
-
Select the RAZ-enabled environment.
In Data Lake, SDX is the required value. The backend Data Lake and
Database Catalog database must be the same.
The backend Data Lake and
Database Catalog database must be the same.
-
In Tenant Storage Role, enter the complete managed identity you obtained
earlier.
For example:
For example:
/subscriptions/<subsciption_id>/resourcegroups/<resource_group>providers/Microsoft.ManagedIdentity/userAssignedIdentities/<managed-identity-name>
CDW attempts to validate your managed identity. If successful, proceed. If
validation fails, you see the error message described above. Correct the
problem, and try again.
-
In Tenant Storage Location, enter the tenant-specific container
container-tenant-1, for example, and click CREATE.
