Can we use "Access Connector for Azure Databricks" to access Azure SQL Server?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-28-2023 08:30 AM - edited 12-28-2023 08:39 AM
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:
- use spark.read.jdbc() to retrieve data from tables
- use pyodbc to execute INSERT/UPDATE queries
