9. Alerts

9.1 What is an alert?

An alert is a Databricks SQL object that periodically runs a query, evaluates a condition of its result, and notifies one or more users and/or notification destinations if the condition was met.

9.2 Practical

This is how the alerts UI looks like.

Click on the Create alert button at the top right. A new interface opens.

Provide a name for your alert, such as test, and the query that you will be using, in this case we will go with si_community. Once you insert the Query that you will be using, the interface extends further down.

You can customize the trigger condition, notification frequency and template. Once satisfied, click Create alert

Once you create the alert, a new interface opens with more functionalities such as to Share, Edit or Refresh the alert.

In this interface one can also add a schedule of when you would want the query to always run, and also the destination

The kebab menu at the top right allows one to delete or clone an alert. By selecting Go to Folder on the kebab menu, Databricks will take you directly to where your alert is stored. That will be in your workspace folder!

If you go back to the Alerts browser, you will see you new alert