PyAthena

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

Documentation

Contents:

• Introduction
  • Requirements
  • Installation
  • License
• Usage
  • Basic usage
  • Cursor iteration
  • Query with parameters
  • Quickly re-run queries
  • Environment variables
  • Credentials
• SQLAlchemy
  • Connection string
  • Dialect & driver
  • Dialect options
  • Temporal/Time-travel with Iceberg
• Cursor
  • DictCursor
  • AsyncCursor
  • AsyncDictCursor
  • PandasCursor
  • AsyncPandasCursor
  • ArrowCursor
  • AsyncArrowCursor
  • SparkCursor
  • AsyncSparkCursor
• 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