/PyAthena

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

Primary LanguagePythonMIT LicenseMIT

PyAthena

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

Package badge package badge pypi badge downloads
CI/CD badge test badge docs
Meta badge license Ruff mypy

Requirements

  • Python
    • CPython 3.8 3.9 3.10, 3.11 3.12

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