SQL Stored Procedure in Databricks

[elgeo]

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

[Kaniz]

Hi @ELENI GEORGOUSI​, Thank you for your question and for using our Community for learning purposes.

You may check out the below articles, which explains how to call a stored procedure through Databricks Notebooks:

• Executing SQL Server Stored Procedures from Databricks (PySpark).
• Call a stored procedure from the Databricks notebook.

I hope this will help. Please let us know if you have any further queries.

[elgeo]

Hello @Kaniz Fatma​. Thank you for your prompt reply. I have already read these articles. However my question is if there is a way to create an SP in Databricks and not call one through a jdbc connection. Thanks again

[Kaniz · Accepted solution]

Hi @ELENI GEORGOUSI​ , That doesn't seem to be supported yet.

[Chris_Shehu]

Any updates on this? Are SPROC like features expected in the future? Or do stored SQL queries have all the same functionality? I know we can call those remotely. Thanks!

[Meghala]

Thanks it's also helpfull to me​