D8LooPFocus modeCODE WORKSPACE
Current-row snapshot audit
Compare current snapshot rows against incoming source state and classify drift.
The SQL API will hydrate this workspace with the exercise-specific starter query and schema.
Sample input
current target vs clean sourceThe audit covers keys in either side: target-only 107, source-only 102/106, changed 101/104, delete 103, aligned 105.
| customer_id | source_tier | target_tier | source_deleted |
|---|---|---|---|
| 101 | gold | silver | 0 |
| 102 | silver | null | 0 |
| 103 | bronze | bronze | 1 |
| 104 | platinum | gold | 0 |
| 105 | bronze | bronze | 0 |
| 106 | silver | null | 0 |
| 107 | null | silver | null |
Expected output
Expected outputClassify source/target drift for every key in the union.
| customer_id | audit_status |
|---|---|
| 101 | attribute_drift |
| 102 | missing_current |
| 103 | source_delete |
| 104 | attribute_drift |
| 105 | aligned |
| 106 | missing_current |
| 107 | missing_source |
Constraints
Load the live SQL exercise to inspect the full prompt, schema, starter query, and expected output.
Expected skills
Snapshots, Auditing, Current rows
SQL
Loading...
AI evaluation
Run the SQL query to inspect preview rows.