Skip to main content

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.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

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.

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.23.0.tar.gz (102.4 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.23.0-py3-none-any.whl (134.2 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.23.0.tar.gz
Algorithm Hash digest
SHA256 dcaacfc606b043433341bd0b5cbac984b27460e1af4f245c2c82b1c2f0b08632
MD5 fdf31904ee78a959e2df0becba3e94ec
BLAKE2b-256 4a5bea2b76941f0c3d5f3f61916fe6656c3d7041f8cde513a3caada8a92ab42c

See more details on using hashes here.

Provenance

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

Publisher: release.yaml on laughingman7743/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.23.0-py3-none-any.whl.

File metadata

  • Download URL: pyathena-3.23.0-py3-none-any.whl
  • Upload date:
  • Size: 134.2 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.23.0-py3-none-any.whl
Algorithm Hash digest
SHA256 b6f9e1983fc888ff33783ab1a8f2a8de3430609bb4a79a6f31441605631d7570
MD5 89f85f82a8e85a9c3b9cd86ad944114c
BLAKE2b-256 d6d8df0cf1c480aa07535a6c19ec2b48cbbe0a6eb6d5c5b9259cc145a0674ae9

See more details on using hashes here.

Provenance

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

Publisher: release.yaml on laughingman7743/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

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