This guide will show how to set up an alert metric, define its threshold and receive an alert if it falls outside of this threshold.
Create a Connection
Data observability supports the following data warehouses and databases for monitoring.
Data Warehouses
- Redshift
- Snowflake
- BigQuery
Databases
- Postgres
- MySQL
- SQL Server (coming soon)
You can create these connections in the Source or Destination page. See Data Stores for more setup details.
![undefined](https://cdn.buttercms.com/Zz3ATzXLSyGGJZ8QoHEh)
Create an Alert
1. On your dashboard sidebar, go to Observability. Click + New Alert or Add on Alert +
![](https://cdn.buttercms.com/yKHxtlUITPuQCO8junp3)
2. On Create new alert page, you can specify the following details
- Alert name : Name of the alert
- Alert priority : Preference on how alert will be categorized
- Run frequency : How often the metric is run and check to be within the threshold
- Alert Notification : List of emails to be notified
![](https://cdn.buttercms.com/jtscUNyS6eDUDLNWVrYx)
3, Add an Alert trigger. You may select an existing metric or create a new metric. Here we are going to create a new metric.
Specify which Data store you wish to connect. Then select a Table and Column to be used in the metric. Here, we selected Null as Metric type to detect nulls. See Available Metric Types page to see list of metrics.
![](https://cdn.buttercms.com/JKXoozmxQ7ylyyQficaF)
4. You can add conditions specific to columns available in the table. For this example, only rows with column id of 1 will be checked for nulls.
![](https://cdn.buttercms.com/2WraQ03HRKWui5rsmxXA)
5. Threshold is the level a metric needs to cross to generate an alert. Specify either of the two thresholds values (Alert if below, Alert if above) or both.
![](https://cdn.buttercms.com/AmkvMgwbQ6WcDFyGcYYI)