Allowing Xplenty access to my Amazon Athena instance

To allow Xplenty to Amazon Athena

  1. Create an IAM user in AWS.
  2. Attach the AmazonAthenaFullAccess policy to the user.
  3. Create security credentials for the user and save them for later use when defining the connection in Xplenty.

To define a connection in Xplenty to Amazon Athena

  1. Click your avatar, then click Account settings.
  2. Click Connections, then click new connection and click Amazon Athena.
  3. Type a name for the connection.
  4. Select AWS region.
  5. 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.
  6. Enter the default database to use. If you leave it empty, the user's default database will be used.
  7. Fill out the IAM access key and secret.
  8. Click test connection. If the credentials are correct, a message that the connection test was successful appears.
  9. The connection is created and appears in the list of connections
  10. Click create amazon s3 connection.

Feedback and Knowledge Base