Skip to main content
Metric LevelData TypeDescription
NullsTableAll TypesThe count of rows with a null value in the column e.g.

Sample dataset:
Null
Null
23

Metric value:
2
CountTableAll TypesThe total number of rows in a table e.g.

Sample dataset:
78
6
89
23
45

Metric value:
5
CardinalityTableAll TypesThe count of distinct elements in the column. This metric should be used when you expect a fixed number of value options e.g.

Sample dataset:
Cat
Dog
Cat

Metric value:
2
DuplicateTableAll TypesThe count of rows with a duplicate value in the column (excluding the unique value). eg

Sample dataset:
Apple
Apple
Pear
Pear
Banana
Pear

Metric value:
3

Apple has 1 duplicate, Pear has 2 duplicates, result is 3
MinTableNumericThe minimum value of the column e.g.

Sample dataset:
78
6
89
23
45

Metric value:
6
MaxTableNumericThe maximum value of the column e.g.

Sample dataset:
78
6
89
23
45

Metric value:
89
MedianTableNumericThe median of the column. The median is computed as the 50th percentile, and will only return a value that is in the dataset e.g.

Sample dataset:
78
6
89
23
45

Metric value:
45
SkewnessTableNumericThe statistical skew of the column. The skew is used to determine how evenly the values are distributed about the mean e.g.

Sample dataset:
78
6
89
23
45

Metric value:
0.0303028253
Variance SampleTableNumericThe variance of a column from its sample mean. This should be used to calculate the variance when the data represents a sample taken from a larger data set e.g.

Sample dataset:
78
6
89
23
45

Metric value:
1244.7
Variance PopulationTableNumericThe variance of a column from its population mean. This should be used to calculate the variance when the data represents the entire data set e.g.

Sample dataset:
78
6
89
23
45

Metric value:
995.76
Geometric MeanTableNumericThe geometric mean of a column e.g.

Sample dataset:
78
6
89
23
45

Metric value:
33.644590126644
Freshness (hrs)TableDate
Timestamp		The difference in hours of the maximum value of the column and the metric’s collection time.

Sample dataset in UTC (Metric collected at 2022-12-07 03:48:00 UTC):
2022-12-06 05:24:26
2022-12-07 01:33:36
2022-12-07 00:33:44

Metric value:
2.24
Sync LagPipelineNAThe Sync Lag metric measures the difference between the source data and the pipeline in megabytes (MB), providing a real-time indicator of pipeline performance. A high sync lag value (typically above 100MB, depending on pipeline load) may indicate abnormal pipeline behavior.
Replication DelayPipelineNAThe Replication Delay metric measures the time, in minutes, since the pipeline last copied data from the intermediary storage (S3) to the destination. It provides a clear indicator of how timely data replication is occurring.
Last modified on April 20, 2026