Invalid query parameter type when insert null values to BigQuery

Queries and Resources
1

Hi,

I want insert array values into big query using GUI mode.
Based on the user input, some arrays od strings stay empty.
Then this error message appears:

Invalid query parameter type when insert null values to BigQuery

How I need to change it?

image
image1677×767 117 KB

2

Hi @Jordi, have you tried using a ternary operation there that when the array is empty, you pass on null? I have not encountered an empty array being passed on in bigquery so better to resort to null.

1 Like
3

Hi there! I'm seeing the same issue :disappointed: I ended up having better luck with the SQL mode, rather than the GUI mode