Anomaly: spike/drop in row count or column sum

spike_drop - Column-level - Common column checks

Detects anomalies by comparing the current row count or column sum against recent history.

Parameters

Parameter	Type	Default	Required	Description
metric	str	'row_count'	No	The metric to compare against recent history. One of: row_count, sum.
history_days	int	30	No	Number of days of history the Gateway fetches for comparison.
change_threshold_percent	float	none	No	Fail if the absolute percentage change vs. the mean of previous values exceeds this.
change_threshold_zscore	float	none	No	Or fail if the z-score of the current value vs. previous values exceeds this.
min_history	int	2	No	Require at least this many previous values before the check can evaluate.

YAML example

checks:
  - name: example_spike_drop
    check_type: spike_drop
    table_name: schema.table
    column_name: example_column
    parameters:
      metric: row_count
      history_days: 30
      min_history: 2

See YAML check format for the full field reference.