Is it possible to have `ALLOW_FIELD_ADDITION` parameter on a query level ?

Google Cloud Data Analytics
, , ,
1

Is it possible to have ALLOW_FIELD_ADDITION parameter on a query level.

For example if we have a query like this

INSERT INTO TABLE_1 WITH ALLOW_FIELD_ADDITION=TRUE

SELECT * FROM TABLE_1_stage;

So here in this case if TABLE_1_stage has some extra columns than using ALLOW_FIELD_ADDITION feature will help in incrementally loading table without any worry of errors related to schema change.

2

Reviewing Modifying Tables Schemas, to signal that the data you are appending contains new columns, you should set the --schema_update_option flag to ALLOW FIELD ADDITION.

Additionally, as an alternative solution, here is an StackOverflow solution that provides a different way to add fields to a schema.