11 May 19 · Bozhack-miller · #bigquery ·   Bookmark   ×

BigQuery error: Invalid schema update. Field has changed mode from REQUIRED to NULLABLE

While trying to insert into a table, It doesn't work and sends out the following error:

Error: Invalid schema update. Field X has changed mode from REQUIRED to NULLABLE.

And the data looks good, there are no null values


The issue is fixed after switching from Legacy SQL to Standard SQL


posted on 11 May 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds