how to deploy sql functions in pool

alexgv12
New Contributor III

we have some function definitions which we have to have available for our bi tools e.g.

 

 
CREATE FUNCTION CREATEDATE(year INT, month INT, day INT) RETURNS DATE RETURN make_date(year, month, day);
 
how can we always have this function definition in our version control and have it run in our databricks releases and if in case we have to recreate the infrastructure it will run in our databricks releases and if in case we have to recreate the infrastructure it will run in our databricks releases and if in case we have to recreate the infrastructure it will run in our databricks releases.
 
#sql #sqlfunctions #deploy
 
 
 
 
 

alexgv12
New Contributor III

looking at some alternatives with other databricks components, I think that a CI/CD process should be created where the view can be created through the databricks api. https://docs.databricks.com/api/workspace/functions/create

https://community.databricks.com/t5/data-engineering/how-to-deploy-databricks-sql-queries-and-sql-al...