Connect AWS Athena

Prerequisites

• You have an IAM user dedicated for Skoot Athena access.
• You have an Athena workgroup configured for Skoot queries.
• You have read access to source data and metadata (Glue/Athena catalog + databases + tables).
• You have an S3 query results location configured through your Athena workgroup.

Step 1 - Create/Use a Dedicated IAM User

Use a dedicated IAM user for Skoot. Avoid shared admin credentials.

Step 2 - Attach Athena Access Policy

Attach the policy created for Skoot Athena access to that IAM user.

Minimum capability needed by Skoot:

• Athena query actions in your selected workgroup
• Glue metadata read access for schema discovery
• S3 read access for underlying data
• S3 read/write access for Athena query results path

Step 3 - Create Access Key

Create an access key for that IAM user and store it securely.

You will use:

• Access Key ID
• Secret Access Key

Step 4 - Optional: IP Whitelisting

If your environment enforces network allowlists, allowlist Skoot public egress IP from Data Sources .

Connect in Skoot App

After Athena setup is complete:

1. Click AWS Athena in Available Data Sources section AWS Athena Connection .
2. Fill these fields exactly:
   • Connection Name
   • AWS Region
   • Access Key ID
   • Secret Access Key
   • Workgroup
   • Catalog
   • Query Timeout (ms) (minimum 1000)
3. Save the connection.
4. Confirm status is Connected.

Related Pages

• Data Sources Overview
• Supported Data Sources
• 15-Minute Quickstart