PyPI · #935 most downloaded on PyPI

pyathena

3.37.015M downloads/mopyathena-dev/PyAthena ↗New releases in your daily digest, changelog included.

Python DB API 2.0 (PEP 249) client for Amazon Athena

Last release 5 days ago
29 Sep 2026
Release timing varies
gaps range from 8 days to 2 months
Nearly every release is documented
notes for 60 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
9 years old
184 releases · first in 2017

Release timeline

184 releases since 2017

2017201920212023

Releases

3.37.029 Sept 2026
v3.37.0 is a minor release of the 3.x maintenance line. It backports the SQLAlchemy ARRAY support and fixes from master ( #893 ). The 3.x line keeps s
v3.37.0 is a minor release of the 3.x maintenance line. It backports the SQLAlchemy ARRAY support and fixes from master (#893). The 3.x line keeps supporting Python 3.10 and sqlalchemy>=1.0.0.

SQLAlchemy

Reflected array<...> columns are AthenaArray with their element types, instead of String, and types.ARRAY maps to AthenaArray (#774).

SQLAlchemy ARRAY values, expressions (indexing, slices, concatenation, ANY/ALL), and partial updates are supported (#774, #775, #776).

Behavior changes for SQLAlchemy queries that select ARRAY values (#774):

Typed SELECT results are decoded through a JSON projection, so rewritten queries need explicit SELECT columns, and literal SQL expressions need labels.

Textual ORDER BY supports selected names, lists of them, and ordinals. Use SQLAlchemy expressions for other orderings.

Raw SQL and arrays with unknown element types keep the documented cursor fallback.

ARRAY binds of decimal values require an explicit Numeric precision and scale, to prevent silent rounding.

CREATE TABLE renders STRUCT column types, including STRUCT values inside MAP and ARRAY, as Hive STRUCT<name:type>. Athena rejected the previous ROW(...) output (#870, #855). Thanks to @mvanhorn for the fix and @aminghadersohi for the report. Integers inside ARRAY, MAP, and STRUCT column types render as INT. Code that compares compiled DDL strings must expect STRUCT<...> and INT.

CAST to Double or DOUBLE_PRECISION renders DOUBLE instead of the 32-bit REAL (#826).

The ARRAY support was checked at compile level on SQLAlchemy 1.4.54. The test suite runs on SQLAlchemy 2.0.

Cursors

CSV result sets keep binary NULLs as None (#770).

Development

The Test workflow runs the AWS suites only for ready pull requests, on the newest Python version (#789, #837, #863). Tests are rerun once on Athena service-side failures (#811), and each test session uses its own S3 Tables namespace (#815).

The Release workflow runs every suite on every supported Python version before publishing (#862).

What's Changed

Backport CI and SQLAlchemy changes to 3.x for v3.37.0 by @laughingman7743 in #893, which backports these master pull requests:

Enable Iceberg UPDATE target subquery compliance by @laughingman7743 in #769

Restore SQLAlchemy CTE compliance coverage by @laughingman7743 in #772

Restore SQLAlchemy binary compliance and preserve CSV binary NULLs by @laughingman7743 in #770

Skip AWS integration jobs for external fork pull requests by @laughingman7743 in #789

Support native SQLAlchemy ARRAY types and typed round trips by @laughingman7743 in #774

Support SQLAlchemy ARRAY expressions in SELECT and WHERE by @laughingman7743 in #775

Support SQLAlchemy ARRAY partial UPDATE and slice resizing by @laughingman7743 in #776

Rerun tests once on Athena service-side query failures by @laughingman7743 in #811

Give each test session its own S3 Tables namespace by @laughingman7743 in #815

Run the three test suites in parallel by @laughingman7743 in #814

Re-enable SQLAlchemy parameter and SQL rendering compliance tests by @laughingman7743 in #825

SQLAlchemy compliance: audit numeric range and float precision by @laughingman7743 in #826

Run AWS test suites only on ready pull requests and related changes by @laughingman7743 in #837

Run pull-request AWS tests on the newest Python version only by @laughingman7743 in #863

Run the full test matrix in the Release workflow before publishing by @laughingman7743 in #862

Set up the PyAthena test fixtures only in processes that run tests by @laughingman7743 in #866

Insert SQLAlchemy compliance fixture rows once for read-only classes by @laughingman7743 in #867

Give the executemany and partition tests their own tables by @laughingman7743 in #873

fix: render Hive STRUCT syntax in table column DDL by @mvanhorn in #870

New Contributors

@mvanhorn made their first contribution in #870

Full Changelog: v3.36.0...v3.37.0

One column per quarter.

3.36.02 Sept 2026

Add _escape_trino, keep _escape_presto as a backward-compatible alias by @laughingman7743 in #747

What's Changed

Add _escape_trino, keep _escape_presto as a backward-compatible alias by @laughingman7743 in #747
Add a security policy by @laughingman7743 in #748
Add shared instructions for Codex and Claude Code by @laughingman7743 in #749
Remove dead SQLAlchemy test configuration from pyproject.toml by @laughingman7743 in #751
Add a worktree environment helper by @laughingman7743 in #752
Enable SQLAlchemy update and delete compliance tests by @laughingman7743 in #750
Fix SQLAlchemy true division semantics by @laughingman7743 in #753
Fall back to the original string for complex MAP/STRUCT/ARRAY values instead of returning None by @seunggabi in #763
Update gh-action-pypi-publish to v1.14.2 for metadata 2.5 support by @laughingman7743 in #765

New Contributors

@seunggabi made their first contribution in #763

Full Changelog: v3.35.4...v3.36.0

Open source →

3.35.431 Jul 2026Security

Fix escaper selection for DELETE and CTAS to prevent SQL injection (CVE-2026-65321) by @laughingman7743 in #745

What's Changed

Fix escaper selection for DELETE and CTAS to prevent SQL injection (CVE-2026-65321) by @laughingman7743 in #745

Full Changelog: v3.35.3...v3.35.4

Open source →

3.35.326 Jul 2026

Bump setuptools from 78.1.1 to 83.0.0 by @dependabot [bot] in #741

What's Changed

Bump setuptools from 78.1.1 to 83.0.0 by @dependabot[bot] in #741
fix(sqlalchemy): return the formatted DATE literal from AthenaDate.process by @Sanjays2402 in #743
test(sqlalchemy): cover AthenaTimestamp.process and simplify AthenaDate isinstance by @laughingman7743 in #744

New Contributors

@Sanjays2402 made their first contribution in #743

Full Changelog: v3.35.2...v3.35.3

Open source →

3.35.214 Jul 2026

Bump soupsieve from 2.8 to 2.8.4 by @dependabot [bot] in #738

What's Changed

Bump soupsieve from 2.8 to 2.8.4 by @dependabot[bot] in #738
Fix/739 cache schema catalog by @Liam3851 in #740

New Contributors

@Liam3851 made their first contribution in #740

Full Changelog: v3.35.1...v3.35.2

Open source →

3.35.110 Jul 2026

Restore legacy keyword arguments on the private _execute() methods by @laughingman7743 in #735

What's Changed

Restore legacy keyword arguments on the private _execute() methods by @laughingman7743 in #735

Full Changelog: v3.35.0...v3.35.1

Open source →

3.35.07 Jul 2026

Centralize shared execute() kwargs into an ExecuteOptions dataclass by @laughingman7743 in #733

What's Changed

Centralize shared execute() kwargs into an ExecuteOptions dataclass by @laughingman7743 in #733

Full Changelog: v3.34.0...v3.35.0

Open source →

3.34.06 Jul 2026

Add filesystem API parity features to the built-in S3FileSystem by @laughingman7743 in #729

What's Changed

Add filesystem API parity features to the built-in S3FileSystem by @laughingman7743 in #729
Complete the filesystem parity checklist: pipe_file, version-aware mode, and fsspec registry DX by @laughingman7743 in #730
Use f-strings for the remaining log messages by @laughingman7743 in #731
Allow dispatching the test workflow manually by @laughingman7743 in #732

Full Changelog: v3.33.0...v3.34.0

Open source →

3.33.05 Jul 2026

Replace Makefile with just by @laughingman7743 in #725

What's Changed

Replace Makefile with just by @laughingman7743 in #725
Bump boto3 lower bound to >=1.41.2 to match botocore floor by @laughingman7743 in #726
Support Amazon S3 Tables in the SQLAlchemy dialect and manage test infrastructure in CloudFormation by @laughingman7743 in #727

Full Changelog: v3.32.0...v3.33.0

Open source →

3.32.09 Jun 2026

Add on_poll callback for real-time query monitoring ( #723 ) by @laughingman7743 in #724

What's Changed

Add on_poll callback for real-time query monitoring (#723) by @laughingman7743 in #724

Full Changelog: v3.31.1...v3.32.0

Open source →

3.31.16 Jun 2026

Bump pyarrow from 18.1.0 to 23.0.1 by @dependabot [bot] in #720

What's Changed

Bump pyarrow from 18.1.0 to 23.0.1 by @dependabot[bot] in #720
Fix empty object write for small files in fsspec transactions by @laughingman7743 in #721

Full Changelog: v3.31.0...v3.31.1

Open source →

3.31.024 May 2026

Bump requests from 2.32.4 to 2.33.0 by @dependabot [bot] in #699

What's Changed

Bump requests from 2.32.4 to 2.33.0 by @dependabot[bot] in #699
Pin GitHub Actions to commit SHAs for supply chain security by @laughingman7743 in #700
Update GitHub Actions to latest versions by @laughingman7743 in #702
Bump pygments from 2.18.0 to 2.20.0 by @dependabot[bot] in #703
Bump pytest from 8.3.4 to 9.0.3 by @dependabot[bot] in #704
Bump urllib3 from 2.6.3 to 2.7.0 by @dependabot[bot] in #705
Bump idna from 3.10 to 3.15 by @dependabot[bot] in #706
feat: support newer GetQueryExecution response fields by @laughingman7743 in #708
docs: note JWT Trusted Identity Propagation is not supported by @laughingman7743 in #716
docs: note Result Reuse semantic-equivalence behavior change (2025-11) by @laughingman7743 in #714
ci: introduce markdownlint-cli2 and verify docs build on PRs by @laughingman7743 in #718
docs: add federated passthrough queries section by @laughingman7743 in #715

Full Changelog: v3.30.1...v3.31.0

Open source →

3.30.126 Mar 2026

Move _normalize_hive_syntax to DefaultTypeConverter and fix pass stubs by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/695

What's Changed

Move _normalize_hive_syntax to DefaultTypeConverter and fix pass stubs by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/695
Always use C engine for CSV parsing and simplify engine selection logic by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/697

Bug Fixes

Fix CSV parsing performance regression — PR #594 incorrectly forced the Python CSV engine for files over 50MB based on fabricated claims about pandas C parser int32 limitations. The C engine is now always used as the default (same as pandas' own default), restoring up to 28% faster CSV parsing. See #696 for details.

Internal

Refactored type converter: moved _normalize_hive_syntax to DefaultTypeConverter and cleaned up pass stubs.
Simplified CSV engine selection from 4 methods to 2 by removing dead code and inlining pyarrow compatibility checks.

Affected Versions

All versions from v3.17.0 through v3.30.0 (released 2025-08-09 to 2026-02-28) are affected by this performance regression. The last unaffected version is v3.16.0.

Workaround for older versions

If you cannot upgrade to v3.30.1, explicitly specify the C engine to bypass the incorrect engine selection:

cursor = connection.cursor(PandasCursor, engine="c")

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.30.0...v3.30.1

Open source →

3.30.028 Feb 2026

Add documentation for AioS3FileSystem and S3Executor by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/686

What's Changed

Add documentation for AioS3FileSystem and S3Executor by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/686
Expand ruff lint rules and rename make targets (chk→lint, fmt→format) by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/687
Add AioSQLAlchemy extra package to documentation by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/688
Add result_set_type_hints for precise complex type conversion by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/690

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.29.3...v3.30.0

Open source →

3.29.322 Feb 2026

Add S3Executor strategy pattern for async S3 operations by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/684

What's Changed

Add S3Executor strategy pattern for async S3 operations by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/684

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.29.2...v3.29.3

Open source →

3.29.221 Feb 2026

Fix release workflow and split CI test jobs for independent retries by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/682

What's Changed

Fix release workflow and split CI test jobs for independent retries by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/682
Rename aconnect to aio_connect by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/683

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.29.1...v3.29.2

Open source →

3.29.121 Feb 2026

Add async SQLAlchemy dialects for native asyncio support by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/679

What's Changed

Add async SQLAlchemy dialects for native asyncio support by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/679
Fix mypy errors with SQLAlchemy 2.0.46+ by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/681

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.29.0...v3.29.1

Open source →

3.29.021 Feb 2026

Add native asyncio cursor support (Phase 1) by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/666

What's Changed

Add native asyncio cursor support (Phase 1) by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/666
Add native asyncio specialized cursors and DRY refactors (Phase 2) by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/667
Add native asyncio S3FS and Spark cursors with boilerplate deduplication (Phase 3) by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/668
Add documentation for native asyncio cursors by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/671
Wrap fetch methods in asyncio.to_thread for aio pandas/arrow/polars cursors by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/674
Extract shared boilerplate from sync cursors into WithFetch mixin by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/676
Extract _prepare_unload() helper into BaseCursor by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/678

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.28.0...v3.29.0

Open source →

3.28.019 Feb 2026

Update documentation domain to pyathena.dev by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/663

What's Changed

Update documentation domain to pyathena.dev by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/663
Support Athena managed query result storage by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/665

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.27.2...v3.28.0

Open source →

3.27.215 Feb 2026

Rewrite CLAUDE.md for maintainability by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/660

What's Changed

Rewrite CLAUDE.md for maintainability by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/660
Update repository URLs from laughingman7743 to pyathena-dev by @laughingman7743 in https://github.com/pyathena-dev/PyAthena/pull/661

Full Changelog: https://github.com/pyathena-dev/PyAthena/compare/v3.27.1...v3.27.2

Open source →

3.27.18 Feb 2026

Fix README logo not displaying on PyPI by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/659

What's Changed

Fix README logo not displaying on PyPI by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/659

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.27.0...v3.27.1

Open source →

3.27.08 Feb 2026

Fix retry_api_call to use getEffectiveLevel() instead of logger.level by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/651

What's Changed

Fix retry_api_call to use getEffectiveLevel() instead of logger.level by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/651
Add project logo to README and documentation by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/650
Bump urllib3 from 1.26.20 to 2.6.3 by @dependabot[bot] in https://github.com/laughingman7743/PyAthena/pull/656
Bump requests from 2.32.3 to 2.32.4 by @dependabot[bot] in https://github.com/laughingman7743/PyAthena/pull/655
Bump setuptools from 75.6.0 to 78.1.1 by @dependabot[bot] in https://github.com/laughingman7743/PyAthena/pull/653
Bump jinja2 from 3.1.5 to 3.1.6 by @dependabot[bot] in https://github.com/laughingman7743/PyAthena/pull/654
Convert documentation from RST to Markdown by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/657
Add header banner image to documentation by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/658

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.26.0...v3.27.0

Open source →

3.26.031 Jan 2026

Return DOUBLE type for double columns in SQLAlchemy 2.0+ by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/648

What's Changed

Return DOUBLE type for double columns in SQLAlchemy 2.0+ by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/648

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.25.0...v3.26.0

Open source →

3.25.016 Jan 2026

Pass WorkGroup parameter to GetTableMetadata and ListTableMetadata APIs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/646

What's Changed

Pass WorkGroup parameter to GetTableMetadata and ListTableMetadata APIs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/646

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.24.1...v3.25.0

Open source →

3.24.16 Jan 2026

Unify _to_date converter and add git workflow guidelines by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/641

What's Changed

Unify _to_date converter and add git workflow guidelines by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/641
Implement Iterator protocol and resource management for CSV readers by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/642
Add NULL and empty string handling documentation by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/643

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.24.0...v3.24.1

Open source →

3.24.04 Jan 2026

Fix docs deployment from tag triggers by using workflow_dispatch by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/633

What's Changed

Fix docs deployment from tag triggers by using workflow_dispatch by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/633
Add S3FSCursor and AsyncS3FSCursor to cursor documentation page by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/634
Fix documentation consistency and add missing S3FS references by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/635
Add PolarsCursor for native Polars DataFrame support by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/636
Add chunk processing support for PolarsCursor by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/637
Align PandasCursor with PolarsCursor and optimize DataFrame operations by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/639

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.23.0...v3.24.0

Open source →

3.23.01 Jan 2026

Fix docs version detection for master branch builds by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/631

What's Changed

Fix docs version detection for master branch builds by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/631
Add S3FS Cursor for lightweight CSV-based result reading by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/630
Add comprehensive docstrings and expand API documentation by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/632

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.22.0...v3.23.0

Open source →

3.22.017 Nov 2025

Fix: Nested struct parsing fails to preserve nested fields (Issue #627) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/628

What's Changed

Fix: Nested struct parsing fails to preserve nested fields (Issue #627) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/628

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.21.1...v3.22.0

Open source →

3.21.113 Nov 2025

trailing slash check for s3_staging_dir by @CAinDE in https://github.com/laughingman7743/PyAthena/pull/626

What's Changed

trailing slash check for s3_staging_dir by @CAinDE in https://github.com/laughingman7743/PyAthena/pull/626

New Contributors

@CAinDE made their first contribution in https://github.com/laughingman7743/PyAthena/pull/626

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.21.0...v3.21.1

Open source →

3.21.09 Nov 2025

Drop Python 3.9 support after EOL by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/622

What's Changed

Drop Python 3.9 support after EOL by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/622
Remove fastparquet support by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/624
Add Python 3.14 support by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/625

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.20.0...v3.21.0

Open source →

3.20.08 Nov 2025

docs: Implement version selector with sphinx-multiversion by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/613

What's Changed

docs: Implement version selector with sphinx-multiversion by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/613
fix: Correct version selector to show current version as selected by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/614
fix: Fix version detection in sphinx-multiversion documentation builds by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/618
Add JSON type support for SQLAlchemy dialect by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/620

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.19.0...v3.20.0

Open source →

3.19.018 Oct 2025

docs: Change Sphinx theme from Alabaster to Furo by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/606

What's Changed

docs: Change Sphinx theme from Alabaster to Furo by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/606
Add S3 timeout parameters to ArrowCursor for role assumption support by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/610
Fix documentation version display by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/611

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.18.0...v3.19.0

Open source →

3.18.07 Sept 2025

Introduce hatch-vcs for automatic version management by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/600

What's Changed

Introduce hatch-vcs for automatic version management by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/600
Add comprehensive docstrings to PyAthena public API by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/601
Fix: Reserved words are not quoted correctly by @izzudinhafiz in https://github.com/laughingman7743/PyAthena/pull/603
'NoneType' object has no attribute 'get' can happen on AWS retries by @chollinger93 in https://github.com/laughingman7743/PyAthena/pull/604
Fix: Correct engine fixture usage in test_reserved_words by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/605

New Contributors

@izzudinhafiz made their first contribution in https://github.com/laughingman7743/PyAthena/pull/603
@chollinger93 made their first contribution in https://github.com/laughingman7743/PyAthena/pull/604

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.17.1...v3.18.0

Open source →

3.17.116 Aug 2025

Fix dynamic imports in SQLAlchemy dialect components by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/599

What's Changed

Fix dynamic imports in SQLAlchemy dialect components by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/599

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.17.0...v3.17.1

Open source →

3.17.09 Aug 2025

Add Athena filter() function support to SQLAlchemy dialect by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/592

What's Changed

Add Athena filter() function support to SQLAlchemy dialect by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/592
Fix MetaData schema specification in SQLAlchemy tests by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/593
Improve large dataset handling and CSV engine selection by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/594
Add early query ID access via callback mechanism by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/596
Fix ArrowCursor dynamic credentials support for pyarrow S3FileSystem by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/597
feat: enhance PandasCursor with memory optimization and chunked processing by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/598

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.16.0...v3.17.0

Open source →

3.16.03 Aug 2025

feat: implement STRUCT type support for PyAthena SQLAlchemy dialect by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/587

What's Changed

feat: implement STRUCT type support for PyAthena SQLAlchemy dialect by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/587
Add comprehensive MAP type support for SQLAlchemy ORM by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/589
Add ARRAY type support by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/590
Add DDL compilation tests for ARRAY, MAP, and STRUCT types by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/591

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.15.0...v3.16.0

Open source →

3.15.019 Jul 2025

Add CLAUDE.md development guide for AI assistants by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/586

What's Changed

Add CLAUDE.md development guide for AI assistants by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/586
feat: implement maxdepth and withdirs options for S3FileSystem.find() by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/544

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.14.1...v3.15.0

Open source →

3.14.125 May 2025

Fix incompatible dtype conversions in dataframe. (fix #523) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/585

What's Changed

Fix incompatible dtype conversions in dataframe. (fix #523) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/585

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.14.0...v3.14.1

Open source →

3.14.018 May 2025

Add the import_dbapi method to classes that inherit AthenaDialect to suppress SQLAlchemy WARNING messages. (fix #582) by @laughingman7743 in https://g

What's Changed

Add the import_dbapi method to classes that inherit AthenaDialect to suppress SQLAlchemy WARNING messages. (fix #582) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/584

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.13.0...v3.14.0

Open source →

3.13.024 Apr 2025

Comment out some test cases because of the high cost of AWS for testing by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/571

What's Changed

Comment out some test cases because of the high cost of AWS for testing by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/571
Migrate package manager to uv (fix #558) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/568
Add more lint items by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/572
Pin the version of uv and tox by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/573
Add support customer table type by @nsanta in https://github.com/laughingman7743/PyAthena/pull/580

New Contributors

@nsanta made their first contribution in https://github.com/laughingman7743/PyAthena/pull/580

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.12.2...v3.13.0

Open source →

3.12.228 Dec 2024

Fix type hints by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/570

What's Changed

Fix type hints by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/570

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.12.1...v3.12.2

Open source →

3.12.128 Dec 2024

Fix F821 Undefined name List and Union by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/569

What's Changed

Fix F821 Undefined name List and Union by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/569

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.12.0...v3.12.1

Open source →

3.12.026 Dec 2024

Support Athena parameterized queries when paramstyle is qmark (fix #545) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/557

What's Changed

Support Athena parameterized queries when paramstyle is qmark (fix #545) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/557

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.11.0...v3.12.0

Open source →

3.11.07 Dec 2024

Drop support for Python 3.8 (fix #561) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/565

What's Changed

Drop support for Python 3.8 (fix #561) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/565
Support for Python 3.13 (fix #560) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/566

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.10.0...v3.11.0

Open source →

3.10.04 Dec 2024

Fix to pass kwarg in the call to the execute method in the executemany method by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/

What's Changed

Fix to pass kwarg in the call to the execute method in the executemany method by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/555
Fix to set result_reuse_enable and result_reuse_minutes in AsyncPandasCursor by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/556
Escape schema and table names in drop statements (fix #562) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/563

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.9.0...v3.10.0

Open source →

3.9.06 Aug 2024

Bump urllib3 from 1.26.18 to 1.26.19 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/549

What's Changed

Bump urllib3 from 1.26.18 to 1.26.19 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/549
Bump certifi from 2024.2.2 to 2024.7.4 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/550
Bump zipp from 3.17.0 to 3.19.1 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/551
Add default converter for timestamp with timezone by @gontzalm in https://github.com/laughingman7743/PyAthena/pull/554

New Contributors

@gontzalm made their first contribution in https://github.com/laughingman7743/PyAthena/pull/554

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.8.3...v3.9.0

Open source →

3.8.326 May 2024

Bump jinja2 from 3.1.3 to 3.1.4 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/542

What's Changed

Bump jinja2 from 3.1.3 to 3.1.4 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/542
Bump requests from 2.31.0 to 2.32.0 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/546
Adjusted size of the last part of a multipart request (fix #547) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/548

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.8.2...v3.8.3

Open source →

3.8.26 May 2024

⚠️ This version may cause EntityTooSmall errors with multipart uploads. This will be fixed in the next version. ⚠️

What's Changed

Implement all fsspec specs in the s3 file system by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/540

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.8.1...v3.8.2

Open source →

3.8.15 May 2024

Support for appending to files larger than 5GB by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/541

What's Changed

Support for appending to files larger than 5GB by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/541

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.8.0...v3.8.1

Open source →

3.8.02 May 2024

⚠️ This version is not able to append to files larger than 5GB. This will be improved in the next version. ⚠️

What's Changed

Support for writing with s3 file system by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/539

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.7.0...v3.8.0

Open source →

3.7.023 Apr 2024

Add support for UPDATE and MERGE operation in formatter by @Oskar-Bonde in https://github.com/laughingman7743/PyAthena/pull/536

What's Changed

Add support for UPDATE and MERGE operation in formatter by @Oskar-Bonde in https://github.com/laughingman7743/PyAthena/pull/536
Bump idna from 3.6 to 3.7 in /requirements by @dependabot in https://github.com/laughingman7743/PyAthena/pull/533

New Contributors

@Oskar-Bonde made their first contribution in https://github.com/laughingman7743/PyAthena/pull/536

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.6.0...v3.7.0

Open source →

3.6.03 Apr 2024

Update README by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/530

What's Changed

Update README by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/530
a possible stopgap solution to issue #531 by @AJM10565 in https://github.com/laughingman7743/PyAthena/pull/532

New Contributors

@AJM10565 made their first contribution in https://github.com/laughingman7743/PyAthena/pull/532

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.5.1...v3.6.0

Open source →

3.5.118 Mar 2024

Fix future warnings by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/524

What's Changed

Fix future warnings by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/524
Fix version and release for docs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/525
Fix AttributeError: module 'sqlalchemy.types' has no attribute 'DOUBLE' (fix #526) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/527

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.5.0...v3.5.1

Open source →

3.5.017 Mar 2024Deprecated

Fix deprecation warnings by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/522

What's Changed

Add docs (fix #501) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/519
Fix future warnings by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/521
Fix deprecation warnings by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/522
Issue 517: Concept for Timetravel/Temporal Queries by @jasonamyers in https://github.com/laughingman7743/PyAthena/pull/518

New Contributors

@jasonamyers made their first contribution in https://github.com/laughingman7743/PyAthena/pull/518

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.4.0...v3.5.0

Open source →

3.4.118 Mar 2024

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.5.1...v3.4.1

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.5.1...v3.4.1

Open source →

3.4.015 Mar 2024

Fixed incorrect rendering of numeric type variants in SQLAlchemy's DDL (fix #515) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/p

What's Changed

Fixed incorrect rendering of numeric type variants in SQLAlchemy's DDL (fix #515) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/516

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.3.0...v3.4.0

Open source →

3.3.011 Feb 2024

Migrate package manager from pdm to hatch by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/513

What's Changed

Migrate package manager from pdm to hatch by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/513
Support for Python 3.12 (fix #482) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/514

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.2.1...v3.3.0

Open source →

3.2.13 Feb 2024

Revert missing cursor default arguments. (fix #506) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/508

What's Changed

Revert missing cursor default arguments. (fix #506) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/508
Fix PytestUnknownMarkWarning: Unknown pytest.mark.depends by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/509
Fix tool.pdm.package-type to distribution by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/510
Update github actions by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/511

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.2.0...v3.2.1

Open source →

3.2.026 Jan 2024

Bump jinja2 from 3.1.2 to 3.1.3 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/500

What's Changed

Bump jinja2 from 3.1.2 to 3.1.3 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/500
Fix property name for AthenaSessionStatus by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/502
Migrate package manager from poetry to pdm by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/503
Enhances Cursor type inference capabilities by @woosuk-choi-g in https://github.com/laughingman7743/PyAthena/pull/504

New Contributors

@woosuk-choi-g made their first contribution in https://github.com/laughingman7743/PyAthena/pull/504

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.1.0...v3.2.0

Open source →

3.1.13 Feb 2024

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.1.0...v3.1.1

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.1.0...v3.1.1

Open source →

Your coding agent can read these notes before it upgrades. Set up the MCP server →

pyathena

Release timeline

Releases

SQLAlchemy

Cursors

Development

What's Changed

New Contributors

What's Changed

New Contributors

What's Changed

What's Changed

New Contributors

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

Bug Fixes

Internal

Affected Versions

Workaround for older versions

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors

What's Changed

New Contributors

What's Changed

What's Changed

New Contributors

What's Changed

What's Changed

What's Changed

What's Changed

New Contributors