Test
P3 Description
Scenario:
If temp_tables are being used, during copying data from the temp table to the destination table, if there is a failure in BigQuery mid-way through execution, it will raise an Exception causing the pipeline to fail. As a result, some temp_tables will be copied and some will not be. When the pipeline is rerun, it will cause the same data to be written to new temp_tables and copy jobs will be triggered to copy this data to the destination table.
This will result in duplicate data being written to the BigQuery destination table.