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

Package
CI/CD
Meta

• Python
  • CPython 3.8 3.9 3.10, 3.11 3.12

$ pip install PyAthena

Extra packages:

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())

MIT license

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

• 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