Test types

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

Test Type

Valid Targets

Good fits

Description

Example alert

Row count

Table, View

Regularly refreshed or incrementally updated tables/views

Tracks the number of rows in a table/view

The number of rows in this table is significantly lower than expected.

Column count

Table, View

Tables/views that you expect to have a stable number of columns

Tracks the number of columns in a table/view

The number of columns in this table is significantly higher than expected.

Freshness

Table (Snowflake + BigQuery), Time column

Regularly updated tables/views

Tracks time elapsed since the last time a table/view was updated OR time elapsed since the most recent value of a time column

More time has elapsed since this table was last updated than expected

Cardinality

Column

Enums, dimensions, categories

Tracks the number of unique values in a column

The cardinality of this column is significantly lower than expected

Uniqueness

Column

Primary keys, IDs

Tracks the uniqueness of a column defined as (# unique values / # total values). Ranges from 0 to 1

The uniqueness of this column is significantly lower than expected

Nullness

Column

IDs, any column you expect not to be null

Tracks the nullness of a column defined as (# null values / # total values). Ranges from 0 to 1

The nullness of this column is significantly higher than expected

Sortedness

Column

created_at or updated_at timestamps, incremental IDs, any monotonically increasing/decreasing column

Tracks 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 column

Business KPIs, input features into machine learning models

Tracks 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
Did this page help you?