Schema Drift: Map a Customer's Data and Catch Changes
A guessed fix for a changed export made two totals 100 times too big, with no error.
Video #307 ยท Forward deployed engineer interviews
Steps in the video
Files
- drift.py (52 lines)
- exports.py (16 lines)
- mapping.py (20 lines)
- run.py (18 lines)
Tested with
Python 3.12.15
What this does not show
Tiny made-up exports and mapping, five rows each. The rename hint is a spelling guess that a person must confirm. The check only counts values that fail to convert: a value that converts to the wrong number (1.250 meant as 1,250) passes. A program cannot settle day-first against month-first dates. Sources are vendor pages, not standards.
Sources
Learning IT by Example.