topic Re: SQL Stored Procedure in Databricks in Data Engineering

SQL Stored Procedure in Databricks

elgeo — Tue, 18 Oct 2022 10:54:11 GMT

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

Re: SQL Stored Procedure in Databricks

elgeo — Wed, 19 Oct 2022 07:20:13 GMT

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

Re: SQL Stored Procedure in Databricks

Chris_Shehu — Fri, 03 Feb 2023 19:40:58 GMT

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!

Re: SQL Stored Procedure in Databricks

Meghala — Sat, 04 Feb 2023 14:20:15 GMT

Thanks it's also helpfull to me

Re: SQL Stored Procedure in Databricks

know-how — Mon, 19 Aug 2024 18:59:45 GMT

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.

Re: SQL Stored Procedure in Databricks

Biswajit — Wed, 16 Oct 2024 15:47:16 GMT

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 ?

Re: SQL Stored Procedure in Databricks

twole — Tue, 25 Feb 2025 06:30:13 GMT

This feature is currently in Private Preview. Please reach out to your account team and they can sign you up for it.

Re: SQL Stored Procedure in Databricks

smpa01 — Mon, 28 Apr 2025 18:02:42 GMT

@twole do you know when this can be generally available?

Re: SQL Stored Procedure in Databricks

Andolina1 — Thu, 12 Jun 2025 15:29:01 GMT

Looks like Stored procedures are in Public preview now. But when I am trying to create a procedure as per Databricks documentaion, it still doesn't seem to work.

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-ddl-create-procedure

can anyone help?

sample code:

CREATE PROCEDURE print_hello()
LANGUAGE SQL
SQL SECURITY INVOKER
AS BEGIN
SELECT 'Hello!';
END;

Error:

Appreciate your help!!

Thanks,

Andolina

Re: SQL Stored Procedure in Databricks

nikhilj0421 — Fri, 13 Jun 2025 05:48:41 GMT

Hi @Andolina1 this is supported in DBR 17.0 and above.

Re: SQL Stored Procedure in Databricks

nikhilj0421 — Fri, 13 Jun 2025 06:01:04 GMT

I am able to create one with the 17.0 beta DBR version. Please refer to this: https://docs.databricks.com/aws/en/release-notes/runtime/17.0#sql-procedure-support

Re: SQL Stored Procedure in Databricks

jameshughes — Fri, 13 Jun 2025 22:33:14 GMT

@Andolina1 - As others mentioned, only available in DBR 17.0 which is currently in Beta in Azure. I received the same error as you during testing and changing the cluster runtime will address it. Probably a little early to start using at scale until 17.0 moves out of Beta.

Re: SQL Stored Procedure in Databricks

sridharplv — Sat, 28 Jun 2025 18:52:16 GMT

Its working for me without any issues if we create a cluster with DBR 17.0

https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-create-procedure

Re: SQL Stored Procedure in Databricks

SanthoshU — Mon, 29 Sep 2025 20:26:46 GMT

how to connect the stored procedures to power bi report builder, seems like it is not working