how to deploy sql functions in pool

[alexgv12]

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]

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...