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

Solution:

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

Bozhack-miller

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

Copied