Athena

The Athena integration lets your team create AddMaple projects from SQL queries, without exporting files first.

This integration is intended for team/enterprise workspaces.

Before you start

You’ll need:

• An AWS Access key ID and Secret access key
• The AWS Region where Athena runs
• An Athena Database and Workgroup
• An S3 Output bucket where Athena query results are written

For best security, use IAM credentials with the minimum permissions needed to run queries and read results.

How to connect

1. Open your team admin page

In AddMaple, open your team admin area and scroll to the Connections section.

2. Add a new connection

Click Add New Connection.

3. Choose "Athena"

Set Connection Type to Athena.

4. Fill in the connection details

Enter:

• Name: a friendly name for your connection
• Region
• Access key ID
• Secret access key
• Database
• Workgroup
• Output bucket

Click Add Connection.

Test the connection and create a project

1. In the connections list, click Test on your Athena connection.
2. AddMaple will show a list of databases and tables.
3. Click Select on a table to generate a starter query (or write your own SQL in SQL Query).
4. Click Test Project to preview sample rows.
5. Click Create Project to turn the query into an AddMaple project.

Further reading

• Integrations