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.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.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size snowflake_sqlalchemy-1.2.4-py2.py3-none-any.whl (29.3 kB) | File type Wheel | Python version py2.py3 | Upload date | Hashes View |
Filename, size snowflake-sqlalchemy-1.2.4.tar.gz (29.7 kB) | File type Source | Python version None | Upload date | Hashes View |
Hashes for snowflake_sqlalchemy-1.2.4-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e20ee81f3c2f6748b33a69d2e97018930ed09f83e27b1aa36ba5f841eb53bdce |
|
MD5 | 77964b57f98c0fb5b0b2c5f7af3af95b |
|
BLAKE2-256 | 33af5ef8a3b966b868ae9b8273ec87bb7cf3ad4e4c472b44fd5886093d2cd815 |
Hashes for snowflake-sqlalchemy-1.2.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | e79d83d4947a0945488699324802eda4ad4a63c7680ad5b2a42c71f4faa2cd8b |
|
MD5 | 73557cfc197e2628e882f20123379298 |
|
BLAKE2-256 | a53509473ee74723efe4dd147415516dd3c9aed098433f1e93bd9ea322a76dab |