โ02-23-2024 04:50 AM
Does Databricks support the direct creation of stored procedures using the CREATE PROCEDURE syntax?
โ02-23-2024 05:09 AM
AFAIK databricks does not have stored procedures, but sql queries can be stored and executed, which is kinda the same.
โ02-23-2024 05:28 AM
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:
โ02-23-2024 05:37 AM
affirmative, notebooks are imo a (better) replacement for SPs
โ02-23-2024 05:50 AM
We have a requirement to retrieve records dynamically based on parameters from multiple tables via an external application using an API.
โ02-23-2024 06:17 AM
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?
โ02-23-2024 06:27 AM
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.
โ02-23-2024 05:57 AM
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
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
Request a New Group