I need directions to create metsatore admin on Databricks workspace created on azure

Vamsi Mohan 0 Reputation points
2025-10-14T10:54:18.6166667+00:00

I had setup Databricks Workspace in Azure. However, as I need to enable Delta sharing and have access to shares from my provider I need certain privileges on my role (USE_PROVIDER) that can be only granted by a metsatore admin. The workspace was not created with a metastore admin only an azure admin account. This may require a technical screen sharing to save time.

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA 91,321 Reputation points Moderator
    2025-10-14T13:52:05.9533333+00:00

    Vamsi Mohan - Thanks for the question and using MS Q&A platform.

    To allow external engines to access data in a metastore, a metastore admin must enable external data access for the metastore. This option is disabled by default to prevent unauthorized external access.

    To enable external data access, do the following:

    1. In an Azure Databricks workspace attached to the metastore, click Data icon. Catalog.
    2. Click the Gear icon. gear icon at the top of the Catalog pane and select Metastore.
    3. On the Details tab, enable External data access.

    User's image

    Note: These options are only displayed for sufficiently privileged users. If you do not see these options, you do not have permissions to enable external data access for a metastore.

    When you sign-in into databricks workspace with normal user (aka: without admin permissions), will not able to see an option to enable external data access for a metastore.

    User's image When you sign-in into databricks workspace with admin user (aka: metastore admin users), will able to see an option to enable external data access for a metastore.

    User's image For more details, refer to Enable external data access to Unity Catalog.
    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 𝘪𝘯𝘯𝘰𝘷𝘢𝘵𝘪𝘰𝘯𝘴, 𝘧𝘰𝘭𝘭𝘰𝘸 𝘮𝘦 𝘰𝘯 𝘓𝘪𝘯𝘬𝘦𝘥𝘐𝘯.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.