Sam’s second wall: Text2SQL is 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 - the four-pains test
-
Query the connections graph through neocarta’s MCP and watch your agent write correct Text2SQL