ht
Documentation
WelcomeConcepts

Get Started

OverviewCreate a sourceCreate a modelCreate a destinationCreate a sync

Sources

Amazon AthenaAmazon RedshiftDatabricksGoogle BigQueryGoogle SheetsLookerMySQLPostgreSQLRocksetSnowflakeSQL ServerTrino
Documentation/Sources/Google BigQuery
ht
Documentation

Google BigQuery

Table of Contents
Setup
BigQuery is a fully-managed enterprise data warehouse that helps you manage and analyze your data with built-in features like machine learning, geospatial analysis, and business intelligence.

Setup

Hightouch will always connect to your warehouse from 54.196.30.169 or 52.72.201.213. You may whitelist this IP address in your VPC security groups.
First, you’ll want to enable BigQuery for your Google Cloud project. Then, you will use Hightouch to create a new service account. Last, you will use the gcloud CLI to grant the Hightouch service account access to your project.

Create a Project and Enable BigQuery

  1. Navigate to the Google Developers Console
  2. Configure Cloud Platform:
    • If you don’t have a project already, create one.
    • If you have an existing project, you will need to enable the BigQuery API. Once you’ve done so, you should see BigQuery in the “Resources” section of Cloud Platform.
    • Note: make sure billing is enabled on your project, otherwise Hightouch will not be able to write into the cluster.
  3. Copy your project ID, as you will need it later.

Create a Service Account and Warehouse Connection in Hightouch

  1. In Hightouch, go to Sources or click https://app.hightouch.io/sources
  2. Click "Create Source"
  3. Select BigQuery
  4. Enter your Google Cloud project ID in the Project field. This can be found in the URL.
  5. For Location, select the region or multi-region of your dataset
  6. Click "Create a service account." This creates a Google service account in Hightouch's Google cloud. Refer to Google Cloud’s documentation about service accounts for more information.
  7. To grant the new account access to your project, copy the two authentication commands and run them in your Google account. The easiest way to do this is with the Google Cloud Shell.
  8. Click Test button
  9. If Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page