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.21.0.tar.gz (86.9 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.21.0-py3-none-any.whl (112.1 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.21.0.tar.gz
Algorithm Hash digest
SHA256 fc81b7836841da02ffddaa49b23498d635ce360d7406141ea0eff32e7c984eca
MD5 37f7c174f38e22b10a114f07180c39d7
BLAKE2b-256 dbcfe436300a9b9184b75fd86d74a19c9a50ee7ac6fabd747fbbfe85b25c5302

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.21.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.21.0-py3-none-any.whl.

File metadata

  • Download URL: pyathena-3.21.0-py3-none-any.whl
  • Upload date:
  • Size: 112.1 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.21.0-py3-none-any.whl
Algorithm Hash digest
SHA256 7545994889cfbaee3223867cf55cf64d3ed936d96e76711e1334fd5edfdf8005
MD5 359f539f51a54d52fb6cdd656a95f7ff
BLAKE2b-256 8c41b80861f56c10ff506373fb4706c3eab033020b997156acbb2834b8c28aa0

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.21.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