Skip to main content

​
Overview

Hightouch lets you pull data from CSV and JSON files stored in Google Cloud Storage (GCS) and push them to downstream destinations. To get started, you need a GCS bucket and Google Cloud credentials.

​
Cloud credential setup

See the guide for configuring GCP credentials to learn how you can set up a service account and use its credentials. The IAM user whose credentials you use must have programmatic access enabled and permission to read from the Cloud Storage path you want to use.

​
Connection configuration

To get started, go to the Sources overview page and click the Add source button. Select Google Cloud Storage and follow the steps below.

​
Configure your service account

Select the credentials you previously created or click Create new to set them up now.

​
Configure your source

Enter the Project ID or your GCS project and the Bucket name. The bucket name should be just the name of the bucket, not a URL.

​
Test your connection

When setting up GCS as a source for the first time, Hightouch validates your GCP credentials and access to your GCS bucket. Once the test passes, click Continue to finish setup.

​
Create models

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up models to define which data you want to pull from your GCS bucket. The file in your GCS bucket must have either a .csv or .json extension.

​
CSV requirements

CSV files must meet the following requirements:
  • They must have a .csv extension.
  • They must have a header row. The values in the header row are automatically available as column names when you set up a sync.
  • They must use comma-separated values; tabs and other delimiters aren’t supported.
  • They must use double quotes (") for quoted values.

​
JSON requirements

JSON files must meet the following requirements:
  • They must have a .json extension.
  • The input file must contain an array at the top level.
  • Each element in the input file must be an object with the same keys.
The keys of the array elements are automatically available as column names when you set up a sync.

​
Model setup

  1. In Hightouch, go to the Models overview page.
  2. Click Add model.
  3. Select the GCS source you previously created.
  4. Enter the relative path to the CSV or JSON file that you want to sync data from, like path/file.csv. The path shouldn’t contain the bucket name.
  5. Preview your model’s query results.
  6. Click Continue.
  7. Name your model and select its primary key. Hightouch uses the primary key to determine which rows have been added, changed, or removed since the last sync.

​
Tips and troubleshooting

If you run into an issue this page doesn’t cover, .
Last modified on November 15, 2023