BrainTrust Investment Lab › Band 4 — Managing the ETL Environment
Band 4 — Managing the ETL Environment · book 488 · grain: one station per walk sheet
Changes walk from development to test to production the way data walks the subsystems: gated, in order, no shortcuts. Nothing reaches the production star because someone was in a hurry.
No walk sheets yet — this station begins when the ladder reaches it. Nothing is walked ahead of the lowest incomplete rung.
The contract — what each step must produce
| # | step | page | what the book requires |
|---|---|---|---|
| 2 | what environments actually exist | p.488 | 'Most organizations isolate the development, testing, and production environments... Ideally, the test system is identically configured to its… |
| 3 | every back-room operation goes through a script | p.488 | 'Every back room operation should go through rigorous scripting and testing, whether deploying a new schema, adding a column, changing indexes,… |
| 4 | a migration can be undone | p.488 | 'The version migration system needs to interface to the version control system to control the process and back out a migration if needed.' |
| 5 | one interface for connection information | p.488 | 'It should provide a single interface for setting connection information for the entire version.' |