Module

Connections - the structured shape

Text2SQL can be quietly wrong on multi-hop joins. The fix is not a better model - it is giving the agent the connections: how the warehouse tables actually join.

In this module, you use neocarta to read the warehouse's foreign keys out of BigQuery and into a Neo4j metadata graph - the join-path map - without moving a single row.

By the end of this module, you will:

  • Explain why the connections shape grounds query routing where Text2SQL guesses
  • Run neocarta to build the warehouse metadata graph from BigQuery
  • Decide what to migrate and what to federate - derive what you own, federate what a system of record owns
  • Query the connections graph through neocarta's MCP and watch your agent write correct Text2SQL
Ready, let's go!