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	9330	May 20, 2024
SQL upsert with GUI should allow null values in the filter 💬 Feature Requests	0	869	July 20, 2021
Filter query where select component is null or select component.value 💬 Queries and Resources sql , bigquery	18	12961	June 10, 2024
Parameter types must be provided for empty arrays via the 'types' field in query options 💬 Queries and Resources sql , bigquery	2	1609	August 8, 2023
Need Help with "Parameter type must be provided for empty array values" Error in BigQuery Integration 💬 App Building bug , bigquery , multiselect	2	405	September 20, 2024