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.12.2.tar.gz (56.2 kB view details)

Uploaded Source

Built Distribution

pyathena-3.12.2-py3-none-any.whl (76.0 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: pyathena-3.12.2.tar.gz
  • Upload date:
  • Size: 56.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.0.1 CPython/3.12.8

File hashes

Hashes for pyathena-3.12.2.tar.gz
Algorithm Hash digest
SHA256 035ebad637c64c26fc83c1da87b46134e52c58c95186899f9ec6b110c4ea8658
MD5 2671b41eadbf202354a6e1939c1c93ca
BLAKE2b-256 c9192c45e303878112bc92c42c303e714b5aeab852ec95fb40f057450370e3c8

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: pyathena-3.12.2-py3-none-any.whl
  • Upload date:
  • Size: 76.0 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/6.0.1 CPython/3.12.8

File hashes

Hashes for pyathena-3.12.2-py3-none-any.whl
Algorithm Hash digest
SHA256 f27f89a04c2278a6e898c25a1ef64892bfacfb38134b5c69f646a5034dd67eb6
MD5 6a4249ac2329049c881a2d42087165b5
BLAKE2b-256 bf391d4e48a7f069d69e72e490a239fbeaff2220ffa893cc5d6686981898be54

See more details on using hashes here.

Provenance

The following attestation bundles were made for pyathena-3.12.2-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 AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page