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:

\n\n

Error: Invalid schema update. Field X has changed mode from REQUIRED to NULLABLE.

\n\n

And the data looks good, there are no null values

\nSolution:

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

posted on

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