Snowflake SQLAlchemy Dialect
Project description
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.3.4(April 27,2022)
Fixed a bug where identifier max length was set to the wrong value and added relevant schema introspection
Add support for geography type
Fixed a bug where foreign key’s referred schema was set incorrectly
Disabled new SQLAlchemy option for statement caching until support gets added
v1.3.3(December 19,2021)
Fixed an issue where quote arguments were stripped from identifiers.
v1.3.2 (September 14,2021)
Fixed a breaking change introduced in SQLAlchemy 1.4 that changed the behavior of returns_unicode_strings.
v1.3.1 (July 23,2021)
Raising minimum version of SQLAlchemy to match used features.
v1.2.5 (July 20,2021)
Various custom command bug fixes and additions.
v1.2.4 (October 05,2020)
Fixed an issue where inspector would not properly switch to table wide column retrieving when schema wide column retrieving was taking too long to respond.
v1.2.3 (March 30,2020)
Add external stage added to COPY INTO custom command
Allow support for PANDAS 1.x
v1.2.2 (March 9, 2020)
Allow get_table_comment to fetch view comments too
v1.2.1 (February 18,2020)
Add driver property to SnowflakeDialect #140
Suppress deprecation warning by fixing import
v1.2.0 (January 27, 2020)
Fix typo in README Connection Parameters #141
Fix sqlalchemy and possibly python-connector warnings
Fix handling of empty table comments #137
Fix handling spaces in connection string passwords #149
v1.1.18 (January 6,2020)
Set current schema in connection string containing special characters
Calling str on custom_types throws Exception
v1.1.17 (December 2,2019)
Comments not created when creating new table #118
SQLAlchemy Column Metadata Cache not working
Timestamp DDL renders wrong when precision value passed
Fixed special character handling in snowflake-sqlalchemy from URL string
Added development optional dependencies to Python packages
v1.1.16 (October 21,2019)
Fix SQLAlchemy not working with global url
v1.1.15 (September 30, 2019)
Incorrect SQL generated for INSERT with CTE
Type Synonyms not exported to top-level module #109
v1.1.14 (August 12, 2019)
Fix CSVFormatter class has FIELD_DELIMETER spelled incorrectly
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
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for snowflake-sqlalchemy-1.3.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9d74cf9d60a18ffac83263e8559af502163bb47551ca09a9366875a0647a5b80 |
|
MD5 | f00e8a51c450d0855085f881bc78fbd9 |
|
BLAKE2b-256 | 9b816cb1b63c80df07b8c318646488c80570f1a34ca4a0549bd200afba994138 |
Hashes for snowflake_sqlalchemy-1.3.4-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0fd28673d813f6ffa8ebaa7dd3de96fa0f8c90632f445a6a066f3e9b6b0975ed |
|
MD5 | 6b10b81d775d9475f8d16f9cf21b2c4e |
|
BLAKE2b-256 | c3a3435ab472358353e8b36a84fd52763683afc4c2ce609cb171beddd59ed500 |