Python ETLMediumofficialBenchmark eligiblefree
Timestamps to UTC
Upstream mixes RFC 3339, US dates, epoch millis, and 24:00. Store occurred_at as timestamptz UTC. Valid rows must not become NULL.
| Field | Detail |
|---|---|
| Creator | PipelineArena · expert |
| Version | 2.0.0 |
| Time | 45 min |
| Credits | 3 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 3 |
Objective
events.occurred_at is UTC; rejects written; no silent null on a parseable row.
| # | Success condition |
|---|---|
| 1 | Valid rows stored as UTC |
| 2 | Epoch millis distinguished from seconds |
| 3 | Invalid values quarantined |
| 4 | No valid row left NULL |
| # | Visible instruction |
|---|---|
| 1 | Inspect data/events.jsonl. |
| 2 | Document parse order; fail closed. |
| 3 | Load only survivors. |
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