How to run stored procedure in Azure Data Warehouse using Databricks?

Use Case

We have stored procedure written in Azure data warehouse, and want to execute it in databricks using Pyspark.

We are using ODBC driver for connecting with Data warehouse. So let’s start with demo.

Step 1: Install required libraries

Also install library “pyodbc” on working cluster.

Step 2: Connect with Azure data warehouse using ODBC

Step 3: Execute stored procedure in Databricks.

And here is, what we want to achieve.

Hope this will help you to start your journey with Databricks and Azure Data warehouse connectivity with ODBC driver. I’ll discuss more strategies in a future blog post!