Recognises DDL older than its model
Generated SQL that predates the last change to physical-model.yaml. The model is the truth, so the SQL is a faithful rendering of an earlier truth, and a reviewer who reads only the SQL is reviewing last month's design.
Can AI do this?
Not tested yet
No AI benchmark covers this knobit yet. New results are announced in the Can AI Do the Job? newsletter.
What it looks like in practice
Expected result: The stale file and the regeneration needed
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: loan_arrears_day_count added to dim_account two commits ago; 08-ddl/postgres/01_create_tables.sql has no such column and the stage-8 review passes Acceptable: Regeneration for every configured dialect in the same commit as the model change, so the SQL is never a separate decision
Also known as: DDL older than the model (generated DDL)
Related knobits
Builds on
- K-851 Explains generated artefacts and their single source of truth
- K-916 Explains data model versioning and change management
All 33 knobits of Generate and review DDL.
Source: Review checklist 08-ddl, row 2; this skill (08-ddl.md)