Connect BigQuery with Unison

Who can use this feature?

  • Admins
  • Available on all plans

Connections allow you to bring data into Unison from another source. Once connected, you can create one or more integration jobs to determine the scope and frequency for the following objects:

  1. Accounts
  2. Contacts
  3. Opportunities

Add a BigQuery connector

A BigQuery connection is based on OAuth credentials and requires a BigQuery admin permission to add it.

  1. In Unison, click Settings from the left nav.
  2. Click Integrations
  3. Click Add a Connection.
  4. Locate the BigQuery data source, and click Connect.
  5. Enter a name and description for the connection (e.g., Acme BigQuery Production).
  6. Click Next: Authenticate.
  7. Follow the prompts to sign into your Google BigQuery account and authorize the connection.

    You can now configure a BigQuery integration job using the connection.

Configure a BigQuery integration job

A connected BigQuery integration pulls your accounts, contacts, opportunities, and relevant activities to be analyzed for your health score. Any updates you make in BigQuery will automatically be updated here and reflected in your score.

  1. In Unison, click Settings from the left nav.
  2. Click Integrations
  3. Click the connected BigQuery data source. 
  4. For each object (account, contact/user, opportunity), ensure the Incoming fields that you want in Unison are mapped to the appropriate BigQuery field.
  5. From the connections settings, choose your Active Customer Field to determine which account records and related objects to use for scoring in Unison.
  6. Click Save.

    The sync is scheduled to run every 30 minutes. Job history for each object is available for review and download.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request