How do I update an optional empty null field to BigQuery?

I did not try that solution but thanks for the response!
I managed to work around the problem by setting all fields to empty quotations instead of null on the database level. So when I pull data from the database to update it's already an empty quotation to submit if no changes were added from the user.

Perhaps others looking into this error from the below thread can also benefit from this thread.

1 Like