cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Unable to create a metastore for Unity Catalog as I don't have Account Admin rights

harika5991
New Contributor II

Hello guys,

I just started learning Databricks. I created a Databricks workspace via the Azure Portal using the Trial (Premium - 14-Days Free DBUs) plan. The workspace name is `easewithdata-adb`.However,I do not currently see the option to create a Unity Catalog Metastore from within the Catalog tab.
I believe this may be because I am not assigned the Account Admin role in the Databricks Account Console, even though I created the workspace.

Can someone please guide me on how to create a Metastore from within Catalog tab or how to get Account Admin role privileges?

1 REPLY 1

lingareddy_Alva
Honored Contributor II

Hi @harika5991 

You're right about the root cause of your issue. Creating a Unity Catalog metastore requires Account Admin privileges, which is separate from just creating a workspace in Azure.
These are options you can try:

When you create a Databricks workspace through the Azure Portal (even with Premium tier), you're creating the workspace itself
but not automatically getting Account Admin privileges in the Databricks Account Console.
The Account Console is a separate layer that sits above individual workspaces.

Solutions for Your Situation.

Option 1: Use the Databricks Account Console (Recommended)
             - Go to accounts.azuredatabricks.net
             - Log in with the same credentials you use for Azure
             - If your account is eligible for Account Admin, you'll see your account listed
             - Select your account, then navigate to "Metastores" section
             - Create a new metastore and assign it to your easewithdata-adb workspace

Option 2: If You Don't Have Account Console Access
         If you don't see your account in the Account Console, you'll need to take one of these approaches:
             1. Contact Azure Support: Request Account Admin privileges for your Databricks account.
             2. Use Azure CLI instead:

         # Install Databricks CLI extension first
           az extension add --name databricks

        # Create metastore
          az databricks metastore create \
             --resource-group <your-resource-group> \
             --metastore-name "my-metastore" \
             --location <your-region> \
             --storage-root "abfss://<container>@<storage-account>.dfs.core.windows.net/"

        # Assign metastore to workspace
          az databricks metastore assign \
            --id <metastore-id> \
            --workspace-id <workspace-id> \
            --default-catalog "main"

 

LR

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now