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_Fatma]

Hi @elgeo , Thank you for your question and for using our Community for learning purposes.

There is no direct equivalent of SQL stored procedures in Databricks that allow DML statements. 

[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_Fatma · 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​