Skip to main content
Yanked

This release has been yanked by its maintainers, and will be ignored by installers, except when explicitly specified.
Consider using release 1.11.1 instead.

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.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

Release files for snowflake-sqlalchemy 1.2.5

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.2.5
File Size Uploaded
snowflake-sqlalchemy-1.2.5.tar.gz 30.9 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for snowflake-sqlalchemy 1.2.5
File Interpreter ABI Platform
snowflake_sqlalchemy-1.2.5-py2.py3-none-any.whl Python 3, Python 2 none any Details

Total release size: 62.0 kB

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

Download URL snowflake-sqlalchemy-1.2.5.tar.gz
Size 30.9 kB
Tags Source
SHA-256 checksum
How to use checksums
c97bd2104a0000ef0257b3646a65a5a4b3194c6885973b5fa766c3a15cf42e4f
BLAKE2b-256 checksum
How to use checksums
d0fdbd1274222b6bc8276932f6577fd386fabe9f2bfce4f293a060e4674dca52
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.6.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.61.2 CPython/3.6.8

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

Download URL snowflake_sqlalchemy-1.2.5-py2.py3-none-any.whl
Size 31.1 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
9d09adaa966412f40e4815c5bd3b8a98491942c9c2434ed3011f3cd4e4d16464
BLAKE2b-256 checksum
How to use checksums
18f26ebcd0ac5e25b77ed36c2f55bb7330cac98d085623f4d556c63be151f1d3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.6.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.61.2 CPython/3.6.8

Release history Release notifications | RSS feed

1.10.2

2 release files

1.10.1

2 release files

1.10.0

2 release files

1.9.0

2 release files

1.8.2

2 release files

1.8.0

2 release files

1.7.7

2 release files

1.7.6

2 release files

1.7.5

2 release files

1.7.4

2 release files

1.7.3

2 release files

1.7.2

2 release files

1.7.1

2 release files

1.7.0

2 release files

1.6.1

2 release files

1.5.3

2 release files

1.5.1

2 release files

1.5.0

2 release files

1.4.7

2 release files

1.4.6

2 release files

1.4.4

2 release files

1.4.3

2 release files

1.4.2

2 release files

1.4.1

2 release files

1.3.4

2 release files

1.3.3

2 release files

1.3.2

2 release files

1.3.1

2 release files

This release

1.2.5 This release

2 release files

1.2.4

2 release files

1.2.3

2 release files

1.2.2

2 release files

1.2.1

2 release files

1.2.0

2 release files

1.1.16

2 release files

1.1.15

2 release files

1.1.14

2 release files

1.1.13

2 release files

1.1.11

2 release files

1.1.10

2 release files

1.1.9

2 release files

1.1.6

2 release files

1.1.5

2 release files

1.1.4

2 release files

1.1.3

2 release files

1.1.2

2 release files

1.1.1

2 release files

1.1.0

2 release files

1.0.9

2 release files

1.0.8

2 release files

1.0.7

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page