How to run SQL stored procedure in Azure Database for SQL Server using Azure Databricks Notebook

Hi @Anuj, Singh (Cognizant)

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

What are the required libraries that needs to be installed in Databricks cluster (if any)?

In case, if you are connecting to Azure Database for SQL Server using a JDBC driver in Azure Databricks, the connection can be established without manually installing additional libraries. Databricks provides built-in support for JDBC connections, so you won't need to install libraries like pyodbc or configure ODBC drivers.

How to connect with Azure Database for SQL Server using ODBC?

Please refer to this link for more details: https://community.databricks.com/t5/data-engineering/how-can-i-connect-to-an-azure-sql-db-from-a-databricks-notebook/td-p/18468

How to Execute SQL Server stored procedure in Databricks?

As mentioned in the article which you are referring: https://nachiketrajput44.medium.com/how-to-run-stored-procedure-in-azure-data-warehouse-using-databricks-caa912d123d5 - Once you are able to successfully be connected to Azure Database for SQL Server using Azure Databricks you can simply run the stored procedure without any issue.

For more details, please refer similar thread that might give you some additional insights:

I hope this information helps. Please do let us know if you have any further queries.

Thank you.

@Anuj, Singh (Cognizant)

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.