Data + Marketing Integrations
Other
BigQuery
3 min
the bigquery integration lets you connect aiq to your google bigquery data warehouse once connected, you can import (pull) or export (push) contact lists between aiq and your bigquery project for advanced analytics, audience management, and reporting before you begin you’ll need access to a google cloud project with bigquery enabled permission to create and manage service accounts a service account key (json file) when setting up your service account, you must grant it one of the following iam roles bigquery data editor recommended grants read/write access to datasets without full administrative privileges bigquery admin most permissive, full control of all bigquery resources bigquery user with custom permissions for teams with strict data governance policies to assign the role in google cloud, open the project you’re using with aiq go to iam & admin → iam locate the service account you created for aiq click edit principal and grant it the bigquery data editor (or bigquery admin ) role save your changes adding bigquery as a data source (pulling in contacts) use this option if you want to import contacts from bigquery into aiq for segmentation or marketing purposes in your google cloud console, follow the instructions for https //cloud google com/iam/docs/creating managing service account keys create a service account key and download the json file to your computer in alpine iq, go to connect data → open the data sources tab click connect on bigquery check the box labeled " all users from this source have passed an age gate compliant with my industry " enter your project id and location (visible in your google cloud dashboard) copy and paste the contents of the service account key json file you downloaded click connect once connected, aiq will be able to pull audience data from your specified datasets into your account adding bigquery as a data destination (pushing out contacts) use this option if you want to export contacts or audiences from aiq to bigquery for reporting, advanced analysis, or joining with other internal data in your google cloud console, follow the instructions for https //cloud google com/iam/docs/creating managing service account keys create a service account key and download the json file to your computer in alpine iq, go to connect data → open the data destinations tab click connect on bigquery enter your project id and location (visible in your google cloud dashboard) copy and paste the contents of the service account key json file you downloaded click connect you’re not done yet! to begin sending data, you must select which docid\ iozbp0zvnf1nixucqornl to sync to bigquery