Search documentation...

K

Amazon S3

Securely sync CSV or JSON data from any S3 bucket

Need to join, transform, or filter your S3 data? Consider using our AWS Athena source to directly query your S3 data using SQL. Learn more →

Overview

Hightouch supports syncing data from CSV and JSON files stored in AWS S3.

Setup

To get started, you will need an S3 bucket and AWS credentials. The "Bucket Name" should just be the name of the bucket, not a URL. The IAM user needs to have programmatic access enabled and permission to read from the S3 path you want to use.

Supported Authentication Methods

See the guide for configuring AWS credentials.

Source file format

The file must have the extension .csv or .json.

CSV

CSV files must have a header row. The values in the header row will be automatically available as column names when you set up a sync.

JSON

When using JSON files as input,

  • 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 will be automatically available as column names when you set up a sync.

    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

OverviewSetupSupported Authentication MethodsSource file format

Was this page helpful?