Python DB API 2.0 (PEP 249) client for Amazon Athena

Navigation

Verified details

These details have been verified by PyPI
Project links
GitHub Statistics
Maintainers
Avatar for laughingman7743 from gravatar.com laughingman7743

Unverified details

These details have not been verified by PyPI
Meta
  • License: MIT License (Copyright 2017 laughingman7743)
  • Author: laughingman7743
  • Requires: Python >=3.10
  • Provides-Extra: arrow , pandas , polars , sqlalchemy
Classifiers
Report project as malware

Project description

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 details

Verified details

These details have been verified by PyPI
Project links
GitHub Statistics
Maintainers
Avatar for laughingman7743 from gravatar.com laughingman7743

Unverified details

These details have not been verified by PyPI
Meta
  • License: MIT License (Copyright 2017 laughingman7743)
  • Author: laughingman7743
  • Requires: Python >=3.10
  • Provides-Extra: arrow , pandas , polars , sqlalchemy
Classifiers

Release history Release notifications | RSS feed

This version

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

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.27.1.tar.gz (114.5 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.27.1-py3-none-any.whl (153.6 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.27.1.tar.gz
Algorithm Hash digest
SHA256 482572e624560b6f238c2fcaf467d372602952315bc5b471e818d008f19c93f5
MD5 20e392406f22f24d0a438f2136cd52e4
BLAKE2b-256 6221d1d5b9c8c81ffc755a79e29a4d8448b7ce13eda970da1b9882f360c04269

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: pyathena-3.27.1-py3-none-any.whl
  • Upload date:
  • Size: 153.6 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.27.1-py3-none-any.whl
Algorithm Hash digest
SHA256 7bb0e1d3d692f71387ec75fe62ae6912acb32db5500233db07a06189783409d2
MD5 502e66876e1a28cc5965583a72445afb
BLAKE2b-256 709c023fb3b7744ffcc9c23670f9114260c5cbc87d3e4553240bc0690c5553ca

See more details on using hashes here.

Provenance

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

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