You can configure custom alerts based on your queries. For the alert system to work properly the query should return only a single value.
To set an alert:
Open the Analyze page and run a query.
Click the menu icon and select Set Alert.
Enter the alert name, select a comparison operator, and applied value, and then click Accept.
After you set an alert, you can see all the alerts in the Alerts screen and can schedule an alert to run whenever you want.
After you schedule an alert, the owner of the database will receive an email whenever (based on the defined schedule) the selected query’s result crosses the defined threshold.
Example: Setting an Alert
You could set an alert on specific tables based on the
__updatetime (when the data was updated) and compare it to today. To do this, open the Analyze page and run the following query:
select datediff(day,max(date(__updatetime)),date(getdate())) from cassandra_email_run
Then select Set Alert from the menu.
Enter a title, such as cassandra source error. Change the comparison operator to Greater than and type a value of 1.
Click Accept to save the alert.
The alert is now set and can be scheduled from the Alerts page.