Issue with Agent Not Retrieving 'False' Values from Snowflake Table

Hi team, hope you are doing well 🙂 I am facing an issue when trying to use an Agent with the Query tables tools connected to a snowflake table. It works great in retrieving all info in the tables except the "false" value in columns that will either have a "true" or "false" value or be empty. The agent is always unable to retrieve the "false" value there and returns it as "empty", do you know what I could to to prevent that?

👀1

7 comments

Thomas Kolovos
·
·
Hi Remi and team, hope you are all doing well 🙂 any insights on this? Is there a way to make Agent recognize "False" values as negative instead of empty?
Remi
·
·
Thanks Thomas Kolovos for the question! When you ask the agent to reproduce the table it has access to (limit to 10 rows), does the column where "False" is correctly appears in the file generated? (Accessed when Click on the "Results" doc) Are you sure that the data is properly stored in Snowflake? When you query the data, how is the column displayed?
Thomas Kolovos
·
·
Hi Remi, thanks for getting back! The column name populates correctly in the results file, the only inaccuracy is that instead of the "false" value, there is no value in the results csv
Thomas Kolovos
·
·
And it only happens for all binary columns in our snowflake data for the "false" value, when the value is "true" then it populates correctly
Thomas Kolovos
·
·
BI team checked the data tables in snowflake and confirmed the value appears correctly as "false" there
Thomas Kolovos
·
·
Actually a correction here Remi, when the agent is asked for a column that has the "True" value, it returns a correct answer, but when I open the results CSV file it has the Number 1 as the value, not the word "true", hope that helps
Remi
·
·
Thank you for the extra context, I'll flag to the team just to make sure it doesn't come from a wider issue!

Issue with Agent Not Retrieving 'False' Values from Snowflake Table | Dust Community