Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

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

RC1
Bronze 4
Bronze 4

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.

1 REPLY 1