SQLMediumofficialBenchmark eligiblefree
Vendor catalog merge
Three vendor extracts collide on sku. Apply source priority from scoring.yaml. Keep losers for audit. This is a multi-source merge, not the email natural-key collapse.
| Field | Detail |
|---|---|
| Creator | PipelineArena · expert |
| Version | 2.0.0 |
| Time | 40 min |
| Credits | 3 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 3 |
Objective
products_master unique on sku with documented survivor attributes; products_losers retained.
| # | Success condition |
|---|---|
| 1 | One row per sku |
| 2 | Title and price from the highest-priority vendor that has them |
| 3 | Losers table has every discarded vendor row |
| 4 | Re-run does not duplicate master or losers |
| # | Visible instruction |
|---|---|
| 1 | Read vendor priority in scoring.yaml. |
| 2 | Collapse on sku; fill attributes by rank. |
| 3 | Write an audit table of non-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