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.9 3.10, 3.11 3.12 3.13

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]

>=7.0.0

fastparquet

pip install PyAthena[fastparquet]

>=0.4.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.14.1.tar.gz (56.0 kB view details)

Uploaded Source

Built Distribution

pyathena-3.14.1-py3-none-any.whl (76.2 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.14.1.tar.gz
Algorithm Hash digest
SHA256 ff628261595b52bc2b74809c42ef89886f74be01371506e289fdb0bc4f653993
MD5 10a5d3532ad98dc80f29157bdad93638
BLAKE2b-256 1c090768a7f58d82b42544124d97d6bee5097397f6addf377e8b46e54c9b9f2b

See more details on using hashes here.

Provenance

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

File metadata

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

File hashes

Hashes for pyathena-3.14.1-py3-none-any.whl
Algorithm Hash digest
SHA256 cdba338da81cc982d9babdbf801631655a5fd4ce9bf4e44a257efa431d891b36
MD5 6fe67d745a75a9dda96ae147130dd7d9
BLAKE2b-256 9d4823e2eadd819220e8a799734175058bf31c93e6f3f493eb72b73f8c5e1ce5

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.14.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 Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page