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 · expert |
| Version | 2.0.0 |
| Time | 65 min |
| Credits | 6 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 2 |
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. |
Hidden tests score the final tables or files, not the exact syntax you used. Test implementation is never shown to participants.
Signed-in workspace: Open in app