topic Re: Promoting assets from Dev workspace to Prod in Administration & Architecture

Promoting assets from Dev workspace to Prod

StephanieAlba — Mon, 05 Aug 2024 17:53:02 GMT

What is the best way to promote Databricks objects from one workspace to another? For example, DABs are great for code and models. However, SQL alerts do not seem to fall into DABs. The API allows for retrieving queries and creating them via API in the new workspace, but when creating alerts on the queries, there appears to be no programmatic way to schedule them. Am I missing something?

Re: Promoting assets from Dev workspace to Prod

Shazaamzaa — Tue, 06 Aug 2024 00:07:48 GMT

Alerts are available as an object under the SQL task in a Workflow/job using DAB. I also see from the docs that creating and maintaining alerts via the API is still in Public Preview. So, I'd be sure to wait until GA prior to using it in production.

Create a new job | Jobs API | REST API reference | Azure Databricks

Re: Promoting assets from Dev workspace to Prod

NandiniN — Tue, 06 Aug 2024 01:18:32 GMT

We can leverage open source tools like https://github.com/prometheus/alertmanager#amtool to interact with alert manager.

Re: Promoting assets from Dev workspace to Prod

NandiniN — Tue, 06 Aug 2024 01:22:19 GMT

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

https://docs.databricks.com/en/sql/dbsql-api-latest.html#changes-to-the-alerts-api

The API path is now api/2.0/sql/alerts, replacing the legacy path of /api/2.0/preview/sql/alerts.

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

I believe this is what you are look for?

Re: Promoting assets from Dev workspace to Prod

StephanieAlba — Tue, 06 Aug 2024 18:55:55 GMT

Sadly, no. The API does not have the ability to schedule the alerts.

Re: Promoting assets from Dev workspace to Prod

StephanieAlba — Tue, 06 Aug 2024 18:57:46 GMT

I see. So, a SQL task can be an alert that is scheduled in a workflow using DABs. Thank you