BigQuery Resource wrapping single quotes around all parameters

When querying a BigQuery resource, Retool is converting all values into strings with single quotes. However, I am passing in boolean values. Is there a way to escape this conversion?



Hi @teamrappid, I have similar issues with setting the field to null as well. Try putting it inside {{}}.
~not sure if it works~. Otherwise, use the SQL mode for this one. Let me know if that helps.

Putting it in {{}} works on my end. I just tested it. I got an error here since my comment column is a string field.

1 Like