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​

  • Select and grant the BigQuery Data Viewer and BigQuery User roles
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
All44.226.145.213, 54.187.200.255, 34.213.214.55, 35.164.95.156, 44.230.95.183, 44.229.200.200

Step 5 - Configure the connection in Push.ai​

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

Enhanced Security Controls​

To implement dataset level permissioning, please see GCP's most up-to-date documentation.