Can we use "Access Connector for Azure Databricks" to access Azure SQL Server?

[GCera]

Is it possible to avoid using Service Principal (and managing their secrets) via the Python MSAL library and, instead, use the "Access Connector for Azure Databricks" to access Azure SQL Server (just like we do for connecting to Azure Data Lake Storage)?

The end goal is twofold:

1. use spark.read.jdbc() to retrieve data from tables
2. use pyodbc to execute INSERT/UPDATE queries

[Wojciech_BUK]

You can't use databricks Access Connector or Managed Identity. 

There is option to use managed Identity but I don't believe it is very secure.

In managed resource group you can find Managed Identity ( one per workspace) that is being attached to Clusters ( VM) , you can try to grant access for this identity to your DB and get token in code , then pass it to spark read jdbc.

I have heard that with Unity federation both Oauth + data write will be possible infuture but not who knows when it will happpen 😞

[Kaniz_Fatma]

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 
 

[GCera]

Unfortunately, I guess the answer is no (as for today, see @Wojciech_BUK reply).