ht. Pass it the table name: ht <table>.',
why: 'ht ("home table") returns the metadata page for a single table: owner, partition, freshness, schema. It is the fastest way to confirm "is this the right table?"',
result: {
kind: 'ht',
title: 'dim_users',
rows: [
{ k: 'owner', v: 'analytics_oncall' },
{ k: 'partition', v: 'ds=YYYY-MM-DD' },
{ k: 'rows/day', v: '12.4M' },
{ k: 'sla', v: '24h' },
],
schema: ['user_id : STRING', 'account_id : STRING', 'event_type : INT', 'user_email : STRING', 'ds : STRING'],
}
},
{
q: 'Which job writes fct_events?',
hint: 'Find the producing pipeline',
shortcut: 'fpl fct_events',
accept: /^\s*fpl\s+fct_events\s*$/i,
tip: 'The "find pipeline" shortcut is fpl. Pass it the table whose producer you want: fpl <table>.',
why: 'fpl ("find pipeline") jumps from a table to the job that writes it: cadence, reader, oncall. Use this when a number looks wrong and you need to page someone.',
result: {
kind: 'fpl',
title: 'Pipeline producing fct_events',
rows: [
{ k: 'job', v: 'analytics.events_rollup' },
{ k: 'cadence', v: 'daily @ 04:00' },
{ k: 'reader', v: 'page_events_raw' },
{ k: 'owner', v: 'de_oncall' },
],
}
},
{
q: 'Find the UDF that parses CIDR ranges.',
hint: 'Search the UDF catalog',
shortcut: 'udf cidr_parse',
accept: /^\s*udf\s+\S+/i,
tip: 'The UDF-catalog shortcut is udf. Try a likely symbolic name: udf cidr_parse or udf parse_cidr.',
why: 'udf <name> looks up the UDF catalog by symbolic name. The catalog tells you who maintains the function and how often it is called — both matter before you take a runtime dependency.',
result: {
kind: 'udf',
title: 'cidr_parse(STRING cidr) → STRUCTwut ("what is this thing"). Pass the term: wut <term>.',
why: 'wut <term> ("what is this thing") hits the glossary. Use it when you see an unfamiliar acronym in a Slack thread or a YAML file — three keystrokes saves you a tab into the wiki.',
result: {
kind: 'wut',
title: 'dataset_acl',
body: 'Per-project access-control list. Scopes which engineers can read/write a dataset. Paired with actor annotations (Canonical_*) that tag the PII/identity nature of columns. Enforced at deploy by the Access Gateway.'
}
},
{
q: 'Show downstream consumers of dim_accounts.',
hint: 'Walk one hop down the lineage',
shortcut: 'ds produce dim_accounts',
accept: /^\s*ds\s+produce\s+\S+/i,
tip: 'The lineage shortcut is ds, with a produce subcommand for downstream: ds produce <table>.',
why: 'ds produce <table> walks one hop downstream: which facts, dimensions, metrics, and dashboards read this table. Always check this before deprecating or schema-changing — it tells you who you are about to break.',
result: {
kind: 'lineage',
title: 'dim_accounts · downstream (1 hop)',
children: [
{ name: 'fct_logins', owner: 'auth_de', kind: 'fact' },
{ name: 'dim_account_geo', owner: 'geo_de', kind: 'dim' },
{ name: 'metric:mau_daily', owner: 'analytics_team', kind: 'metric' },
{ name: 'dash:exec_weekly', owner: 'analytics_team', kind: 'dash' },
],
}
},
];
const BASELINE_TIMES = [
{ name: 'adrian · sr_de', t: 42 },
{ name: 'priya · de_oncall', t: 58 },
{ name: 'code-spelunker', t: 247 },
];
const TIP_PENALTY = 2; // seconds
const SOLUTION_PENALTY = 5; // seconds
function DiscoverySpeedrun({ reduceMotion, internalMode }) {
const N = MMNames(internalMode);
const [phase, setPhase] = useState('intro'); // intro | playing | done
const [qIdx, setQIdx] = useState(0);
const [inputVal, setInputVal] = useState('');
const [t0, setT0] = useState(null);
const [now, setNow] = useState(0);
const [penalty, setPenalty] = useState(0);
const [results, setResults] = useState([]);
const [flash, setFlash] = useState(null); // 'ok' | 'err'
const [tipShown, setTipShown] = useState(false);
const [solutionShown, setSolutionShown] = useState(false);
const inputRef = useRef(null);
// timer
useEffect(() => {
if (phase !== 'playing' || !t0) return;
const id = setInterval(() => setNow(Date.now()), 60);
return () => clearInterval(id);
}, [phase, t0]);
const elapsed = phase === 'playing' && t0 ? ((now - t0)/1000 + penalty) : 0;
const start = () => {
setPhase('playing');
setQIdx(0); setInputVal(''); setResults([]); setPenalty(0);
setTipShown(false); setSolutionShown(false);
setT0(Date.now()); setNow(Date.now());
requestAnimationFrame(() => inputRef.current?.focus());
};
const advance = (entry) => {
setResults(r => [...r, entry]);
if (qIdx === DISC_QUESTIONS.length - 1) {
setPhase('done');
} else {
setQIdx(i => i + 1);
setInputVal('');
setTipShown(false);
setSolutionShown(false);
requestAnimationFrame(() => inputRef.current?.focus());
}
};
const submit = (e) => {
e?.preventDefault();
const q = DISC_QUESTIONS[qIdx];
if (q.accept.test(inputVal)) {
setFlash('ok');
setTimeout(() => setFlash(null), 400);
advance({ q, input: inputVal, correct: true });
} else {
setFlash('err');
setPenalty(p => p + 3);
setTimeout(() => setFlash(null), 450);
}
};
const showTip = () => {
if (tipShown) return;
setTipShown(true);
setPenalty(p => p + TIP_PENALTY);
};
const showSolution = () => {
if (solutionShown) return;
setSolutionShown(true);
setPenalty(p => p + SOLUTION_PENALTY);
};
const fillSolution = () => {
const q = DISC_QUESTIONS[qIdx];
setInputVal(q.shortcut);
requestAnimationFrame(() => inputRef.current?.focus());
};
if (phase === 'intro') {
return (