how to deploy sql functions in pool

alexgv12 — Wed, 13 Mar 2024 16:06:00 GMT

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

Re: how to deploy sql functions in pool

alexgv12 — Wed, 13 Mar 2024 20:56:33 GMT

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-alerts-from-lower/td-p/15352

topic how to deploy sql functions in pool in Data Engineering

how to deploy sql functions in pool

Re: how to deploy sql functions in pool