Upsert customer data from Salesforce to a BigQuery table

This example pipeline demonstrates how to update or insert (upsert) records in a Google BigQuery table using customer data from Salesforce.


BigQuery Bulk Upsert - Streaming Example Pipeline

Download this pipeline.
  1. Configure the Salesforce Read Snap to read customer account data from Salesforce.

    In this example, select Output Fields for Total, Id, and Name.

    On validation, the Snap prepares the output to pass to the BigQuery Bulk Upsert Snap.


    Salesforce Read Snap configuration

  2. Configure the BigQuery Bulk Upsert - Streaming Snap to upsert data based on unique identifiers.

    To upsert data based on the Id and Name key columns, enter Id and Name in the Key column fields.

    On validation, the Snap updates or inserts new records into the Google BigQuery table.

    BigQuery Bulk Upsert - Streaming Snap configuration BigQuery Bulk Upsert - Streaming Snap output

    BigQuery Bulk Upsert - Streaming Snap configuration
    BigQuery Bulk Upsert - Streaming Snap output

    The output shows that 5 records were updated successfully. The data is updated in the Google BigQuery table based on the unique identifiers Id and Name.


    Updated table data in Google BigQuery

To successfully reuse pipelines:
  1. Download and import the pipeline into SnapLogic.
  2. Configure Snap accounts as applicable.
  3. Provide pipeline parameters as applicable.