How-to guideSourcesManaged setup
Managed AWS Athena Setup
Prepare the workgroup, Glue Catalog, S3 result location, and least-privilege IAM access needed for a managed Athena connection.
Last reviewed July 13, 2026
Athena setup is Vendo-led. Use this checklist to prepare AWS; Vendo confirms the final connection fields and credential exchange for your workspace.
Before you start
- Create or select an Athena workgroup with appropriate scan controls.
- Confirm the Glue database and tables are queryable in Athena Console.
- Create a dedicated S3 prefix for query results.
- Identify the exact source bucket prefixes the queries need.
Required permission areas
The IAM principal generally needs permission to:
- Start, inspect, retrieve, and cancel queries in the selected Athena workgroup.
- Read the required Glue databases, tables, and partitions.
- Read only the approved source S3 prefixes.
- List the required buckets.
- Write and read the dedicated Athena result prefix.
Vendo will provide the final resource-scoped policy for the agreed configuration. Avoid broad Resource: "*" grants when the AWS service supports resource scoping.
Connect with Vendo
- Share the non-secret region, workgroup, catalog, database, and S3 paths.
- Agree on the credential method and rotation owner.
- Apply the reviewed IAM policy.
- Transfer credentials through the approved secret channel.
- Ask Vendo to run metadata discovery and one bounded query.
Verify
- Compare the visible database/table list with the approved scope.
- Run the same small query in Athena Console and Vendo.
- Compare row count, values, query region, and result location.
- Review CloudTrail and Athena history for the Vendo principal.
- Set an access-review and credential-rotation date.
Troubleshooting
| Symptom | Check |
|---|---|
| Access denied | Workgroup, Glue, source S3, and result S3 permissions |
| Database missing | AWS region and Glue Catalog name |
| Query result unavailable | Result prefix permissions and encryption key access |
| Scan cost is high | Partitions, selected columns, file format, and workgroup limits |
Related
Last updated on