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