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 PyAthenaExtra 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 |
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())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
![dependabot[bot]](https://avatars.githubusercontent.com/u/49699333?size=120)
