While table updates are possible, BigQuery favors an append-only model where mutations are generally discouraged.
BigQuery is designed for flexibility and ease of use. Its integration with other Google Cloud services provides a robust platform for analytics at scale. To keep up with the latest improvements and updates, it’s a good idea to monitor the BigQuery release notes.
In some cases, you may need to abort the transformation execution and exit with an error message.
To abort the execution, set the ABORT_TRANSFORMATION variable to any nonempty string value. The variable is already declared internally, so you only need to set its value.
This example will set the ABORT_TRANSFORMATION variable value to 'Integrity check failed' if the INTEGRITY_CHECK table
contains one or more records with the RESULT column equal to the value 'failed'.
The transformation engine checks ABORT_TRANSFORMATION after each successfully executed query and returns the variable’s value
as a user error, Transformation aborted: Integrity check failed. in this case.
To create a simple BigQuery transformation, follow these steps: