Skip to main content

BigQuery

Follow our setup guide to connect your BigQuery data warehouse to Push.ai.

Prerequisites

To connect BigQuery to Push.ai, you need the following:

  • The ability to create service accounts in Google Cloud Console.

Step 1 - Create a service account in the cloud console

Create service account

Step 2 - Grant permissions

  • Search for the BigQuery Admin permission
Add Bigquery Admin permissions

Step 3 - Create a key and download the file

Manage keys

Step 4 - Whitelist IP Addresses (if necessary)

Push.ai connects to your warehouse from the following IP addresses. Be sure to allow traffic from these IPs in your firewall, and include them in any database grants.

Region/DeploymentIP Addresses
US52.45.144.63, 54.81.134.249, 52.22.161.231, 18.207.81.126, 3.211.20.157, 50.17.234.169
EMEA3.123.45.39 , 3.126.140.248 , 3.72.153.148 , 18.207.81.126, 3.211.20.157, 50.17.234.169

Step 5 - Configure the connection in Push.ai

  • Copy the project_id from URL
  • Upload the JSON key file

https://cloud.google.com/bigquery/static/img/dataset-access-controls#controlling_access_to_a_dataset