Redshift Data-Product Prototypes
Twenty different true ways to connect to, and show the completeness and status of, the AltSportsData Redshift warehouse — 4 curated sports, 621,307 backbone rows. Every number is grounded in the live snapshot. Pick a lens, then practice a query.
ACoverage Matrix
Sport × backbone-table heatmap with real row counts.
BTier Ladder
Standard → Silver → Gold, and what each sport needs to climb.
CConnection Console
The real access method: Redshift Data API, IAM, read-only.
DSchema Explorer
Drill schema → table → columns; flags non-uniform columns.
EFreshness Monitor
ops.freshness: current / behind / vendor_unknown, lag_days.
FQuery Playground
A SQL editor with catalogued queries you can run right now.
GArchetype Lens
Race / Match / Judged — depth tables per shape.
HCompleteness Scorecard
Weighted % per sport with an itemized gap list.
IData Volume Treemap
Relative row counts — WSL dwarfs everything.
JKnown-Gaps Board
F4, F8, the pulse gap, the MASL teams-not-people trap.
KModel Coverage
9 of 27 catalog keys have Pydantic models.
LPromotion Pipeline
Raw schemas → asd_* spine, as a kanban.
MOdds / Gold Gate
Odds-as-a-service — the hard Gold differentiator.
NBackbone ERD
The six tables and the keys that join them.
OAudit Board
ops.audit_log — the warehouse grading itself.
POnboarding / SDKs
CLI, MCP, Claude, Bun e2e — how you connect.
QSport Profile Cards
One rich card per vertical: shape, counts, freshness, gaps.
RDialect Traps
svv_ vs information_schema, LISTAGG, no-FK, snapshot tables.
SLoad Timeline
ops.load_log runs — events loaded, rows written.
TTalk with Redshift
Ask in English → catalogued SQL → result.
Payment Page Variants
The original checkout explorations (v1–v10), kept for reference.
Minimal Simple
v1Clean single-page design with essential elements only
Side-by-Side
v2Form and summary displayed in two columns
Step Wizard
v3Multi-step checkout with progress indicator
Dark Mode
v4Dark theme with high contrast elements
Mobile-First
v5Optimized for mobile devices with touch-friendly UI
Single Tier Focus
v6Highlights one recommended plan prominently
Comparison Table
v7Detailed feature comparison between all tiers
Image Hero
v8Full-bleed hero image with immersive checkout
Social Proof
v9Testimonials and trust badges prominently displayed
Enterprise
v10Custom quote request with consultation booking