Search documentation...

K

Google BigQuery

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

You'll need to allowlist Hightouch's IP addresses to allow our systems to contact your warehouse. Reference our docs to determine which IPs you need to allowlist.

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

  1. In Hightouch, go to Sources or click https://app.hightouch.io/sources
  2. Click Add source
    Selecting Add Source
  3. Select Google BigQuery
    Select Connect Source
  4. Enter your Google Cloud project ID in the Project field.
  5. For Location, select the region or multi-region of your dataset
    Configure Project
  6. Select your Google Cloud credential (service account). If you need to create a cloud credential, consult our documentation.
  7. Make sure your service account has the proper permissions to interact with BigQuery. The easiest way to do this is to run the provided commands with the Google Cloud Shell.
  8. Click Test button
    Test Successful
  9. If Hightouch is able to successfully connect, click the Complete button at the bottom of the page

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    or

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

SetupCreate a Project and Enable BigQueryCreate a Hightouch source

Was this page helpful?