CODEWITHSUNDEEP
azure-active-directorysnowflake-cloud-data-platformazure-databricksazure-service-principal
Iqram Choudhury
Iqram Choudhury

Reputation: 29

Is it possible to connect to snowflake in Azure Databricks using Oauth token from an existing Service Principal?

I am trying to connect to Snowflake in Databricks using an Azure access token generated from an existing Service Principal (not using the documentation's method to create one as I don't have the permissions to). Currently I am receiving the error "Invalid OAuth access token".

I believe the solution is I need snowflake to grant access to the service principal, however not sure how to do this or if it is even possible?

Upvotes: 0

Views: 908

Answers (1)

53epo
53epo

Reputation: 909

According to this Snowflake document, programmatic SSO with Federated Authentication (like you would need in a Databricks notebook) is only available for the Okta identity provider - even though Microsoft Azure Active Directory is among their supported Identity Providers

Upvotes: 1

Related Questions