Hi Google Team. First thank you for such a great examples. I got stuck with some strange behavior. I am adopting the data Science agent to my own case and there is a hight chance (around 30%) that no matter what I do, the db_agent is not calling initial_bq_nl2sql tool. No matter what I say in prompt it is still going and generating SQL without invoking initial_bq_nl2sql tool.
As you can see I am passing quite a good query to db_agent, explaining logic and tables.
However, as you can see the db_agent provide explanation and also generate SQL without calling a tool, even instrcution says It is mandatory to call tool and do not generate anything yourself:
Prompt for db_agent:
I am kind of stuck because this creates a high % of failing.
Any idea or suggestion guys?
Hi Google Team. First thank you for such a great examples. I got stuck with some strange behavior. I am adopting the data Science agent to my own case and there is a hight chance (around 30%) that no matter what I do, the db_agent is not calling initial_bq_nl2sql tool. No matter what I say in prompt it is still going and generating SQL without invoking initial_bq_nl2sql tool.
As you can see I am passing quite a good query to db_agent, explaining logic and tables.
However, as you can see the db_agent provide explanation and also generate SQL without calling a tool, even instrcution says It is mandatory to call tool and do not generate anything yourself:
Prompt for db_agent:
I am kind of stuck because this creates a high % of failing.
Any idea or suggestion guys?