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 on the left side of the screen, select Connectors.
  3. Select the Add connector button.
  4. From the Outbound connectors section, select the Google BigQuery connector tile.
  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.

  6. Enter the Google Cloud account email you want to receive the data share, choose an account type (User or Group), then select the Add button.


    Note: Crisp does not verify these user accounts. We strongly recommended that you copy and paste the email addresses rather than enter them manually. Also, be sure to select the correct account type or your data will not be shared.

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


  8. In the Connector source data section, select the Select button.
    The Select source data screen appears.
  9. 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.   
    Hint: If you need help determining which tables and columns to include, see our Data Catalog for detailed descriptions.

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

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

  11. If you want to include a column in your export that identifies which inbound connector the data came from, select the Include Inbound Connector Configuration ID option.
    Hint: This is useful if you have multiple connectors for the same retailer, such as one for U.S. sales and one for Canadian sales.
  12. Select the Save button.


    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.