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