dim_constructors

One row per constructor (team).

Part of the Reference family.

One row per constructor (team). Derived from stg_laps with a manually maintained power-unit family mapping. pu_family conditions constructor_pace_index on similar-engine teams in Layer 04 (e.g. Mercedes PU customers share base drag); update the mapping when customer relationships change.

Lineage

Overview

Property	Value
Layer	reference
Family	Reference
Contract enforced	No
Upstream	stg_laps

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

Columns

Column	Type	Nullable	Tests	Description
constructor_id	varchar	Yes	not_null, unique	Team name as reported by FastF1 (e.g. ‘Mercedes’, ‘Red Bull Racing’).
pu_family	varchar	Yes	not_null	Power-unit family grouping (e.g. mercedes_pu, honda_pu, ferrari_pu, renault_pu); ‘unknown_pu’ when unmapped.