topic Re: best practices for SQL DB authentication from data bricks in Data Engineering

best practices for SQL DB authentication from data bricks

KVNARK — Fri, 13 Jan 2023 11:24:41 GMT

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)

Re: best practices for SQL DB authentication from data bricks

daniel_sahal — Fri, 13 Jan 2023 11:43:15 GMT

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.

Re: best practices for SQL DB authentication from data bricks

KVNARK — Fri, 13 Jan 2023 12:28:57 GMT

Could you help with any documentation link related to this.

Re: best practices for SQL DB authentication from data bricks

Vivian_Wilfred — Fri, 13 Jan 2023 12:29:24 GMT

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

Re: best practices for SQL DB authentication from data bricks

daniel_sahal — Fri, 13 Jan 2023 12:39:11 GMT

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

Here's a tutorial