Get Started

OverviewCreate a sourceCreate a modelCreate a destinationCreate a sync


AirtableAmazon AthenaAmazon RedshiftClickhouseDatabricksFireboltGoogle BigQueryGoogle SheetsLookerMySQLPostgreSQLRocksetSnowflakeSQL ServerTrino
Documentation/Sources/Amazon athena

Amazon Athena

Table of Contents
Create the Warehouse connection in Hightouch

Create the Warehouse connection in Hightouch

Hightouch will always connect to your warehouse from or You may allow-list this IP address in your VPC security groups.
  1. In Hightouch, go to Sources or click
  2. Click "Create 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:
  • MAP
Read more about Athena data types in the Athena documentation.