HOW TO GET ADMIN RIGHTS TO SETUP METASTORE

Hello Gokul Bondre,

Thanks for raising this question in Q&A forum.

I understand that you are trying to set up a Metastore (likely for Azure Databricks Unity Catalog) but are blocked because you do not have the required administrator rights, even if you are an Owner or Contributor on the Azure subscription.

This is a very common point of confusion. Setting up a Unity Catalog Metastore requires permissions at the Databricks Account level, which is separate from the Azure Resource level.

Here is how to resolve this:

1. Understand the Role Requirement:
   • To create a metastore, you must be a Databricks Account Admin.
   • Being an Azure Subscription Owner does automatically make you a Workspace Admin, but it does not automatically make you an Account Admin in the Databricks Account Console.
2. Identify the Current Account Admin:
   • The first Account Admin is automatically the user who created the very first Databricks Workspace in your Azure tenant.
   • If that was not you, you need to find that person.
3. Granting the Role:
   • Ask the current Account Admin to log in to the Databricks Account Console.
   • Navigate to User management.
   • Find your email/user.
   • Click on your user and under the Roles tab, toggle on Account Admin.

Once this role is assigned, log out and log back in. You should then be able to access the "Data" > "Metastore" creation flow successfully.

If helps, approve the answer.

Best Regards,

Jerald Felix

Gokul Bondre - Thanks for the question and using MS Q&A platform.

This video: Fix 'Selected User Does Not Exist in Tenant' | Microsoft Databricks Login Error (Step-by-Step) demonstrates how to resolve the "Selected User Does Not Exist in Tenant" error when logging into Microsoft Databricks using the "manage account".

Here is a summary of the detailed steps provided in the video:

1. Identify the Login Issue: When attempting to log in to the Databricks account console using the "manage account" option with a standard personal email address, the user encounters an error stating, "Selected user account does not exist in the tenant Microsoft services and cannot access the application". Clicking "continue with the Microsoft enter ID" results in the same error.
2. Locate the Correct User Principal Name (UPN): To resolve this, the user must select a different user ID.

    ◦ Go to the Microsoft Azure account.

    ◦ Use the search bar to find the "users" section.

    ◦ Look at the list of users to find the user principal name (UPN) that has an extension in it.

1. Copy the UPN: Copy this user principal name that includes the extension.
2. Log in with the UPN:

    ◦ Go back to the Databricks workspace.

    ◦ Click on "manage account".

    ◦ Select the other account option.

    ◦ Pass the extension ID (the copied UPN).

    ◦ Type the corresponding password and click "sign in".

1. Confirm Successful Login: The login should now be successful, providing access to the account console using the user ID with the extension.

Hope this helps. Let me know if you have any further questions or need additional assistance. Also, if these answers your query, do click the "Upvote" and click "Accept the answer" of which might be beneficial to other community members reading this thread.

𝘛𝘰 𝘴𝘵𝘢𝘺 𝘪𝘯𝘧𝘰𝘳𝘮𝘦𝘥 𝘢𝘣𝘰𝘶𝘵 𝘵𝘩𝘦 𝘭𝘢𝘵𝘦𝘴𝘵 𝘶𝘱𝘥𝘢𝘵𝘦𝘴 𝘢𝘯𝘥 𝘪𝘯𝘴𝘪𝘨𝘩𝘵𝘴 𝘰𝘯 𝘈𝘻𝘶𝘳𝘦 𝘋𝘢𝘵𝘢𝘣𝘳𝘪𝘤𝘬𝘴, 𝘥𝘢𝘵𝘢 𝘦𝘯𝘨𝘪𝘯𝘦𝘦𝘳𝘪𝘯𝘨, 𝘢𝘯𝘥 Data & AI 𝘪𝘯𝘯𝘰𝘷𝘢𝘵𝘪𝘰𝘯𝘴, 𝘧𝘰𝘭𝘭𝘰𝘸 𝘮𝘦 𝘰𝘯 𝘓𝘪𝘯𝘬𝘦𝘥𝘐𝘯.