The Connections Shape

The warehouse holds the answer to "what did we do last time on cars like this?" - across vehicles, work orders, and parts. The obvious tool, Text2SQL, can write the query, but on a multi-table join it can be quietly wrong: it guesses which columns join, and a plausible-looking join on the wrong key returns plausible-looking nonsense.

In this lesson, you will learn the shape that fixes it - the connections graph - and the rule for where it should live.