topic Re: Stored Procedure creation in Unity Catalog in Get Started Discussions

Stored Procedure creation in Unity Catalog

harman — Fri, 23 Feb 2024 12:50:26 GMT

Does Databricks support the direct creation of stored procedures using the CREATE PROCEDURE syntax?

Re: Stored Procedure creation in Unity Catalog

-werners- — Fri, 23 Feb 2024 13:09:20 GMT

AFAIK databricks does not have stored procedures, but sql queries can be stored and executed, which is kinda the same.

Re: Stored Procedure creation in Unity Catalog

SergeRielau — Fri, 23 Feb 2024 13:28:23 GMT

No stored procedures at this point. Have you looked at Notebooks?
If so and you still think you need/want stored procedures I would very much like to learn about it:

Is this a migration (from where)
Which features of procedures do you need?

Re: Stored Procedure creation in Unity Catalog

-werners- — Fri, 23 Feb 2024 13:37:02 GMT

affirmative, notebooks are imo a (better) replacement for SPs

Re: Stored Procedure creation in Unity Catalog

harman — Fri, 23 Feb 2024 13:50:46 GMT

We have a requirement to retrieve records dynamically based on parameters from multiple tables via an external application using an API.

Re: Stored Procedure creation in Unity Catalog

-werners- — Fri, 23 Feb 2024 13:57:04 GMT

there is a sql api, which can run sql queries but also a job rest api which launches a job. this job can run one or more notebooks.

https://docs.databricks.com/en/sql/admin/sql-execution-tutorial.html

https://docs.databricks.com/api/workspace/jobs

Re: Stored Procedure creation in Unity Catalog

SergeRielau — Fri, 23 Feb 2024 14:17:11 GMT

Are you saying you need to "glue together" the query dynamically.
Thsi requires logic and it all has to fit into a JDBC call?
I.e. you need a CALL statement which hides the complexity?

Re: Stored Procedure creation in Unity Catalog

harman — Fri, 23 Feb 2024 14:27:43 GMT

Yes, I need to dynamically prepare the query using parameters, execute it on the Unity catalog, and display the results in the application's UI screen. That's why I want to write the logic in a stored procedure and call it.

Re: Stored Procedure creation in Unity Catalog

sridharplv — Sat, 28 Jun 2025 18:54:27 GMT

Stored procedures are supported now with DBR 17.0 .

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

Re: Stored Procedure creation in Unity Catalog

ashin — Fri, 01 Aug 2025 05:16:11 GMT

HI sridharplv,

Thanks for the info, it worked 🙂