How to execute stored procedures on synapse sql pool from databricks

doodateika
New Contributor III

‎07-31-2024 05:25 AM

In the current version of databricks, previous methods to execute stored procedures seem to fail. 

spark.sparkContext._gateway.jvm.java.sql.DriverManager/
spark._sc._gateway.jvm.java.sql.DriverManager returns that it is JVM dependent and will not work. Using pyodbc does not currently like it used to because drivers must be installed and using init scripts at DBFS seems to be deprecated in addition to authentication passthrough for storing the init scripts at ABFSS. So my question is: What is the current way to execute synapse stored procedures from databricks? Do I have it wrong and the methods above actually work? Is there some new method that i have missed in the docs?