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

singhanuj2803
Contributor

We have Stored Procedure available in Azure Database for PostgreSQL and we want to call or run or execute the postgreSQL stored procedures in Azure Databricks through Notebook

We are attempting to run PostgreSQL stored procedures, through Azure Databricks notebook and would need help how to execute a stored procedure. I would need clarity in below points

  1. What are the required libraries that needs to be installed in Databricks cluster (if any)?
  2. How to connect with Azure Database for PostgreSQL using ODBC?
  3. How to Execute PostgreSQL stored procedure in Databricks?

I am referring to below link,

https://nachiketrajput44.medium.com/how-to-run-stored-procedure-in-azure-data-warehouse-using-databr...

Let me know if anyone has step-by-step approach how to solve this issue.