API pipelinesHardofficialBenchmark eligiblepro
Incremental sync with clock skew
The API’s updated_since misses rows near the cursor because of clock skew. Overlap the watermark. Apply delete tombstones. Store the next cursor durably after commit.
| Field | Detail |
|---|---|
| Creator | PipelineArena · expert |
| Version | 2.0.0 |
| Time | 60 min |
| Credits | 5 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 3 |
Objective
Customers match the hidden set after two windows; deletes applied.
| # | Success condition |
|---|---|
| 1 | Lookback/overlap window used |
| 2 | Tombstones delete destination rows |
| 3 | Cursor persisted after commit |
| 4 | Idempotent second window |
| # | Visible instruction |
|---|---|
| 1 | Overlap the watermark by the documented skew. |
| 2 | Apply tombstones. |
| 3 | Upsert on customer_id. |
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