BQ sink validation fails to catch the incompatible config setting:
The Data Fusion BQ Multisink plugin has two configuration options: 'truncate table' and 'Update Table Schema' (ALLOW_FIELD_ADDITION).
Currently if set both 'Truncate Table' and 'Update Table Schema' to True, they conflict and during the BQ loading phase of a pipeline will fail with the following message:
"Could not commit Job: Error occurred while importing data to BigQuery 'Schema update options should only be specified with WRITE_APPEND disposition, or with WRITE_TRUNCATE disposition on a table partition.'
'Truncate table' and 'update schema' options if set together, will apply only WRITE_TRUNCATE to BQ job.
The validation will not enforce choosing one of "Truncate table" or "Update Schema" as this may be confusing to the user who is expecting to clear schema and write. If both are selected together, only WRITE_TRUNCATE option will be set and not schema update options - this will ensure there is no exception while executing the job.
Validated on Jun 25th staging build.