...
As tables and columns are added, the text provided by the database, when available, is retrieved and assigned as the default natural language description. The model uses these descriptions to understand your data. It is important to review and adjust the descriptions as necessary to provide the language model a clear understanding of the structure of your data. You can modify To edit a description, simply double-click on it – this works for both table descriptions and column descriptions by double-clicking and editing the specific description.
...
Joining Tables
The agent will attempt to autonomously decide when joining multiple tables is necessary based on the table/column names and descriptions. For instance, if an Invoice Header and an Invoice Detail table both have an InvoiceId column, the agent will most likely join the tables by that column. The functionality can be tested in the Agent Preview section of the IDE. If the results are not satisfactory, the descriptions can be further refined to specify foreign key relationships. If the results are still not satisfactory, the Agent Instructions text can be updated to describe the database relationships in greater detail using natural language.
...