Python DB API 2.0 (PEP 249) client for Amazon Athena
Project Links
Meta
Author: laughingman7743
Requires Python: >=3.9
Classifiers
Development Status
- 4 - Beta
Intended Audience
- Developers
License
- OSI Approved :: MIT License
Operating System
- OS Independent
Programming Language
- Python :: 3
- Python :: 3.9
- Python :: 3.10
- Python :: 3.11
- Python :: 3.12
- Python :: 3.13
Topic
- Database :: Front-Ends
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 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] |
>=10.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
3.19.0
Oct 18, 2025
3.18.0
Sep 07, 2025
3.17.1
Aug 16, 2025
3.17.0
Aug 09, 2025
3.16.0
Aug 03, 2025
3.15.0
Jul 19, 2025
3.14.1
May 25, 2025
3.14.0
May 18, 2025
3.13.0
Apr 24, 2025
3.12.2
Dec 28, 2024
3.12.1
Dec 28, 2024
3.12.0
Dec 26, 2024
3.11.0
Dec 07, 2024
3.10.0
Dec 04, 2024
3.9.0
Aug 06, 2024
3.8.3
May 26, 2024
3.8.2
May 06, 2024
3.8.1
May 05, 2024
3.8.0
May 02, 2024
3.7.0
Apr 23, 2024
3.6.0
Apr 03, 2024
3.5.1
Mar 18, 2024
3.5.0
Mar 17, 2024
3.4.1
Mar 18, 2024
3.4.0
Mar 15, 2024
3.3.0
Feb 11, 2024
3.2.1
Feb 03, 2024
3.2.0
Jan 26, 2024
3.1.1
Feb 03, 2024
3.1.0
Jan 09, 2024
3.0.10
Oct 29, 2023
3.0.9
Oct 11, 2023
3.0.8
Sep 21, 2023
3.0.7
Sep 12, 2023
3.0.6
Jul 16, 2023
3.0.5
Jul 12, 2023
3.0.4
Jun 29, 2023
3.0.3
May 29, 2023
3.0.2
May 17, 2023
3.0.1
May 14, 2023
3.0.0
May 04, 2023
2.25.2
Apr 23, 2023
2.25.1
Apr 22, 2023
2.25.0
Apr 22, 2023
2.24.2
Apr 23, 2023
2.24.1
Apr 22, 2023
2.24.0
Apr 09, 2023
2.23.2
Apr 23, 2023
2.23.1
Apr 22, 2023
2.23.0
Feb 14, 2023
2.22.2
Apr 23, 2023
2.22.1
Apr 22, 2023
2.22.0
Feb 09, 2023
2.21.3
Apr 23, 2023
2.21.2
Apr 22, 2023
2.21.1
Feb 09, 2023
2.21.0
Feb 04, 2023
2.20.3
Apr 23, 2023
2.20.2
Apr 22, 2023
2.20.1
Feb 09, 2023
2.20.0
Jan 27, 2023
2.19.4
Apr 23, 2023
2.19.3
Apr 22, 2023
2.19.2
Feb 09, 2023
2.19.1
Jan 28, 2023
2.19.0
Dec 30, 2022
2.18.6
Apr 23, 2023
2.18.5
Apr 22, 2023
2.18.4
Feb 09, 2023
2.18.3
Jan 28, 2023
2.18.2
Dec 30, 2022
2.18.1
Dec 18, 2022
2.18.0
Dec 18, 2022
2.17.0
Dec 02, 2022
2.16.1
Nov 30, 2022
2.16.0
Nov 26, 2022
2.15.0
Nov 17, 2022
2.14.0
Aug 15, 2022
2.13.0
Jul 31, 2022
2.12.0
Jul 28, 2022
2.11.0
Jul 26, 2022
2.10.0
Jul 17, 2022
2.9.6
Jul 09, 2022
2.9.5
Jun 24, 2022
2.9.4
Jun 21, 2022
2.9.3
Jun 11, 2022
2.9.2
Jun 10, 2022
2.9.1
Jun 06, 2022
2.9.0
Jun 04, 2022
2.8.0
May 22, 2022
2.7.0
May 15, 2022
2.6.1
May 07, 2022
2.6.0
May 05, 2022
2.5.4
May 04, 2022
2.5.3
May 03, 2022
2.5.2
Apr 09, 2022
2.5.1
Mar 12, 2022
2.5.0
Mar 05, 2022
2.4.1
Jan 16, 2022
2.4.0
Jan 15, 2022
2.3.2
Dec 05, 2021
2.3.1
Nov 23, 2021
2.3.0
May 29, 2021
2.2.0
Mar 16, 2021
2.1.2
Feb 28, 2021
2.1.1
Jan 16, 2021
2.1.0
Dec 30, 2020
2.0.2
Dec 29, 2020
2.0.1
Dec 28, 2020
2.0.0
Nov 07, 2020
1.11.5
Feb 28, 2021
1.11.4
Jan 16, 2021
1.11.3
Dec 30, 2020
1.11.2
Sep 22, 2020
1.11.1
Aug 22, 2020
1.11.0
Jul 12, 2020
1.10.8
Jun 28, 2020
1.10.7
May 13, 2020
1.10.6
May 10, 2020
1.10.5
Apr 26, 2020
1.10.4
Apr 12, 2020
1.10.3
Mar 28, 2020
1.10.2
Feb 29, 2020
1.10.1
Feb 08, 2020
1.10.0
Jan 13, 2020
1.9.0
Dec 14, 2019
1.8.0
Oct 13, 2019
1.7.2
Oct 03, 2019
1.7.1
Jun 30, 2019
1.7.0
Jun 16, 2019
1.6.1
Apr 15, 2019
1.6.0
Apr 14, 2019
1.5.1
Mar 23, 2019
1.5.0
Mar 05, 2019
1.4.6
Feb 11, 2019
1.4.5
Feb 09, 2019
1.4.4
Dec 22, 2018
1.4.3
Dec 01, 2018
1.4.2
Oct 06, 2018
1.4.1
Sep 25, 2018
1.4.0
Sep 25, 2018
1.3.0
Jul 21, 2018
1.2.5
May 31, 2018
1.2.4
May 22, 2018
1.2.3
Apr 21, 2018
1.2.2
Feb 26, 2018
1.2.1
Feb 10, 2018
1.2.0
Sep 24, 2017
1.1.0
Jul 29, 2017
1.0.3
Jul 07, 2017
1.0.2
Jun 04, 2017
1.0.1
May 28, 2017
1.0.0
May 20, 2017
Wheel compatibility matrix
Files in release
Extras:
Dependencies:
boto3
(>=1.26.4)
botocore
(>=1.29.4)
fsspec
python-dateutil
tenacity
(>=4.1.0)