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.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.

Project details


Release history Release notifications | RSS feed

This version

3.6.0

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.6.0.tar.gz (50.0 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.6.0-py3-none-any.whl (69.6 kB view details)

Uploaded Python 3

File details

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

File metadata

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

File hashes

Hashes for pyathena-3.6.0.tar.gz
Algorithm Hash digest
SHA256 da37fb9b0fdc4d2e715b718b65893ad2e50b508225934d689f8f78d8ec36af06
MD5 a5609afa1bc2bd5322ef9199d48b54d2
BLAKE2b-256 9d3b7c17c7beb442da0fd7bf85666d9a64fc574730c17f8c1eb918bd2f09648d

See more details on using hashes here.

File details

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

File metadata

  • Download URL: pyathena-3.6.0-py3-none-any.whl
  • Upload date:
  • Size: 69.6 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.6.0-py3-none-any.whl
Algorithm Hash digest
SHA256 8beaa4a4e4a4ff8ee5a6be21ace028c62ecb4f6a29328d9c03eb02c15c4531a3
MD5 f74210804d003c3134a04620c17ad737
BLAKE2b-256 a9eab97a44691200159583f9e4fbea7754468fa98c4cb6646e341474d3b7846f

See more details on using hashes here.

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