Google BigQuery

Configuration details for the BigQuery connection

Getting Started

First, you’ll want to enable BigQuery for your Google Cloud project. Then, you will create a Service Account for Hightouch to use. Last, you will create the warehouse in Hightouch.

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 for Hightouch

Refer to Google Cloud’s documentation about service accounts for more information.

1. From the Navigation panel on the left, go to IAM & admin > Service accounts

2. Click Create Service Account along the top

3. Enter a name (for example: “hightouch”) and click Create

4. When assigning permissions, make sure to grant the following roles:

   • BigQuery Data Viewer

   • BigQuery Job User

5. Create a JSON key. The downloaded file will be used to create your warehouse in the next section.

Create the 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, type "US" or "EU" (without quotes)

6. Copy the contents of the credentials (the JSON key) into the Credentials field

7. Click the Test button

8. If Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page

If not, contact Hightouch at [e-mail], and we're happy to assist you.