- 39971 Views
- 13 replies
- 6 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
- 39971 Views
- 13 replies
- 6 kudos
- 6 kudos
how to connect the stored procedures to power bi report builder, seems like it is not working
- 6 kudos
- 14264 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...
- 14264 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