PyAthena

PyAthena logo

PyPI - Version PyPI - Python Version PyPI - Downloads CI - Test CD - Docs License - MIT linting - Ruff types - Mypy

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

Requirements

  • Python

    • CPython 3.10, 3.11, 3.12, 3.13, 3.14

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] >=10.0.0
Polars pip install PyAthena[Polars] >=1.0.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

Logo

The PyAthena logo was generated using Nano-Banana Pro (Gemini 3 Pro Image).

Project links

Data verified by PyPI on Feb 19, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (3.35.4)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for laughingman7743 from gravatar.com laughingman7743

Credits

Author: laughingman7743

GitHub Statistics

Data verified by PyPI on Feb 19, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT License (Copyright 2017 laughingman7743)

Requires

Python >=3.10

Provides Extra

arrow pandas polars sqlalchemy

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pyathena-3.28.0.tar.gz (116.3 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pyathena-3.28.0-py3-none-any.whl (155.5 kB view details)

Uploaded Python 3

File details

Details for the file pyathena-3.28.0.tar.gz.

File metadata

  • Download URL: pyathena-3.28.0.tar.gz
  • Upload date:
  • Size: 116.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for pyathena-3.28.0.tar.gz
Algorithm Hash digest
SHA256 73d6f6e9cbe565edd650e91e90c492f7b97c7b50d7f2e2c4de8ac8e2dcbe5b05
MD5 a5caabf6c37849aa61b8653e17140f63
BLAKE2b-256 44c9a7212757a95be9988a65be060b9120a5d16bb0c0bb1bfc71f9c82cbb311b

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.28.0.tar.gz:

Publisher: release.yaml on pyathena-dev/PyAthena

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file pyathena-3.28.0-py3-none-any.whl.

File metadata

  • Download URL: pyathena-3.28.0-py3-none-any.whl
  • Upload date:
  • Size: 155.5 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for pyathena-3.28.0-py3-none-any.whl
Algorithm Hash digest
SHA256 d5043948833a44c81ca17881c635c91f2300be5168394a7038a797f671cde21b
MD5 d3f9861778147533cee750040361aa12
BLAKE2b-256 c567c9a7c02afc46a91f55a2fad1ff987af1c0f79e97efaa78686d4251c1fe3f

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.28.0-py3-none-any.whl:

Publisher: release.yaml on pyathena-dev/PyAthena

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

3.35.4

3.35.3

3.35.2

3.35.1

3.35.0

3.34.0

3.33.0

3.32.0

3.31.1

3.31.0

3.30.1

3.30.0

3.29.3

3.29.2

3.29.1

3.29.0

This release

3.28.0

3.27.2

3.27.1

3.27.0

3.26.0

3.25.0

3.24.1

3.24.0

3.23.0

3.22.0

3.21.1

3.21.0

3.20.0

3.19.0

3.18.0

3.17.1

3.17.0

3.16.0

3.15.0

3.14.1

3.14.0

3.13.0

3.12.2

3.12.1

3.12.0

3.11.0

3.10.0

3.9.0

3.8.3

3.8.2

3.8.1

3.8.0

3.7.0

3.6.0

3.5.1

3.5.0

3.4.1

3.4.0

3.3.0

3.2.1

3.2.0

3.1.1

3.1.0

3.0.10

3.0.9

3.0.8

3.0.7

3.0.6

3.0.5

3.0.4

3.0.3

3.0.2

3.0.1

3.0.0

2.25.2

2.25.1

2.25.0

2.24.2

2.24.1

2.24.0

2.23.2

2.23.1

2.23.0

2.22.2

2.22.1

2.22.0

2.21.3

2.21.2

2.21.1

2.21.0

2.20.3

2.20.2

2.20.1

2.20.0

2.19.4

2.19.3

2.19.2

2.19.1

2.19.0

2.18.6

2.18.5

2.18.4

2.18.3

2.18.2

2.18.1

2.18.0

2.17.0

2.16.1

2.16.0

2.15.0

2.14.0

2.13.0

2.12.0

2.11.0

2.10.0

2.9.6

2.9.5

2.9.4

2.9.3

2.9.2

2.9.1

2.9.0

2.8.0

2.7.0

2.6.1

2.6.0

2.5.4

2.5.3

2.5.2

2.5.1

2.5.0

2.4.1

2.4.0

2.3.2

2.3.1

2.3.0

2.2.0

2.1.2

2.1.1

2.1.0

2.0.2

2.0.1

2.0.0

1.11.5

1.11.4

1.11.3

1.11.2

1.11.1

1.11.0

1.10.8

1.10.7

1.10.6

1.10.5

1.10.4

1.10.3

1.10.2

1.10.1

1.10.0

1.9.0

1.8.0

1.7.2

1.7.1

1.7.0

1.6.1

1.6.0

1.5.1

1.5.0

1.4.6

1.4.5

1.4.4

1.4.3

1.4.2

1.4.1

1.4.0

1.3.0

1.2.5

1.2.4

1.2.3

1.2.2

1.2.1

1.2.0

1.1.0

1.0.3

1.0.2

1.0.1

1.0.0

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page