PyPI · #949 most downloaded on PyPI

pyathena

3.37.022M 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 4 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.1.09 Jan 2024
Bump pyarrow from 13.0.0 to 14.0.1 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/491
What's Changed

Bump pyarrow from 13.0.0 to 14.0.1 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/491

Bump cryptography from 41.0.5 to 41.0.6 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/494

Remove python2 syntax by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/498

Implement SparkCursor to support Spark calculations (fix #493) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/497

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.10...v3.1.0
Open source →
3.0.1029 Oct 2023
Bump urllib3 from 1.26.17 to 1.26.18 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/481
What's Changed

Bump urllib3 from 1.26.17 to 1.26.18 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/481

Support json_serializer and json_deserializer engine/dialect paremeters by @edgarrmondragon in https://github.com/laughingman7743/PyAthena/pull/486

Update GitHub Actions & Remove secrets by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/487

Update poetry.lock by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/489

New Contributors

@edgarrmondragon made their first contribution in https://github.com/laughingman7743/PyAthena/pull/486

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.9...v3.0.10

One column per quarter.

3.0.911 Oct 2023

Bump cryptography from 41.0.3 to 41.0.4 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/474

What's Changed

Bump cryptography from 41.0.3 to 41.0.4 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/474
Bump urllib3 from 1.26.16 to 1.26.17 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/475
fix(reuse): :bug: convert reuse parameters to the expected data type by @CandiedCode in https://github.com/laughingman7743/PyAthena/pull/478

New Contributors

@CandiedCode made their first contribution in https://github.com/laughingman7743/PyAthena/pull/478

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.8...v3.0.9

Open source →

3.0.821 Sept 2023

Fix SyntaxError in SQLAlchemy 1.x (fix #472) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/473

What's Changed

Fix SyntaxError in SQLAlchemy 1.x (fix #472) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/473

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.7...v3.0.8

Open source →

3.0.712 Sept 2023

Update poetry.lock by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/470

What's Changed

Update poetry.lock by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/470
Fix exceptions alias by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/471
implement get_view_definition() for AthenaDialect by @bossenti in https://github.com/laughingman7743/PyAthena/pull/468

New Contributors

@bossenti made their first contribution in https://github.com/laughingman7743/PyAthena/pull/468

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.6...v3.0.7

Open source →

3.0.616 Jul 2023

Porting the distutils.util.strtobool method (fix #463) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/464

What's Changed

Porting the distutils.util.strtobool method (fix #463) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/464

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.5...v3.0.6

Open source →

3.0.512 Jul 2023

Sqlalchemy iceberg partition by @dominik-reiner in https://github.com/laughingman7743/PyAthena/pull/461

What's Changed

Sqlalchemy iceberg partition by @dominik-reiner in https://github.com/laughingman7743/PyAthena/pull/461

New Contributors

@dominik-reiner made their first contribution in https://github.com/laughingman7743/PyAthena/pull/461

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.4...v3.0.5

Open source →

3.0.429 Jun 2023

adding back dbapi module for backward compatibility with sqlalchemy 1.4.x by @mdeshmu in https://github.com/laughingman7743/PyAthena/pull/448

What's Changed

adding back dbapi module for backward compatibility with sqlalchemy 1.4.x by @mdeshmu in https://github.com/laughingman7743/PyAthena/pull/448
Bump cryptography from 40.0.2 to 41.0.0 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/449
Update github actions by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/453
Update ThumbprintList by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/455
adding back dbapi module for backward compatibility with sqlalchemy 1.4.x by @mdeshmu in https://github.com/laughingman7743/PyAthena/pull/457

New Contributors

@mdeshmu made their first contribution in https://github.com/laughingman7743/PyAthena/pull/448

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.3...v3.0.4

Open source →

3.0.329 May 2023

Delay type annotation eval for compatibility with SQLAlchemy 1.4 by @xuganyu96 in https://github.com/laughingman7743/PyAthena/pull/446

What's Changed

Delay type annotation eval for compatibility with SQLAlchemy 1.4 by @xuganyu96 in https://github.com/laughingman7743/PyAthena/pull/446

New Contributors

@xuganyu96 made their first contribution in https://github.com/laughingman7743/PyAthena/pull/446

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.2...v3.0.3

Open source →

3.0.217 May 2023

Support rowcount field for Cursor Objects by @t-yuki in https://github.com/laughingman7743/PyAthena/pull/443

What's Changed

Support rowcount field for Cursor Objects by @t-yuki in https://github.com/laughingman7743/PyAthena/pull/443

New Contributors

@t-yuki made their first contribution in https://github.com/laughingman7743/PyAthena/pull/443

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.1...v3.0.2

Open source →

3.0.114 May 2023

Change to not retrieve query results for UPDATE, DELETE, MERGE, and VACUUM statements (fix #441) by @laughingman7743 in https://github.com/laughingman

What's Changed

Change to not retrieve query results for UPDATE, DELETE, MERGE, and VACUUM statements (fix #441) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/442

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v3.0.0...v3.0.1

Open source →

3.0.04 May 2023

Replace session scope fixtures with pytest_sessionstart and pytest_sessionfinish methods by @laughingman7743 in https://github.com/laughingman7743/PyA

What's Changed

Replace session scope fixtures with pytest_sessionstart and pytest_sessionfinish methods by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/438
Support for SQLAlchemy 2.0 (fix #415) & Redesign SQLAlchemy dialect layout (fix #329) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/420
Drop support for Python 3.7 (fix #435) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/439
Fix test directory structure by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/440

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.25.2...v3.0.0

Open source →

2.25.223 Apr 2023

Fix anonymous connection on s3fs to not set credentials by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/433

What's Changed

Fix anonymous connection on s3fs to not set credentials by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/433
Support for requester payments with s3fs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/434

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.25.1...v2.25.2

Open source →

2.25.122 Apr 2023

Fix to be more compatible with s3fs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/432

What's Changed

Fix to be more compatible with s3fs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/432

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.25.0...v2.25.1

Open source →

2.25.022 Apr 2023Deprecated

Fix FutureWarning: The argument 'use_nullable_dtypes' is deprecated a… by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/429

What's Changed

Fix constructor arguments for DDLCompiler by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/423
Changed type of reserved words in SQLAlchemy from list to set by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/424
Fixed error handling to avoid using SQLAlchemy utility methods by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/425
Fix SQLAlchemy tests to allow upgrading to SQLAlchemy 2.0 by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/427
Fix test cases to support Athena engine version 3 by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/428
Fix FutureWarning: The argument 'use_nullable_dtypes' is deprecated a… by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/429
Fix FutureWarning: The argument 'infer_datetime_format' is deprecated… by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/430
Fix constructor of S3FileSystem class to maintain compatibility with s3fs (fix #418) by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/431

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.24.0...v2.25.0

Open source →

2.24.223 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.24.1...v2.24.2

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.24.1...v2.24.2

Open source →

2.24.122 Apr 2023

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

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

Open source →

2.24.09 Apr 2023

Bump markdown-it-py from 2.1.0 to 2.2.0 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/412

What's Changed

Bump markdown-it-py from 2.1.0 to 2.2.0 by @dependabot in https://github.com/laughingman7743/PyAthena/pull/412
Add clobber=True when registering s3 impls by @gallushi in https://github.com/laughingman7743/PyAthena/pull/421
Update dependency libs by @laughingman7743 in https://github.com/laughingman7743/PyAthena/pull/422

New Contributors

@gallushi made their first contribution in https://github.com/laughingman7743/PyAthena/pull/421

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

Open source →

2.23.223 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.23.1...v2.23.2

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.23.1...v2.23.2

Open source →

2.23.122 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.23.0...v2.23.1

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.23.0...v2.23.1

Open source →

2.23.014 Feb 2023

Add EXTERNAL table type supported by Athena federation to the filter #410 Thanks @mai-nguyen-coinhako

Add EXTERNAL table type supported by Athena federation to the filter #410 Thanks @mai-nguyen-coinhako

Open source →

2.22.223 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.22.1...v2.22.2

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.22.1...v2.22.2

Open source →

2.22.122 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.22.0...v2.22.1

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.22.0...v2.22.1

Open source →

2.22.09 Feb 2023

Fix iteration of ranges with offset 1 #405 Thanks @matthiashuschle #404

Fix iteration of ranges with offset 1 #405 Thanks @matthiashuschle #404

Open source →

2.21.323 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.21.2...v2.21.3

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.21.2...v2.21.3

Open source →

2.21.222 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.21.1...v2.21.2

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.21.1...v2.21.2

Open source →

2.21.19 Feb 2023

Fix iteration of ranges with offset 1 #405

Backport:

Fix iteration of ranges with offset 1 #405

Open source →

2.21.04 Feb 2023

Removing filter that required tables to be explicitly external #403 Thanks @bradleyhurley #402

Removing filter that required tables to be explicitly external #403 Thanks @bradleyhurley #402

Open source →

2.20.323 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.20.2...v2.20.3

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.20.2...v2.20.3

Open source →

2.20.222 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.20.1...v2.20.2

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.20.1...v2.20.2

Open source →

2.20.19 Feb 2023

Fix iteration of ranges with offset 1 #405

Backport:

Fix iteration of ranges with offset 1 #405

Open source →

2.20.027 Jan 2023

Reduce byte range by 1 to meet fsspec expectation #400 Thanks @matthiashuschle #399

Reduce byte range by 1 to meet fsspec expectation #400 Thanks @matthiashuschle #399

Open source →

2.19.423 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.19.3...v2.19.4

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.19.3...v2.19.4

Open source →

2.19.322 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.19.2...v2.19.3

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.19.2...v2.19.3

Open source →

2.19.29 Feb 2023

Fix iteration of ranges with offset 1 #405

Backport:

Fix iteration of ranges with offset 1 #405

Open source →

2.19.128 Jan 2023

Reduce byte range by 1 to meet fsspec expectation #400

Backport:

Reduce byte range by 1 to meet fsspec expectation #400

Open source →

2.19.030 Dec 2022

* Support for Python 3.11 #397

Support for Python 3.11 #397

Open source →

2.18.623 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.18.5...v2.18.6

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.18.5...v2.18.6

Open source →

2.18.522 Apr 2023

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.18.4...v2.18.5

Full Changelog: https://github.com/laughingman7743/PyAthena/compare/v2.18.4...v2.18.5

Open source →

2.18.49 Feb 2023

Fix iteration of ranges with offset 1 #405

Backport:

Fix iteration of ranges with offset 1 #405

Open source →

2.18.328 Jan 2023

Reduce byte range by 1 to meet fsspec expectation #400

Backport:

Reduce byte range by 1 to meet fsspec expectation #400

Open source →

2.18.230 Dec 2022

Fixed to not add redundant values to user_agent_extra #396 Thanks @fbrueck #395

Fixed to not add redundant values to user_agent_extra #396 Thanks @fbrueck #395

Open source →

2.18.118 Dec 2022

Fix issue when installing version 2.18.0 #393 Thanks @Benm-Qwak

Fix issue when installing version 2.18.0 #393 Thanks @Benm-Qwak

Open source →

2.18.018 Dec 2022

Implement s3 filesystem #370 s3fs and aiobotocore have been removed from the dependencies.

Implement s3 filesystem #370 s3fs and aiobotocore have been removed from the dependencies.
Support for using Query Result Reuse #392 https://github.com/laughingman7743/PyAthena#result-reuse-configuration Thanks @mjfuInrix #390

Open source →

2.17.02 Dec 2022

Support for CTE follows insert in SQLAlchemy #383 #384 Thanks @jasonamyers #380

Support for CTE follows insert in SQLAlchemy #383 #384 Thanks @jasonamyers #380

Open source →

2.16.130 Nov 2022

Fix Attribute error in AssumeRole #386 Thanks @maicon-berndt #385

Fix Attribute error in AssumeRole #386 Thanks @maicon-berndt #385

Open source →

2.16.026 Nov 2022

Add user_agent_extra parameter to boto3 configuration. #383 Thanks @armaseg

Add user_agent_extra parameter to boto3 configuration. #383 Thanks @armaseg

Open source →

2.15.017 Nov 2022

Remove synchronized decorator #376 Thanks @mateush @sbrandtb #68

Remove synchronized decorator #376 Thanks @mateush @sbrandtb #68

Open source →

2.14.015 Aug 2022

Fix reserved words in SQLAlchemy #357

Fix reserved words in SQLAlchemy #357
Change string formatting to use f-string #358
Fix cast as binary type #362 Thanks @takacsd #361
Change schema names retrieval in SQLAlchemy from information schema to API #363
Add missing fields to AthenaQueryExecution model #365

Open source →

2.13.031 Jul 2022

Support for reading in chunks with PandasCursor #349 https://github.com/laughingman7743/PyAthena#pandascursor-chunksize-options

Support for reading in chunks with PandasCursor #349 https://github.com/laughingman7743/PyAthena#pandascursor-chunksize-options
Add engine and chunksize to PandasCursor args #349
Add unload, engine and chunksize to PndasCursor connection string in SQLAlchemy #349
Fix ArrowCursor connection options in SQLAlchemy #349

Open source →

2.12.028 Jul 2022

Fix install requires #355 Thanks @JayFields #354

Fix install requires #355 Thanks @JayFields #354

Open source →

2.11.026 Jul 2022

Change connection options to be retrieved from the dialect class instead of the bind parameter #352 The following error in the Dataframe.to_sql method

Change connection options to be retrieved from the dialect class instead of the bind parameter #352 The following error in the Dataframe.to_sql method of Pandas 1.4 has been fixed.
```
sqlalchemy.exc.CompileError: The location of the table should be specified by the dialect keyword argument `awsathena_location`
```
Suppress log output when failure to retrieve metadata from SQLAlchemy #353 Thanks @plazmakeks #326
Update botocore and boto3 dependencies #350 Thanks @aaronclong #341

Open source →

2.10.017 Jul 2022

Change the Parquet library used by Pandas to allow choice of PyArrow or fastparquet #343 The PyArrow dependency is no longer required in the extra pac

Change the Parquet library used by Pandas to allow choice of PyArrow or fastparquet #343 The PyArrow dependency is no longer required in the extra package Pandas. If you use the unload option, you must install the extra package with PyAthena[Arrow] or PyAthena[fastparquet]. Thanks @aaronclong #341
Change the default value of na_values in AsyncPandasCursor from None to empty character #347 Thanks @dblado #346
Support for specifying ExternalId in AssumeRole #348 Thanks @dblado #344

Open source →

2.9.69 Jul 2022

Update s3fs dependencies #342 Thanks @nikhil27472 #340

Update s3fs dependencies #342 Thanks @nikhil27472 #340

Open source →

2.9.524 Jun 2022

Update botocore and boto3 dependencies #337 Thanks @zachliu #336

Update botocore and boto3 dependencies #337 Thanks @zachliu #336

Open source →

2.9.421 Jun 2022

Fix rendering of LIMIT / OFFSET clauses in SQLAlchemy to work with version 1.3 and lower #335 Thanks @mdeshmu #334

Fix rendering of LIMIT / OFFSET clauses in SQLAlchemy to work with version 1.3 and lower #335 Thanks @mdeshmu #334

Open source →

2.9.311 Jun 2022

Support credentials with profile names in ArrowCursor and PandasCursor #332

Support credentials with profile names in ArrowCursor and PandasCursor #332
Add region name to boto3 session #333

Open source →

2.9.210 Jun 2022

Add region_name to the argument passed to storage_options in Pandas #331

Add region_name to the argument passed to storage_options in Pandas #331

Open source →

2.9.16 Jun 2022

Fix keyword arguments passed to storage_options in Pandas #328 Thanks @shumingpeh #327

Fix keyword arguments passed to storage_options in Pandas #328 Thanks @shumingpeh #327

Open source →

2.9.04 Jun 2022

Support for the UNLOAD option in PandasCursor/AsyncPandasCursor #325 https://github.com/laughingman7743/PyAthena#pandascursor-unload-options Thanks @a

Support for the UNLOAD option in PandasCursor/AsyncPandasCursor #325 https://github.com/laughingman7743/PyAthena#pandascursor-unload-options Thanks @annisall @ztane @DyfanJones #242

Open source →

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