PyAthena

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

Package
CI/CD
Meta

Requirements

• Python
  • CPython 3.9 3.10, 3.11 3.12 3.13

Installation

$ pip install PyAthena

Extra packages:

Package	Install command	Version
SQLAlchemy	pip install PyAthena[SQLAlchemy]	>=1.0.0
Pandas	pip install PyAthena[Pandas]	>=1.3.0
Arrow	pip install PyAthena[Arrow]	>=7.0.0
fastparquet	pip install PyAthena[fastparquet]	>=0.4.0

Usage

from pyathena import connect

cursor = connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
                 region_name="us-west-2").cursor()
cursor.execute("SELECT * FROM one_row")
print(cursor.description)
print(cursor.fetchall())

License

MIT license

Many of the implementations in this library are based on PyHive, thanks for PyHive.

Links

• Documentation: https://laughingman7743.github.io/PyAthena/
• PyPI Releases: https://pypi.org/project/PyAthena/
• Source Code: https://github.com/laughingman7743/PyAthena/
• Issue Tracker: https://github.com/laughingman7743/PyAthena/issues