Knobit of Data modelling · K-801 · Skill

Recognises generated SQL edited by hand

What it means

A file in `08-ddl/` that regeneration does not reproduce byte for byte. The header says `DO NOT HAND-EDIT`; look for the edit anyway — an added constraint, a reordered statement, a tweaked type, a comment. From here the model and the database tell different stories and nothing mechanical can say which is right.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: `ck_fact_payment_settled_le_instructed` added straight into `01_create_tables.sql` after a deploy failure; the next regeneration drops it, nobody notices for two releases, and over-settled payments load again Acceptable: The check added to `fact_payment.check_constraints` in `physical-model.yaml` and the DDL regenerated; `diff -r 08-ddl /tmp/ddl-check` empty, and that diff run in CI

Builds on

Explains generated artefacts and their single source of truthK-851 · Knowledge

Needed by

None