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