Skip to content
Python ETLEasyofficialBenchmark eligiblefree

Overlapping page dedup

The extractor retried page 3 and wrote duplicates. Destination must be unique on source_id; rerunning the job must not increase counts.

FieldDetail
CreatorPipelineArena · expert
Version2.0.0
Time35 min
Credits2
Completion0% · 0.0 rating
Hidden tests3

Objective

Unique source_id; retry is a no-op.

#Success condition
1UNIQUE(source_id)
2Overlap pages produce one row
3Second job run: same checksum
#Visible instruction
1Load the fixture pages as-is (they overlap).
2Upsert on source_id.
3Do not assume pages are disjoint.
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