Integrate.io ETL can read data from your Amazon Athena instance or write data to it. This article discusses providing Integrate.io ETL access on your Amazon Athena and then details creating the Amazon Athena connection in Integrate.io ETL.
To allow Integrate.io ETL access to Amazon Athena:
- Create an IAM user in AWS.
- Attach the
AmazonAthenaFullAccesspolicy to the user.
- Create security credentials for the user and save them for later use when defining the connection in Integrate.io ETL.
To define a connection in Integrate.io ETL to Amazon Athena:
- Click the Connections icon (lightning bolt) on the top left menu.
- To create a connection, click New connection.
- Choose Amazon Athena and name the connection.
- Select AWS region.
- Type in the S3 staging directory to use with Athena in the form
s3://bucket/path. Note that the bucket should be in the same region you selected above.
- Enter the default database to use. If you leave it empty, the user's default database will be used.
- Fill out the IAM access key and secret.
- Click Test connection. If the credentials are correct, a message that the connection test was successful appears.
- Click Create connection.