Data table Query

Lyzr Agent Studio Platform
,
1

I have multiple tables that are related (like orders linked to customers, and customers linked to regions). When building my Semantic Model, how should I describe these relationships so the agent understands when to JOIN tables? Is there a specific format or field in Lyzr’s Semantic Model where I define table relationships, or do I just describe them in plain language within the column metadata?

2

While creating a semantic model, there is a schema generation agent that understands what each table and column represents. It also understands the relationships between tables, including foreign key mappings.

So, if you have multiple tables where a join is required, the agent can recognize this and generate a query with the appropriate joins, helping it arrive at the correct answer.

Prerequisites:

  1. The model should have strong reasoning capabilities (to generate queries effectively)

  2. The relevant tables should be added to the semantic model (especially those that require joins)

For reference:
https://www.youtube.com/watch?v=yzn6xOGs9lk

1 Like