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

Solution:

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