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:

  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 Connections or click https://app.hightouch.io/connections

2. Click "Create New"

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 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 hello@hightouch.io, and we're happy to assist you.