Search documentation...

K

Amazon Athena

Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.

Create the Warehouse connection in Hightouch

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.

  1. In Hightouch, go to Sources or click https://app.hightouch.com/sources.

    Selecting Add Source

  2. Click "Create Source."

    Selecting Postgres Source

  3. Select Amazon Athena.

  4. Select a Region.

  5. Enter your AWS Access Key ID and Secret Access Key. The credentials must be for a user who has permission to access Athena and the Output Location in S3. After you enter a region and credentials, more options will appear.

  6. Select an Athena Work Group that you have previously set up in AWS.

  7. If your Work Group does not have an Output Location configured, enter an Output Location for the query results. This is an S3 path.

  8. Select a Data Catalog.

  9. Select a Database.

  10. Click "Test" to test the connection. Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page

Data Types

Hightouch parses most Athena data types into JavaScript types before sending them to your destination. The following Athena data types are left as strings:

  • BIGINT
  • ARRAY
  • MAP
  • BINARY
  • STRUCT

Read more about Athena data types in the Athena documentation.

    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

Create the Warehouse connection in HightouchData Types

Was this page helpful?