Skip to main content

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

Project description

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

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.

Project details


Release history Release notifications | RSS feed

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.26.0.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.26.0-py3-none-any.whl (153.5 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: pyathena-3.26.0.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.26.0.tar.gz
Algorithm Hash digest
SHA256 902380f52b953b73a10d6182b7145c4f739f2d0fcc050b408b4eb1a345b48016
MD5 e9f9dc70f7f0b05ad838de5e38a1c114
BLAKE2b-256 6d6f175b48abd18c2a135c0ad2c093d340fdf75cb16cc25441a965c2fa04a727

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: pyathena-3.26.0-py3-none-any.whl
  • Upload date:
  • Size: 153.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.26.0-py3-none-any.whl
Algorithm Hash digest
SHA256 c679e5a90d8fe0bf5871e03df4af9bfe9a896c5fed3799fb95be93c664e45aa5
MD5 94f14a1d756927dd37bc73cd3cb4d331
BLAKE2b-256 15d5543aabe44fe99cc22def83f3da6722625e3efd4cde86c19bd082d65ad224

See more details on using hashes here.

Provenance

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

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