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 Setting up authentication.
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.
Location should be a Region in the Google infrastructure. Example:
us-central1
us-west4
us-west2
We suggest picking the one that has the lowest storage costs in the US.
If in doubt or indifferent to location, use us-central1.
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 Setting up authentication.
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.
Location should be a Region in the Google infrastructure. Example:
us-central1
us-west4
us-west2
We suggest picking the one that has the lowest storage costs in the US.
If in doubt or indifferent to location, use us-central1.
Copy and paste the contents of the Service Account Key JSON file you downloaded.
Click Connect.
⚠️ Warning: You’re not done yet! To begin sending data, you must select which Audiences to sync to BigQuery.