Crisp_and_BigQuery_Logos.png

You can connect Crisp with Google’s BigQuery, to sync your distributor and retailer data securely to the cloud, then integrate that data into your internal systems.

Note: To create this connection, you need your Google Cloud Platform account email and Google cloud region. For more information, see Google Cloud Documentation > Regions and Zones.

To connect Crisp to BigQuery:

  1. Log into your Crisp account.
  2. From the main menu at the top-right of the screen, select Outbound Connectors.
    Main_Menu_Outbound_Connectors.png
  3. Select the Add connector button.
    Connecting_Retailer_Portals_002.png
  4. From the Outbound connectors section, select the Google BigQuery connector tile.
    Google_BigQuery_001.png
  5. If you want, update the default name of the connector. If you're going to set up multiple outbound feeds, we recommend using something unique. Then, provide the Google Cloud email(s) you want to receive the data share and select the Add button.

    BigQuery_Name_and_Receiving_Accounts_Fields.png

    Note: Crisp does not verify the identity of these user accounts. We strongly recommended that you copy and paste the email addresses rather than enter them manually. 

  6. Select your Google Cloud Region (e.g., Northern Virginia). 
    Note: You cannot change this setting once the connector is saved. 

    Google_BigQuery_002.png

  7. In the Connector source data section, select the Select button.
    Google_BigQuery_003.png
    The Select source data screen appears.
  8. Select the retailer for which you want to export data to BigQuery (e.g., UNFI), then choose which data tables to include in the export.   
    Excel_Outbound_003.png
    Hint: If you need help determining which tables and columns to include, see our Data Catalog for detailed descriptions.

  9. To complete your selections, select the Accept button.

    Excel_Outbound_004.png
    The window closes and you return to the connector setup screen.

  10. Select the Save button.

    Connecting_Retailer_Portals_005.png

    The connection is saved. You can check the status of the connection by clicking the new Google BigQuery tile. 

A diagnostic checklist appears on the right side of the screen. Once all the items are complete, green check marks appear next to them and the connection is finalized.