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)
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.
Welcome to Databricks Community: Lets learn, network and celebrate together
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.