Python DB API 2.0 (PEP 249) client for Amazon Athena
Project description
PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
Package |
|
CI/CD |
|
Meta |
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
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.