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.8 3.9 3.10, 3.11 3.12

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

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

License

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

Requires

Python >=3.8.1

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.8.3.tar.gz (55.8 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.8.3-py3-none-any.whl (75.4 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: pyathena-3.8.3.tar.gz
  • Upload date:
  • Size: 55.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/5.0.0 CPython/3.12.3

File hashes

Hashes for pyathena-3.8.3.tar.gz
Algorithm Hash digest
SHA256 99c60860e830c3850cd0201c76d383d76a69e777253dd0ea37ce5b2d11c60da8
MD5 26c02b645e8c2a943fa623a26be70546
BLAKE2b-256 6aaff89ca615d8808e5d79da00b92be684c6d034080c17b9da462702dfd89249

See more details on using hashes here.

File details

Details for the file pyathena-3.8.3-py3-none-any.whl.

File metadata

  • Download URL: pyathena-3.8.3-py3-none-any.whl
  • Upload date:
  • Size: 75.4 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/5.0.0 CPython/3.12.3

File hashes

Hashes for pyathena-3.8.3-py3-none-any.whl
Algorithm Hash digest
SHA256 99b24e922a15deb5bebc7d6fd7baa1612cec2bbacfe816c3d116da774355e07f
MD5 50a581545ef60c2e5d9158a8d32db1ad
BLAKE2b-256 dfa4c4f04dc5929d1c69302628ae9bf77b5807d7c9b093924a5abd3033a6719d

See more details on using hashes here.

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

3.12.1

3.12.0

3.11.0

3.10.0

3.9.0

This release

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