PyAthena¶
PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
Quick Start¶
pip install PyAthena
from pyathena import connect
cursor = connect(
s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2"
).cursor()
cursor.execute("SELECT 1")
print(cursor.fetchone())
Documentation¶
Getting Started
Getting Started
- Introduction
- Usage
- Basic usage
- Managed query result storage
- Cursor iteration
- Query with parameters
- Execution options
- Quickly re-run queries
- Federated passthrough queries
- Query execution callback
- Query cancellation on interrupt
- Query polling callback
- Type hints for complex types
- Table and database metadata
- Environment variables
- Credentials
Integrations
Advanced Topics
Advanced Topics
API Reference
API Reference