Python ETLHardofficialBenchmark eligiblepro
Schema drift
Day-2 adds country_code and sends amount as a decimal string. Evolve forward. Fail closed on a destructive incompatible change if one appears in the hidden extra file.
| Field | Detail |
|---|---|
| Creator | PipelineArena |
| Version | 2.0.0 |
| Time | 60 min |
| Scored checks | 12 |
Objective
Both days load; old rows remain queryable; incompatible drift fails the job.
| # | Success condition |
|---|---|
| 1 | Additive column present (nullable or defaulted on day-1) |
| 2 | amount stored in a type-safe column |
| 3 | Day-1 rows still present |
| 4 | Destructive hidden fixture fails the job |
| # | Visible instruction |
|---|---|
| 1 | Compare day1.csv and day2.csv. |
| 2 | ALTER / widen types; do not TRUNCATE. |
| 3 | Fail if a required column disappears. |
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