Code AnalysisHard 60s
Backfill double-counting aggregates
Backfill job:
for day in last_90_days:
agg = compute_daily(day)
warehouse.insert("daily_metrics", agg) # plain INSERT
Reruns after a failed day append duplicates. What is the fix?
Think you can answer under pressure?
Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.