Relationship Context for SQL Sources

Data Agent automatically follows the foreign key relationships in your SQL source to query the right tables -- including ones you didn't explicitly select. When you scope an agent to a schema or just a couple of base tables, the agent expands along those foreign keys to bring in the other tables a question needs and generates SQL that joins them correctly, so you get accurate multi-table answers from a small starting selection. For relationships that aren't defined in the source or live only in how your business uses the data, creators and advanced users can define additional relationships through the SDK & Data Agent experience. These configurations are stored alongside the rest of the agent configuration in a consistent, source-controllable format -- so they flow through your CI/CD pipeline