Loading...
The Change Data Capture
A hard Python interview practice problem on DataDriven. Write and execute real python code with instant grading.
- Domain
- Python
- Difficulty
- hard
- Seniority
- senior, staff
Problem
The warehouse does daily snapshots of a source table, and the incremental loader needs to know exactly what was added, changed, or removed since yesterday. Write a function that compares two snapshots by a key field and produces an insert/update/delete breakdown.
Practice This Problem
Solve this Python problem with real code execution. DataDriven runs your Python code in a sandboxed Docker environment and grades it instantly.