Connect to Amazon Athena

Configure Athena with an AWS profile, region, workgroup, catalog, database and result location.

Amazon Athena has been requested in other tools since 2018, with 134 votes.

An Athena connection needs an AWS identity and a region. A named AWS profile or IAM Identity Center flow supplies credentials, while the region determines the service endpoint and the regional price used by a cost estimate.

The workgroup is part of the query target. It can manage results itself, write them to an S3 location, or require the connection to provide a valid S3 result location. Workgroup settings can also impose a per-query scan cutoff and enforce the administrator’s result configuration.

The catalog and optional database determine which tables, views and partitions are visible to the query. A federated catalog may route reads through another service and can have costs that are not represented by a simple Athena byte estimate. Tablyne keeps that distinction visible in the connection context.

Tablyne keeps the scan estimate and protection settings beside the connection target. The workgroup cutoff remains the server-side boundary, and endpoint overrides can be configured separately for a VPC setup.

Tablyne uses the profile, region, workgroup, catalog and result-location settings to establish the Athena query target.