snowflake-sqlalchemy 1.1.0

Snowflake SQLAlchemy Dialect

This package includes the Snowflake SQLAlchemy, which supports Snowsql dialects for SQLAlchemy http://www.sqlalchemy.org/

Snowflake Documentation is available at: https://docs.snowflake.net/

Source code is also available at: https://github.com/snowflakedb/snowflake-sqlalchemy

Release Notes

• v1.1.0 (February 1, 2018)

  • Updated doc including role example.

  • Fixed the return value of get_pk_constraint and get_primary_keys. Those applications that depend on the old behaviors must update codes. Issue #38 (@nrth)

  • Updated doc including a note about open and close connections.

• v1.0.9 (January 4, 2018)

  • Fixed foreign key names that should be normalized. Issue #24 (@cladden)

  • Set the default schema Issue #25 (@cladden)

  • Improved performance by caching current database and schema for inspector. Issue #30 (@cladden)

• v1.0.8 (December 21, 2017)

  • Added get_schema_names method to Snowflake SQLAlchemy dialect. PR #20(andrewsali)

  • Fixed the column metadata including length for string/varchar and precision and scale for numeric data type. Issue #22(@cladden)

• v1.0.7 (May 18, 2017)

  • Fixed COPY command transaction issue. PR #16(Pangstar) and Issue #17(Pangstar)

• v1.0.6 (April 20, 2017)

  • Fixed account with subdomain issue. Issue #15(Pangstar)

• v1.0.5 (April 13, 2017)

  • Added snowflake_clusterby option support to Table object so that the user can create a table with clustering keys

• v1.0.4 (March 9, 2017)

  • Added SQLAlchemy 1.1 support

• v1.0.3 (October 20, 2016)

  • Added VARIANT, OBJECT and ARRAY data type supports for fetch

• v1.0.2 (July 5, 2016)

  • Fixed the development status in classifiers. 5 - Production/Stable

• v1.0.1 (July 4, 2016)

  • Fixed URL method in case of including warehouse without database.

• v1.0.0 (June 28, 2016)

  • General Availability