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
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