cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

best practices for SQL DB authentication from data bricks

KVNARK
Honored Contributor II

I would like to know the best practices to authenticate SQL db from databricks/python. More interested to hear about some token based DB authentication methods other than credential based(username/password)

1 ACCEPTED SOLUTION

Accepted Solutions

daniel_sahal
Esteemed Contributor
4 REPLIES 4

daniel_sahal
Esteemed Contributor

It depends which cloud provider you're using. For example on Azure you can use MSAL library to authenticate through Service Principal, obtain access token and authenticate using 'com.microsoft.sqlserver.jdbc.SQLServerDriver' driver.

KVNARK
Honored Contributor II

Could you help with any documentation link related to this.

daniel_sahal
Esteemed Contributor

Vivian_Wilfred
Databricks Employee
Databricks Employee

@KVNARK .โ€‹ Have you checked on the PAT token for authentication? https://docs.databricks.com/sql/api/authentication.html

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now