Tests and monitors types

What are data monitors?

Data monitors are SQL queries generators that are executed to collect a specific metric of the data, and track it over time.

How do monitors work in Elementary data tests?

Monitors have two modes:
Time buckets If a timestamp_column is defined for the table, the monitor will collect metrics by timeframe buckets. It is highly recommended to use time buckets on every table that has a time field. This is both for performance reasons, as well as better anomaly detection.
The default time bucket is 24 hours.
Global
If there is no timestamp column configured, monitors will query on the entire table, in intervals that are at least the duration of the timeframe bucket.

Available monitors

Table level monitors
Monitor name
Description
freshness
​
row_count
​
schema_changes
​
Column level monitors
Monitor name
Column type
Description
null_count
any
​
null_percent
any
​
min_length
string
​
max_length
string
​
average_length
string
​
missing_count
string
​
missing_percent
string
​
min
numeric
​
max
numeric
​
zero_count
numeric
​
zero_percent
numeric
​
standard_deviation
numeric
​
variance
numeric
​