When I'm updating my row with some null values in it. It shows me some this type of errors
"Parameter types must be provided for null values via the 'types' field in query options."
I can set parameters types. But Where can I find query options. I didn't got enough info from docs for setting query options.
1 Like
ScottR
October 12, 2022, 3:12pm
#2
@flintrider Any chance you can share some screenshots of code or code itself in the app you are having difficulty with setting parameter types?
Hi @flintrider and thanks for jumping in here, @ScottR
What SQL type are you using?
Yes I didn't know from where to set these parameters for fixing the error.
Ah! I was worried that might be the case. It looks like we have a bug report for exactly this (we don't currently support null values with BigQuery queries). I just bumped it to the PM, so hopefully we'll have good news for you soon—I'll keep you updated in this thread!
2 Likes
skyler
December 24, 2022, 11:18pm
#8
@victoria - Have you folks made any headway here?
2 Likes
ff58
January 24, 2023, 9:29am
#9
any updates on this? Thanks
Asked the team that works on resources! Will let you know once I hear back.
1 Like
No updates yet, but I bumped this request again
2 Likes
I happened to have the same issue. There are two workaround you can try. See this thread. How do I update an optional empty null field to BigQuery?
1 Like
We are facing the same issue here, which is basically stopping us from using GUI writes with bigquery. Any updates on this request?
Checking in with the team to see if they have any updates. Thank you for asking about this, @DATA_THATMEMORY and @Tommy_Romano !
I'm encountering the same issue.