Test types

Metaplane supports eight test types out-of-the-box:

Test TypeValid TargetsGood fitsDescriptionExample alert
Row count Table, ViewRegularly refreshed or incrementally updated tables/viewsTracks the number of rows in a table/viewThe number of rows in this table is significantly lower than expected.
Column count Table, ViewTables/views that you expect to have a stable number of columnsTracks the number of columns in a table/viewThe number of columns in this table is significantly higher than expected.
Freshness Table (Snowflake/ BigQuery), Time columnRegularly updated tables/viewsTracks time elapsed since the last time a table/view was updated OR time elapsed since the most recent value of a time columnMore time has elapsed since this table was last updated than expected
Cardinality ColumnEnums, dimensions, categoriesTracks the number of unique values in a columnThe cardinality of this column is significantly lower than expected
Uniqueness ColumnPrimary keys, IDsTracks the uniqueness of a column defined as (# unique values / # total values). Ranges from 0 to 1The uniqueness of this column is significantly lower than expected
Nullness ColumnIDs, any column you expect not to be nullTracks the nullness of a column defined as (# null values / # total values). Ranges from 0 to 1The nullness of this column is significantly higher than expected
Sortedness Columncreated_at or updated_at timestamps, incremental IDs, any monotonically increasing/decreasing columnTracks the sortedness of a column, calculated as the percentage of pairs of consecutive values that are increasing from the first value to the second value, ranging from 0 (fully descending) to 0.5 (random order) to 1 (fully ascending).The sortedness of this column is significantly lower than expected
Distribution Numeric columnBusiness KPIs, input features into machine learning modelsTracks five categories of summary statistics:

- Center: mean, median
- Extent: min, max, range
- Cut points: upper 75th percentile, lower 25nd percentile
- Spread: standard deviation, interquartile range (difference between 75th and 25nd percentile)
- Distribution: skew, kurtosis
The mean of this column is significantly higher than expected

What’s Next