L

Promotion Pipeline

Raw schemas → asd_* spine, as a kanban.

status · promotion flow
16 raw
1 candidate
4 curated · 6/6

Promotion Pipeline

A warehouse schema is not a product. It earns the asd_* prefix only after it fills the six-table backbone spine. Most raw schemas are stuck at the typical 2/6 shape — events + results only (2/6). Match pipelines nll/pll have seasons + standings/schedule depth but no competitors/events/competitions/results under those names — different grain, not yet promoted.

What promotes a schema to asd_*

Backbone spine — 6/6 tables

competitorseventscompetitionsresultsevent_resultsseasons

Then: Standard tier requires

  • spine_present (6/6 backbone)
  • core_columns
  • freshness_current
Raw
16

~2/6 spine

events + results only (2/6). Match pipelines nll/pll have seasons + standings/schedule depth but no competitors/events/competitions/results under those names — different grain, not yet promoted.

usac
2/6
race
usac_live
2/6
race
woo
2/6
race
worldracing
2/6
race
moam
2/6
race
smx_live
2/6
race
hlr_live
2/6
race
nll
2/6
match
pll
2/6
match
pbr
2/6
judged
bkfc
2/6
judged
rawmotion
2/6
judged
wsl_live
2/6
judged
f1_feed
2/6
observed
f1_odds_analytics
2/6
observed
mx_live
2/6
observed
Promotion candidate
1

next up

Odds already present → the shortest path to the first Gold vertical.

f1
#3 PROMOTE
race · via f1_odds_analytics
has odds — the hard Gold gate

Promote one pipeline sport to asd_* spine — F1 already has odds → shortest path to first Gold.

Odds-as-a-service is the hard Gold differentiator. F1 already has odds → shortest path to first Gold.

Gold gate

silverlive_schemaodds_markets
Curated
4

asd_* · 6/6

Full backbone spine, real row counts, live in the product surface.

Supercross / Motocrossasd_smx
6/6
race
22,659 rows
World Surf Leagueasd_wsl
6/6
judged
536,073 rows
Major Arena Soccer Leagueasd_masl
6/6
match
32,147 rows
High Limit Racingasd_hlr
6/6
race
30,428 rows