Data + Marketing Integrations
Other

BigQuery

4min

About the BigQuery Integration

BigQuery is a data warehouse that can be used to analyze and manipulate your data via several sources. Our integration allows the ability to push in or pull out customer lists.

How to add BigQuery as a Data Source:

For Pulling In Contacts

  1. Follow the instructions here for "Setting up authentication".
  2. Make sure you also follow the instructions to "Create a service account key" and download it to your computer.
  3. In AIQ, go to "Connect data" on the left-hand navigation, and then select the Data Destinations" tab on this page.
  4. Click "Connect" on BigQuery.
  5. Check the box next to Required All users from this source have passed an age-gate compliant with my industry.
  6. Put in your ProjectID & Location. This can be found on your Google Cloud dashboard.
  7. Copy and paste the contents of the service account key JSON file you created and downloaded earlier.
  8. Click "Connect".
Document image


How to add BigQuery as a Data Destinations:

For Pushing Out Contacts

  1. Follow the instructions here for "Setting up authentication".
  2. Make sure you also follow the instructions to "Create a service account key" and download it to your computer.
  3. In AIQ, go to "Connect data" on the left-hand navigation, and then select the Data Destinations tab on this page.
  4. Click "Connect" on BigQuery.
  5. Put in your ProjectID & Location. This can be found on your Google Cloud dashboard.
  6. Copy and paste the contents of the service account key JSON file you created and downloaded earlier.
  7. Click the big green"Connect" button.
Document image


You are not done yet! In order to send actual data you need to select Audiences to sync.



Updated 02 May 2024
Doc contributor
Doc contributor
Did this page help you?