---

type: initiative slug: layer-6-relationship-mapping title: Layer 6 Relationship Mapping workstream: context-catalog-nimble owner: data-ai-engineer-architect status: planned milestone: m1-ft-analytics-analyst-pilot tasks: - task-m1-ai-context-layer6-relationship-mapping - issue-377-feat-chart-decisions-phase-4-sqlglot-column-lineage

---

Layer 6 Relationship Mapping

{{ initiative_progress_bar("context-catalog-nimble", "layer-6-relationship-mapping") }}

Objective

Cross-table relationship inference from naming conventions, semantic types, value range overlap, and declared foreign keys. Builds the join graph that agents use to pick safe joins.

Deliverables

• [ ] Define scope and decision boundaries.
• [ ] Produce implementation plan and execution checkpoints.
• [ ] Capture rollout and validation approach.

Tasks

• AI_CONTEXT layer 6 relationship mapping for pilot datasets — not_started
• Chart decisions Phase 4: SQLGlot column lineage — not_started

Links

• Research
• Spec
• Decisions