11 May 19 · Bozhack-miller ·       Add to Favorites   Report

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

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too