HTTP ERROR 403 during creation Linked Service with Databricks

Karalina Lapko 20 Reputation points
2023-11-26T21:26:31.9633333+00:00

Hi,

I created Azure AAD application and service principal.

I created client secret and granted accesses to service principal for Databricks, Datalake, Synapse.

My cluster works fine and in general I do not any issues with permissions...

But when I am trying to create Linked Service I am getting the following error:

<html>

<head>

<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>

<title>Error 403 User not authorized.</title>

</head>

<body><h2>HTTP ERROR 403</h2>

<p>Problem accessing /api/2.0/clusters/get. Reason:

<pre> User not authorized.</pre></p>

</body>

</html>

Processed HTTP request failed.

User's image

User's image

Could anyone help what I missed or did wrong?
User's image

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,454 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,959 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,799 questions
0 comments No comments
{count} votes

Accepted answer
  1. phemanth 6,555 Reputation points Microsoft Vendor
    2023-11-27T10:59:49.3166667+00:00

    @Karalina Lapko

    Thanks For Reaching out MS Q&A

    Make to have Contributor or Owner Role for the ADF.

    Check if you have either a Contributor or Owner role on the Databricks workspace resource in Azure.

    Role Assignment: Ensure that the service principal is assigned an appropriate role. You can do this by navigating to Azure Portal > Azure Databricks > Azure Databricks Service > Access control (IAM)>Add a role assignment. Select the role as owner  > Managed Identity > ADF > Select ADF, then select and then review and assign.User's image

    Post granting the owner permissions wait for few minutes and then test the connection and it is successfulUser's image

    For more details, refer to https://techcommunity.microsoft.com/t5/azure-data-factory-blog/azure-databricks-activities-now-support-managed-identity/ba-p/1922818

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


0 additional answers

Sort by: Most helpful