Getting An "invalid Schema Update. Cannot Add Fields" From Bq, With Allow_field_addition Set In The Configuration

The following python code snippet produces the error in the title: job_config = bigquery.QueryJobConfig() # Set the destination table table_ref = client.dataset(args.bq_dataset_id)

Solution 1:

You are doing it right except for one little mistake.

job_config.schemaUpdateOptions is a field that doesn’t exist in the BigQuery Python API. Change it for job_config.schema_update_options and your code will work as expected.

Also, here are several examples showing how to modify the BigQuery table schema using Python.