PyAthena

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

MIT License

Downloads
11.4M
Stars
459
Committers
23
View Code on GitHub
Ecosystems: Amazon Web Services, Python

Bot releases are hidden (Show)

PyAthena - v1.10.5

Published by laughingman7743 over 4 years ago

  • Fix invalid requests when only workgroups are specified.
    Thanks @kanga333. (laughingman7743/PyAthena/issues/136)
  • Support partitioning with to_sql method in utility package.
PyAthena - v1.10.4

Published by laughingman7743 over 4 years ago

  • Support China region endpoints.
    Thanks @liangruibupt. (laughingman7743/PyAthena/issues/134)
PyAthena - v1.10.3

Published by laughingman7743 over 4 years ago

  • Fix work_group condition when referencing query cache.
    Thanks @Jason-Crowe. (laughingman7743/PyAthena/issues/130)
  • Changed date and datetime type conversion in query parameter format to use literal values in all cases.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/126)
PyAthena - v1.10.2

Published by laughingman7743 over 4 years ago

  • Fix parameter format of Decimal type.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/121)
PyAthena - v1.10.1

Published by laughingman7743 over 4 years ago

  • Fix PandasCursor to not ignore rows containing only null values.
    Thanks @EdwardJRoss. (laughingman7743/PyAthena/issues/117)
  • Support utility queries in PandaCursor
    Thanks @radcheb. (laughingman7743/PyAthena/issues/114)
  • Implement to_sql method in utility package.
PyAthena - v1.10.0

Published by laughingman7743 almost 5 years ago

  • Support pandas.to_sql.
    See README for details.
    Thanks @kismsu, @DyfanJones. (laughingman7743/PyAthena/issues/101, laughingman7743/PyAthena/pull/110)
  • Support executemany method with Cursor and PandasCursor.
PyAthena - v1.9.0

Published by laughingman7743 almost 5 years ago

  • Redesign Formatter and Converter classes.
    You can now customize dtypes and converters for the Dataframe object.
    See README for details.
  • Support Bool column NA value in PandasCursor.
    Thanks @tanguycdls, @mzhang13. (laughingman7743/PyAthena/issues/100, laughingman7743/PyAthena/issues/102, laughingman7743/PyAthena/pull/103)
  • Change s3_staging_dir argument to optional.
    Thanks @nitin-kakkar. (laughingman7743/PyAthena/issues/99)
PyAthena -

Published by laughingman7743 about 5 years ago

  • Implement query result caching.
    See README for details.

    You can attempt to re-use the results from a previously run query to help save time and money in the cases where your underlying data isn't changing.
    Set the cache_size parameter of cursor.execute() to a number larger than 0 to enable cacheing. (Cacheing is turned off by default.)

    Thanks @kbrose. (laughingman7743/PyAthena/pull/96)

PyAthena -

Published by laughingman7743 about 5 years ago

  • Check that column_default is not nan.
    Thanks @capitancambio. (laughingman7743/PyAthena/pull/94)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support SQLAlchemy 1.3.0.
  • Exclude tests from dist package.
    Thanks @gaqzi. (laughingman7743/PyAthena/pull/86)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Implement AsyncPandasCursor.
    Thanks @JivanRoquet. (/issues/81)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Fix Pandas to lazy import.
    Thanks @sroussi. (laughingman7743/PyAthena/issues/82)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support integer NA values in PnadasCursor.
    Restrict the allowable version of Pandas(>=0.24.0).
    Thanks @austinlostinboston, @mckeown12 and @xinluo-gogovan. (laughingman7743/PyAthena/issues/60)
  • Drop Python 3.4 support.
    It will work with Python 3.4 unless you use PandasCusrsor.
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support Python 3.7.
PyAthena -

Published by laughingman7743 over 5 years ago

  • Allow s3_staging_dir to be overridden in query execution.
    Thanks @aidin36. (laughingman7743/PyAthena/issues/53)
  • Support work_group parameter in query execution.
    Thanks @sharath-thirunagaru. (laughingman7743/PyAthena/issues/69)
  • Fix cursor constructor argument to be overridden by cursor method kwargs.
  • Aggregate retry settings into RetryConfig object.
  • Restrict the allowable version of SQLAlchemy(>=1.0.0, <1.3.0).
PyAthena -

Published by laughingman7743 over 5 years ago

  • Support botocore config argument.
    Thanks @m-for-madness. (laughingman7743/PyAthena/issues/64)
PyAthena -

Published by laughingman7743 over 5 years ago

  • Fix AttributeError: 'Engine' object has no attribute 'connection'.
    Thanks @mrshu. (laughingman7743/PyAthena/issues/63)
PyAthena -

Published by laughingman7743 almost 6 years ago

  • Allow empty results from PandasCursor.
    Thanks @jkleint. (laughingman7743/PyAthena/pull/58)
PyAthena -

Published by laughingman7743 almost 6 years ago

  • Fix to make it None when SQLAlchemy's URI username and password are empty strings.
    If you do not specify aws_access_key_id and aws_secret_access_key in SQLAlchemy using the instance profile or boto3 configuration file, the connection string is as follows: 
    awsathena+rest://:@athena.{region_name}.amazonaws.com:443/{schema_name}?s3_staging_dir={s3_staging_dir}&...
    Thanks @leahein. (laughingman7743/PyAthena/issues/54)
  • Fix double escaping of percent character in SQLAlchemy.
    Thanks @mister-average. (laughingman7743/PyAthena/issues/56)
PyAthena -

Published by laughingman7743 about 6 years ago

  • Fix condition of has_table method in SQLAlchemy.
Package Rankings
Top 1.64% on Pypi.org
Top 24.98% on Conda-forge.org
Related Projects
py-data-api

A user-friendly client for AWS Aurora Serverless's Data API

03 Jun 2019 40
aws-sdk-pandas

pandas on AWS - Easy integration with Athena, Glue, Redshift, Timestream, Neptune, OpenSearch, Qu...

26 Feb 2019 3,791