PyAthena

PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

Quick Start

pip install PyAthena
from pyathena import connect

cursor = connect(
    s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
    region_name="us-west-2"
).cursor()

cursor.execute("SELECT 1")
print(cursor.fetchone())

Documentation

Getting Started
Cursors
Integrations
Advanced Topics
API Reference