Skip to main content

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

Release files for snowflake-sqlalchemy 1.3.2

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.3.2
File Size Uploaded
snowflake-sqlalchemy-1.3.2.tar.gz 31.1 kB Details

Built distribution (wheel)

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

Total release size: 62.3 kB

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

Download URL snowflake-sqlalchemy-1.3.2.tar.gz
Size 31.1 kB
Tags Source
SHA-256 checksum
How to use checksums
51d9d923ebbfefe392582f6e3d0faa83f52e5eb6f190607820e055318dd2d2f8
BLAKE2b-256 checksum
How to use checksums
f935a5b3de8a470c62b5ae3afc314a5b4452d66e7119c3cc8d7ab32f8344fbc6
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.2 CPython/3.6.8

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

Download URL snowflake_sqlalchemy-1.3.2-py2.py3-none-any.whl
Size 31.3 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
18bd923eb14a8e511c10f0b716ac710d92476ca49965b56a9dd2575e4d5842e9
BLAKE2b-256 checksum
How to use checksums
489d54604979e1726d7bf36d21dc0b7e2d396095db4e4fc2b0a8c9f18b8049da
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/3.4.2 importlib_metadata/4.8.1 pkginfo/1.7.1 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.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

This release

1.3.2 This release

2 release files

1.3.1

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