https://badge.fury.io/py/pyathena.svg https://img.shields.io/pypi/pyversions/PyAthena.svg https://github.com/laughingman7743/PyAthena/actions/workflows/test.yaml/badge.svg https://img.shields.io/pypi/l/PyAthena.svg https://static.pepy.tech/badge/pyathena/month Ruff mypy

PyAthena

PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.

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.5.1.tar.gz (49.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.5.1-py3-none-any.whl (69.4 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.5.1.tar.gz
Algorithm Hash digest
SHA256 f53e6a9b756683a79942d77168b9e3e3e779480825268db02a8fbccb6e604229
MD5 0d490b3530feaf2802b6e3139fc1dcef
BLAKE2b-256 05b0a86d4563c55e89245cc3ae61ac9204054dc98f2cfb33895ae4c901b00b1c

See more details on using hashes here.

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.5.1-py3-none-any.whl
Algorithm Hash digest
SHA256 f8da013fcb67f26f544c5e6dc15c7b23269e5318370f0867f6e9e4cbf32a36dd
MD5 e72b6c686abe2932bc193d0891c6cc4f
BLAKE2b-256 68408d4aabfcb8d36c832c3ab2ab66d8f240076884170aa2f77b8358668514ea

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

3.8.3

3.8.2

3.8.1

3.8.0

3.7.0

3.6.0

This release

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