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.

Links

Project links

Data verified by PyPI on Dec 28, 2024
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (3.35.4)

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for laughingman7743 from gravatar.com laughingman7743

Credits

Author: laughingman7743

GitHub Statistics

Data verified by PyPI on Dec 28, 2024
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License

MIT License (Copyright 2017 laughingman7743 Permission is hereby granted, free of charge, to any person obtainin...)

Requires

Python >=3.9

Provides Extra

arrow fastparquet pandas sqlalchemy

Classifiers

Report project as malware

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.1.tar.gz (56.2 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.12.1-py3-none-any.whl (76.0 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: pyathena-3.12.1.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.1.tar.gz
Algorithm Hash digest
SHA256 35f2eb8ae3006138f5f2e6ab6ac361267a1eb5132c2f6621635b6b3710b2355b
MD5 5661a620fdaaa1b9f7b3c13613d84cc2
BLAKE2b-256 ba55967f9a14328514e29a88c98ef8c8ae198bc3402d92163ef9fc7d28ab9856

See more details on using hashes here.

Provenance

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

File metadata

  • Download URL: pyathena-3.12.1-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.1-py3-none-any.whl
Algorithm Hash digest
SHA256 39ca352f23cf52ba04ec6086550b94b4096215f389f4aa500880a0d5c9d381ab
MD5 9bb4b1735b04b2dc225c444e5c992481
BLAKE2b-256 b97685cba2375c03067b6e6331330b5851463fdb9eac1375f2e75ceb30af3896

See more details on using hashes here.

Provenance

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

Release history Release notifications | RSS feed

3.35.4

3.35.3

3.35.2

3.35.1

3.35.0

3.34.0

3.33.0

3.32.0

3.31.1

3.31.0

3.30.1

3.30.0

3.29.3

3.29.2

3.29.1

3.29.0

3.28.0

3.27.2

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

This release

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

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