API pipelinesHardofficialBenchmark eligiblepro
Gap backfill
transaction_id is monotonic but the warehouse has holes after an outage. Compute missing ranges, fetch from the API, upsert. Do not invent ids.
| Field | Detail |
|---|---|
| Creator | PipelineArena |
| Version | 2.0.0 |
| Time | 65 min |
| Scored checks | 17 |
Objective
No gaps in the documented id range; no extras; no duplicates.
| # | Success condition |
|---|---|
| 1 | Gap list matches hidden holes |
| 2 | Only missing ids inserted |
| 3 | UNIQUE(transaction_id) |
| # | Visible instruction |
|---|---|
| 1 | Find missing id ranges vs min/max. |
| 2 | Fetch by id or range as the API allows. |
| 3 | Verify against /v1/transactions/count. |
Scoring checks the leftover tables or files, replay safety, and seeded variations — not the exact syntax you used. Check implementation is never shown to participants.
Signed-in workspace: Open in app