01-13-2023 03:24 AM
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)
01-13-2023 04:39 AM
01-13-2023 03:43 AM
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.
01-13-2023 04:28 AM
Could you help with any documentation link related to this.
01-13-2023 04:39 AM
01-13-2023 04:29 AM
@KVNARK . Have you checked on the PAT token for authentication? https://docs.databricks.com/sql/api/authentication.html
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.