snowflake-sqlalchemy

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.13 (May 20,2019)
- CopyInto’s maxfilesize method expects a bool instead of an int
- CopyInto statement doesn’t compile correctly when the source is storage and the destination is a table
v1.1.12 (April 8,2019)
- Add ability to inspect column comments
- Restricting index creation checking to only SnowflakeDialect tables
v1.1.11 (March 25, 2019)
- Remove relative reference to connector from SQLAlchemy dialect
v1.1.10 (February 22, 2019)
- Separated base.py file into smaller files and fixed import statements
- Prevent creating tables with indexes in SQLAlchemy
- Add tox support
v1.1.9 (February 11, 2019)
- Fix an issue in v1.1.8
v1.1.8 (February 8, 2019)
- Fixed a dependency
v1.1.7 (February 8, 2019)
- Added Upsert in sql-alchemy
- CopyIntoS3 command in SQLAlchemy
v1.1.6 (January 3, 2019)
- Fixed ‘module’ object is not callable in csvsql
v1.1.5 (December 19, 2018)
- Added multivalue_support feature flag
- Deprecate get_primary_keys
v1.1.4 (November 13, 2018)
- Fixed lable/alias by honoring quote_name.
v1.1.3 (October 30, 2018)
- SQLAlchemy 1.2 multi table support.
- TIMESTAMP_LTZ, TIMESTAMP_NTZ and TIMESTAMP_TZ support.
- Fixed relative import issue in SQLAlchemy
v1.1.2 (June 7, 2018)
- Removes username restriction for OAuth
v1.1.1 (May 17, 2018)
- Made password as optional parameter for SSO support
- Fixed paramstyl=qmark mode where the data are bound in the server instead of client side
- Fixed multipart schema support. Now db.schema can be specified in the schema parameters.
- Added region parameter support to URL utility method.
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

Metadata

Release files for snowflake-sqlalchemy 1.1.13

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for snowflake-sqlalchemy 1.1.13
File	Size	Uploaded
snowflake-sqlalchemy-1.1.13.tar.gz	27.1 kB	May 20, 2019	Details

Built distribution (wheel)

Table of built distributions (wheels) for snowflake-sqlalchemy 1.1.13
File	Interpreter	ABI	Platform	Reset
snowflake_sqlalchemy-1.1.13-py2.py3-none-any.whl 27.6 kB May 20, 2019	Python 2, Python 3	none	any	Details

Total release size: 54.7 kB

Release files / snowflake-sqlalchemy-1.1.13.tar.gz

Download URL	snowflake-sqlalchemy-1.1.13.tar.gz
Size	27.1 kB
Tags	Source
SHA-256 checksum How to use checksums	`696d362a0495bb4fb7474598e0e0c27c644ec1fdd3370a989ce51adf16eafe96`
BLAKE2b-256 checksum How to use checksums	`8f9b9f357da06d8fe555dfba45d4a2ce1827bedb5b79b86d9aad3cd9cb109970`
Upload date	May 20, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.11.0 pkginfo/1.4.2 requests/2.18.4 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/3.4.8`

Release files / snowflake_sqlalchemy-1.1.13-py2.py3-none-any.whl

Download URL	snowflake_sqlalchemy-1.1.13-py2.py3-none-any.whl
Size	27.6 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`02b42c4b42b6a5475776b2e0015d31e705d7d5dcb8a92a254dd03cc7b223b1c1`
BLAKE2b-256 checksum How to use checksums	`6b0bb28f865585c8d3d69d492ea6285d1b6b4108645e0c85e4a7144f51c19e48`
Upload date	May 20, 2019
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/1.11.0 pkginfo/1.4.2 requests/2.18.4 setuptools/40.6.3 requests-toolbelt/0.8.0 tqdm/4.23.4 CPython/3.4.8`