Promoting assets from Dev workspace to Prod

[StephanieAlba]

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?

[Shazaamzaa]

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

[StephanieAlba]

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

[NandiniN]

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

[NandiniN]

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?

[StephanieAlba]

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