mart_metric_benchmark

Per-metric distribution by season over clean (ml_eligible) laps of fct_lap_residuals, so an explanation can say what is typical for a value.

Part of the Marts family.

Per-metric distribution by season over clean (ml_eligible) laps of fct_lap_residuals, so an explanation can say what is typical for a value. Grain: (metric_name, race_year). Covers driver_skill_residual_s, fuel_component_s, compound_component_s, constructor_component_s, dirty_air_tax_s and lap_time_s. Null values are dropped before aggregation.

Lineage

Overview

Property	Value
Layer	marts
Family	Marts
Contract enforced	No
Upstream	fct_lap_residuals
Model-level tests	unique_combination_of_columns

10 tests guard this model - 10 generic, 0 singular.

Columns

Column	Type	Nullable	Tests	Description
metric_name		Yes	not_null, accepted_values	Source column in fct_lap_residuals.
race_year		Yes	not_null	Season year.
p05		Yes		5th percentile (QUANTILE_CONT).
p50		Yes	not_null	Median (QUANTILE_CONT).
p95		Yes		95th percentile (QUANTILE_CONT).
mean		Yes	not_null	Arithmetic mean.
sd		Yes		Sample standard deviation.
unit		Yes	not_null, accepted_values	Unit of every value in the row. Always ‘s’ (seconds).
sample_size		Yes	not_null, accepted_range	Non-null lap count behind the row.