D8LooPFocus modeCODE WORKSPACE
Classify incremental load actions
Compare staged customer rows to the current dimension and classify insert, update, unchanged, and delete candidates.
The SQL API will hydrate this workspace with the exercise-specific starter query and schema.
Sample input
customer_stageIncoming batch. Customer 104 appears twice, customer 105 is unchanged, customer 103 is a tombstone, and the NULL key is ignored.
| customer_id | tier | is_deleted | updated_at | batch_id | |
|---|---|---|---|---|---|
| 101 | ana@example.com | gold | 0 | 2026-03-05 10:00:00 | 7001 |
| 102 | ben@example.com | silver | 0 | 2026-03-05 11:00:00 | 7001 |
| 103 | cy@example.com | bronze | 1 | 2026-03-05 12:00:00 | 7001 |
| 104 | dee-old@example.com | gold | 0 | 2026-03-05 09:00:00 | 7000 |
| 104 | dee@example.com | platinum | 0 | 2026-03-05 12:30:00 | 7001 |
| 105 | eli@example.com | bronze | 0 | 2026-03-05 08:00:00 | 7001 |
| 106 | fay@example.com | silver | 0 | 2026-03-04 23:30:00 | 6999 |
dim_customer_currentCurrent target table before the batch is applied.
| customer_id | tier | is_active | |
|---|---|---|---|
| 101 | ana@example.com | silver | 1 |
| 103 | cy@example.com | bronze | 1 |
| 104 | dee@example.com | gold | 1 |
| 105 | eli@example.com | bronze | 1 |
| 107 | gus@example.com | silver | 1 |
Expected output
Expected outputOne row per clean staged customer. 101/104 update, 102/106 insert, 103 is a delete candidate, and 105 is unchanged.
| customer_id | load_action |
|---|---|
| 101 | update |
| 102 | insert |
| 103 | delete_candidate |
| 104 | update |
| 105 | unchanged |
| 106 | insert |
Constraints
Load the live SQL exercise to inspect the full prompt, schema, starter query, and expected output.
Expected skills
Incremental loads, CASE, MERGE prep
SQL
Loading...
AI evaluation
Run the SQL query to inspect preview rows.