Recognises lineage ending at a view
A view with consumers but no upstream edges: its SQL not resolved.
Can AI do this?
People still lead Few or none of the tested AI models showed they master this. 0 of 4 models in the current benchmark master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 90% | Not shown |
| gemini-3.5-flash-lite | Low cost | 10% | Not shown |
| gpt-6-luna | Low cost | 90% | Not shown |
| claude-haiku-5-5 | Low cost | 90% | Not shown |
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 upstream edges from the view's base columns, with the view's logic
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: CE-031 v_lcr_retail_deposits feeds two reports; nothing feeds it Acceptable: LG-007, LG-008 from CE-021 and CE-022 with the view's logic
Also known as: Lineage that ends at a view
Related knobits
Builds on
All 11 knobits of Trace column-level lineage.
Source: Review checklist 05-lineage, row 2 (DMBOK §1.3.6)