PyAthena
PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
MIT License
Bot releases are visible (Hide)
Published by github-actions[bot] almost 2 years ago
- Fix Attribute error in AssumeRole #386
Thanks @maicon-berndt #385
Published by github-actions[bot] almost 2 years ago
- Add user_agent_extra parameter to boto3 configuration. #383
Thanks @armaseg
Published by github-actions[bot] almost 2 years ago
- Remove synchronized decorator #376
Thanks @mateush @sbrandtb #68
Published by github-actions[bot] about 2 years ago
- 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
Published by github-actions[bot] about 2 years ago
- 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
Published by github-actions[bot] over 2 years ago
- Fix install requires #355
Thanks @JayFields #354
Published by github-actions[bot] over 2 years ago
- 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
Published by github-actions[bot] over 2 years ago
- 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 withPyAthena[Arrow]orPyAthena[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
Published by laughingman7743 over 2 years ago
- Update s3fs dependencies #342
Thanks @nikhil27472 #340
Published by github-actions[bot] over 2 years ago
- Update botocore and boto3 dependencies #337
Thanks @zachliu #336
Published by github-actions[bot] over 2 years ago
- Fix rendering of LIMIT / OFFSET clauses in SQLAlchemy to work with version 1.3 and lower #335
Thanks @mdeshmu #334
Published by github-actions[bot] over 2 years ago
- Support credentials with profile names in ArrowCursor and PandasCursor #332
- Add region name to boto3 session #333
Published by github-actions[bot] over 2 years ago
- Add region_name to the argument passed to storage_options in Pandas #331
Published by github-actions[bot] over 2 years ago
- Fix keyword arguments passed to storage_options in Pandas #328
Thanks @shumingpeh #327
Published by github-actions[bot] over 2 years ago
- Support for the UNLOAD option in PandasCursor/AsyncPandasCursor #325
https://github.com/laughingman7743/PyAthena#pandascursor-unload-options
Thanks @annisall @ztane @DyfanJones #242
Published by github-actions[bot] over 2 years ago
- Support for statement cache in SQLAlchemy #323
Published by github-actions[bot] over 2 years ago
- Fix type hints, default values and order of cursor class constructor arguments #312
- Add cursor_kwargs to connection class arguments to allow passing cursor arguments #313
- Move DefaultPandasTypeConverter to pandas package #314
- Fix deprecation warning in re.compile #316
Thanks @sadikkuzu #315 - Rename meta_data to metadata #317
- Fix type hints #318
- Fix type hints in return value of description
- Fix type hints in return value of asynchronous cursor's execute method
- Set default values for default conversion methods in converter
- Add missing type hints
- Add static method to cursor class to get default converter #319
- Implement ArrowCursor/AsyncArrowCursor #321
- https://github.com/laughingman7743/PyAthena#arrowcursor
- https://github.com/laughingman7743/PyAthena#asyncarrowcursor
- https://github.com/laughingman7743/PyAthena#dialect--driver
- ArrowCursor/AsyncArrowCursor supports the UNLOAD option.
https://github.com/laughingman7743/PyAthena#unload-options
Published by github-actions[bot] over 2 years ago
- Add
clusterandbucket_countto dialect options in SQLAlchemy #310
Support for bucketing in SQLAlchemy table creation. - Support for specifying column options from connection strings #311
https://github.com/laughingman7743/PyAthena#column-options
Published by github-actions[bot] over 2 years ago
- Add
row_format,file_format,serdepropertiesandtblpropertiesto dialect options in SQLAlchemy #306- Support for creating tables in various file and row formats in SQLAlchemy.
https://github.com/laughingman7743/PyAthena#dialect-options - Support for creating tables in various file and row formats is also available in the pandas.DataFrame.to_sql.
https://github.com/laughingman7743/PyAthena#to-sql - The
s3_diroption in the connection string has been removed and is now specified in thelocationof the dialect option. - Remove
AthenaRowFormatmodel class. - Add
AthenaFileFormatandAthenaRowFormatSerdemodel classes
- Support for creating tables in various file and row formats in SQLAlchemy.
Published by github-actions[bot] over 2 years ago
- Fix escape handling for insert statements containing single quotes #304
Thanks @bertop89 #238 - Support for partition columns in SQLAlchemy #305