Recognises an object in the SQL missing from the model
A table, view, index, sequence or trigger in 08-ddl/ with no counterpart in the model. It was added for one urgent reason and is now invisible to every later review, every other dialect and every new environment.
Can AI do this?
AI does this partly Some of the tested AI models master this; others do not show it. 6 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 100% | Mastered |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 0% | Not mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 40% | Not shown |
| gpt-6-luna | Low cost | 51% | Not shown |
| claude-haiku-5-5 | Low cost | 6% | Not mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: The object and its place in the model
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: ix_fact_payment_value_date_key created by hand on Postgres to rescue a month-end report; it is in no other target's output and in no model, and the next environment is built without it Acceptable: The index in the model's indexes, so it appears in every target's output — commented out where the engine has none (row 13) — and in the ERD
Also known as: Object in the SQL that is not in the model (generated DDL)
Related knobits
Builds on
- K-851 Explains generated artefacts and their single source of truth
- K-914 Explains forward and reverse engineering of data models
All 33 knobits of Generate and review DDL.
Source: Review checklist 08-ddl, row 3; BCBS 239; this skill