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

[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

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

[know-how]

Is there a way to query Databricks using Power BI, via a stored procedure or similar? In my use case the query will have multiple parameters, that the user will provide values for at runtime. I don't think notebooks can be consumed directly from Power BI, but I could be wrong.

Thanks for any help on this.

[Biswajit]

I have recently went through a video link from databricks which says its possible. But, when I tried it, it did not worked.
https://www.youtube.com/watch?v=f4TxNBfSNqM

Was anyone able to create stored procedure in databricks ?