Amazon Athena

https://aws.amazon.com/athena/

Amazon Athena is an interactive query service for analyzing data in S3 using SQL.

Installation

Required packages: pyathena[pandas]

Drivers

PyAthena (REST)Recommended

PyAthenaJDBC

PyPI Package: pyathena[pandas]

awsathena+rest://{aws_access_key_id}:{aws_secret_access_key}@athena.{region_name}.amazonaws.com/{schema_name}?s3_staging_dir={s3_staging_dir}

No Java required. URL-encode special characters (e.g., s3:// -> s3%3A//).

Engine Parameters

IAM Role Assumption

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Time Grains

Common Time Grains:

SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR

Troubleshooting

Common error messages you may encounter when connecting to or querying Amazon Athena, along with their causes and solutions.

Query1 error

Notes

URL-encode special characters in s3_staging_dir (e.g., s3:// becomes s3%3A//).

Help improve this documentation by editing the engine spec:

Edit athena.py