We are using Databricks SQL Alerts to handle one scenario. We have written the queries for the same, also we have created the SQL Alert. However, I was looking for the best way to deploy it on Higher Environments like Pre-Production and Production.

I gone through some article, but didn’t find any appropriate way of deploying the alerts and queries on higher environment. Kindly provide guidance on this, what would be the best way to deploy the queries and Alerts over higher environments.