PyAthena¶ PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena. Documentation¶ Contents: Introduction Requirements Installation Features License Usage Basic usage Cursor iteration Query with parameters Quickly re-run queries Query Execution Callback Environment variables Credentials SQLAlchemy Connection string Dialect & driver Dialect options Temporal/Time-travel with Iceberg Complex Data Types Cursor DefaultCursor DictCursor AsyncCursor AsyncDictCursor PandasCursor AsyncPandasCursor ArrowCursor AsyncArrowCursor SparkCursor AsyncSparkCursor API Reference Pandas As DataFrame To SQL PandasCursor AsyncPandasCursor Arrow ArrowCursor AsyncArrowCursor Spark SparkCursor AsyncSparkCursor Testing Environment variables Run test Run test multiple Python versions Code formatting GitHub Actions API Reference Connection and Cursors Pandas Integration Apache Arrow Integration Spark Integration Data Conversion File System Integration Data Models Utilities and Configuration Exception Handling Quick Reference