Skip to content
Python ETLMediumofficialBenchmark eligiblefree

Poison-row quarantine

Batch 4 has two poison records that abort the whole transaction if loaded together. Valid neighbors must load. Poison rows go to dead_letter.

FieldDetail
CreatorPipelineArena · expert
Version2.0.0
Time45 min
Credits4
Completion0% · 0.0 rating
Hidden tests3

Objective

All valid rows loaded; poison in dead_letter; ids unique.

#Success condition
1No all-or-nothing abort of the good rows
2dead_letter has the poison ids
3Target unique on id
#Visible instruction
1On batch failure, split to row-level load.
2Do not skip valid neighbors.
3Record poison ids.
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