- 33157 Views
- 6 replies
- 2 kudos
SQL Stored Procedure in Databricks
Hello. Is there an equivalent of SQL stored procedure in Databricks? Please note that I need a procedure that allows DML statements and not only Select statement as a function provides.Thank you in advance
- 33157 Views
- 6 replies
- 2 kudos
- 2 kudos
This feature is currently in Private Preview. Please reach out to your account team and they can sign you up for it.
- 2 kudos
- 12820 Views
- 5 replies
- 6 kudos
Resolved! Call a Stored Procedure in Azure Synapse with input and output Params
driver_manager = spark._sc._gateway.jvm.java.sql.DriverManager connection = driver_manager.getConnection(mssql_url, mssql_user, mssql_pass) connection.prepareCall("EXEC sys.sp_tables").execute() connection.close()The above code works fine but however...
- 12820 Views
- 5 replies
- 6 kudos
- 6 kudos
This blog helped me with the output of the stored procedure: https://medium.com/@judy3.yang/how-to-run-sql-procedure-in-databricks-notebook-e28023555565
- 6 kudos