Connect Azure SQL using Managed Identity from Azure Databricks

Sandeep AH 5 Reputation points
2024-02-07T06:44:45.57+00:00

Hi Team, We are trying to explore connection to Azure SQL DB from Azure Databricks notebooks using managed identity. Can you please let me know if this is supported and share the steps if supported to setup the same.

Thanks Sandeep

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,534 questions
0 comments No comments
{count} vote

2 answers

Sort by: Most helpful
  1. Amira Bedhiafi 34,101 Reputation points Volunteer Moderator
    2024-02-07T14:45:48.1366667+00:00

    Currently, Managed identity is not supported in Azure Databricks service.

    More details : Azure services that can use managed identities to access other services. Similar issue : Connect to Databricks from python via managed identity

    1 person found this answer helpful.

  2. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2024-02-20T20:37:36.6+00:00

    Hello Sandeep AH,

    After further research, I found out that you can use mananged identity using Unity Catalog.

    Unity catalog is a pre-requisite for using managed identity.

    Please see the below reference document:

    https://learn.microsoft.com/en-us/azure/databricks/data-governance/unity-catalog/azure-managed-identities

    I hope this answers your question.

    1 person found this answer helpful.

Your answer

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