...
In this example, we selected Output Fields for Total, Id, Type, and Name.
...
Upon validation, the Snap prepares the output to pass to the BigQuery Bulk Upsert Snap.
...
Next, we configure the BigQuery Bulk Upsert Snap to use unique identifiers to update the existing records.
To upsert data based on the Id and Name key columns, we enter Id and Name in the Key column fields.
...
Upon execution, this Snap updates or inserts new records into the target Google BigQuery table.
In this example, we’re updating we updated the Type Total for each record (based on the unique identifiers Id and Name selected under Key columns).
The output shows that 50 5 records were updated successfully.
...
The data is updated in the Google BigQuery table, as shown in the BigQuery console.
...
Downloads
...