So Big Query in theory supports True/False/Null in the boolean fields, but what we're seeing is that if we try to upsert from Retool using a GUI mode upsert query the database is rejecting the upsert. For example we tested {{null}} as the value in the upsert and the Bigquery response is 'Parameter types must be provided for null values via the 'types' field in query options.' If we default the upsert value to {{False}} or {{True}} the upsert works without any problems. We're curious if this has been seen before or if there is a simple fix to the solution.
@justin @alex tagging you both bc I've seen similar questions on the forum but not this one directly and saw you both in the comments. Thanks 