topic Azure Databricks SQL Execution API Authentication in Get Started Discussions

Azure Databricks SQL Execution API Authentication

Sid1805 — Tue, 06 Feb 2024 22:18:06 GMT

Hi Team,

If a cloud application wants to read some data from Databricks we realize that Azure Databricks can expose its Tables via REST API.

For its authentication what is the most recommended method - I see we can have PAT token tagged to a Service Principal seemingly most secure ?

Also in the documentation I am confused with the below statement - ( as Oauth is for authorization and not authentication ?? )

***************

As a security best practice when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use OAuth tokens.

If you use personal access token authentication, Databricks recommends using personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.

*************

Document Link - https://docs.databricks.com/en/sql/admin/sql-execution-tutorial.html

Re: Azure Databricks SQL Execution API Authentication

Sid1805 — Thu, 15 Feb 2024 20:09:43 GMT

@Retired_mod - Thanks for your response.

For Azure Databricks my basic question is if the SQL REST API only supports PAT Tokens currently or it also supports Oauth as well ?

Re: Azure Databricks SQL Execution API Authentication

Ramakrishnan83 — Tue, 12 Mar 2024 19:12:47 GMT

Hi @Sid1805 ,

I am in the same situation as you. I am looking for guidance how to setup the authentication for REST API to connect with Databricks SQL. I started with PAT and used the user id as "token" and pwd as PAT Token to connect with Databricks SQL.

Now I need to change the authentication to Service Principals. I have setup the service principal and gave access to the databricks SQL. Now how do i configure the Application client ID and Secret in API/ Azure Kubernetes Layer