Dust Community Icon

Issues with BigQuery Document Search for SQL Queries

·
·

Hi, I've uploeaded 2 documents to explain BigQuery tables and label thems. But when the user use the I.A agent SQL to query tables, The agent meets difficulties to find the documents, it failed very often to find the table structure. The search document failed to often. do you know why ?

  • Avatar of Remi
    Remi
    ·
    ·

    Thanks for the question Youcef Zeghiche! Did you add 2 tools to your agent? 1/ Search: plugged to the doc, allowing the agent to get context on the table 2/ Query table: plugged to big query to generate & run the queries using context from 1/ Also, you'll need to make sure that you properly specified the steps the agent needs to take in the Agent instruction. Ex: " STEP 1: search the documentation to find the most relevant tables to query using the tool X STEP 2: use the tool "Query table" to generate and run the query " Let me know if you have any other questions! (nit: having screenshots of your agent & convo can help debug)