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:
  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.com/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?

    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?