Recognises a check unable to fail
A check of something the database already guarantees on that target — completeness of a NOT NULL column on Postgres, uniqueness of an enforced primary key — or of a definitional rule that no data can break. It always passes, inflates the quality score, and teaches people that DQ results are decoration.
Can AI do this?
AI does this well Most of the tested AI models master this. 8 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 99% | Mastered |
| gemini-3.1-pro-preview | Flagship | 98% | Mastered |
| gpt-6-astra | Flagship | 99% | Mastered |
| claude-fable-5-1 | Flagship | 99% | Mastered |
| gemini-3.8-flash | Mid tier | 99% | Mastered |
| gpt-6.1-sol | Mid tier | 99% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 46% | Not shown |
| gpt-6-luna | Low cost | 66% | Not shown |
| claude-haiku-5-5 | Low cost | 99% | 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 check and its removal or rescoping
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: DQ-002: IBAN present, account_identifier NOT NULL on Postgres, threshold 100 %, green forever Acceptable: Removed; or, where the constraint is enforced on one target and not another, scoped in its comment to the target that needs it. A stored derivation is checked as a stored column (row 4), not as a definition
Also known as: Check that cannot fail (data quality rule)
Related knobits
Builds on
- K-356 Explains rule enforcement mechanisms and platform enforcement
- K-352 Explains alethic and deontic modality of rules
All 31 knobits of Derive data quality rules.
Source: Review checklist 07-dq-rules, row 9; Witt 2012; DAMA UK 2013