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 t…

Big Query Boolean Data Upserts Errors Out On Null Value

zzimbler August 24, 2021, 8:24pm 2

Topic		Replies	Views
Parameter types must be provided for null values via the 'types' field in query options 💬 Queries and Resources javascript , sql , bigquery , table , query-builder	30	9394	May 20, 2024
SQL upsert with GUI should allow null values in the filter 💬 Feature Requests	0	877	July 20, 2021
Filter query where select component is null or select component.value 💬 Queries and Resources sql , bigquery	18	13014	June 10, 2024
Parameter types must be provided for empty arrays via the 'types' field in query options 💬 Queries and Resources sql , bigquery	2	1630	August 8, 2023
Retool GUI insert suddenly failing for BigQuery DATE column (was working before) 💬 Queries and Resources sql	4	27	March 16, 2026