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 · expert |
| Version | 2.0.0 |
| Time | 60 min |
| Credits | 5 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 3 |
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. |
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