Known-Gaps Board
The honest version of “status”: not a green wall, but the defects we already know about. Every card below is pulled directly from the warehouse snapshot — the same data that powers the coverage claims elsewhere in this product.
Top of the queue — #1 · F4: Add score / points to asd_hlr.results
Pulse / sentiment extension is declared but has zero tables
Player/athlete sentiment timeseries — daily snapshots of social mentions (Reddit / X), QuiverQuant-style. Proposed tables: pulse_snapshots, pulse_mentions, pulse_competitor_daily. Evidence: information_schema search for %sentim%|%pulse%|%social%|%mention%|%reddit%|%twitter%|%quiver% → zero tables.
Odds coverage gates Gold — only F1 has it
Odds-as-a-service is the hard Gold differentiator. F1 already has odds → shortest path to first Gold. The four curated verticals (SMX, WSL, MASL, HLR) all target Silver and cannot reach Gold today. Gold requires: silver + live_schema + odds_markets.
results missing score/points (and region) vs other verticals — cross-sport queries explode.
High Limit Racing (asd_hlr). archetype: race, 24,526 results rows.
ops.freshness coverage_status = vendor_unknown; currency not answerable.
High Limit Racing (asd_hlr). vendor cursor could not be read (NO_KEPT_SESSIONS=1). A MONITORING gap, not stale data.
MASL competitors are TEAMS, not people
competitors = 47 TEAMS, not people. Real people live in masl_players. A naïve "list players" query against asd_masl.competitors returns 47 teams instead. Real people live in masl_players.
What we’re doing about it
Ranked next work
| Rank | Item | Title | Why |
|---|---|---|---|
| 1 | F4 | Add score / points to asd_hlr.results | so cross-sport queries stop exploding. |
| 2 | F8 | Fix HLR freshness computation | so currency is answerable. |
| 3 | PROMOTE | Promote one pipeline sport to asd_* spine | F1 already has odds → shortest path to first Gold. |
| 4 | MODELS | Catalog models for sports that already have schemas | bkfc, f1, pbr, rawmotion… before inventing empty ones. |
| 5 | PULSE | Land pulse_competitor_daily | joined on competitor_id once identity is stable for the first Gold sport. |
Why show this at all?
A data product that only ever shows green is hiding something. Every gap here is queryable against the same snapshot — so you can verify the honesty yourself.
Pulled with AWS_PROFILE=asd against Redshift Serverless (us-west-1 / default-workgroup / dev).
Go deeper
See the pipeline’s own data-quality assertions, or climb the tier ladder.