best practices for SQL DB authentication from data bricks

[KVNARK]

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)

[daniel_sahal]

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]

Could you help with any documentation link related to this.

[daniel_sahal · Accepted solution]

https://www.thedataswamp.com/blog/databricks-connect-to-azure-sql-with-service-principal

Here's a tutorial

[Vivian_Wilfred]

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