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 ?

2 comments

· Sorted by Oldest

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)
Otman Manad
·
·
Hi, Remi can we use "search" option (with RAG) for "Big query Tables". I selected, using "Query Tables", 2 BQ tables but I want to find the asked question from my data using RAG method. I know that "search" option works with docs. My data are organized in text and metadata fields

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)
Otman Manad
·
·
Hi, Remi can we use "search" option (with RAG) for "Big query Tables". I selected, using "Query Tables", 2 BQ tables but I want to find the asked question from my data using RAG method. I know that "search" option works with docs. My data are organized in text and metadata fields