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

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.15
File Size Uploaded
snowflake-sqlalchemy-1.1.15.tar.gz 27.7 kB Details

Built distribution (wheel)

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

Total release size: 55.8 kB

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

Download URL snowflake-sqlalchemy-1.1.15.tar.gz
Size 27.7 kB
Tags Source
SHA-256 checksum
How to use checksums
f9baa6d98844c47ef6128898b4afe0cd2c566e60e9ffa40634154ef59b13e2d8
BLAKE2b-256 checksum
How to use checksums
b8e9556d4609edeb625432e29f470e85b77b3fed0ae2fd5ac102cc60369b442e
Upload date
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.5.1

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

Download URL snowflake_sqlalchemy-1.1.15-py2.py3-none-any.whl
Size 28.1 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
9cc485e4fff73d7ffcccaa44b7765f3363a51af176c1523b009e23680ccfd345
BLAKE2b-256 checksum
How to use checksums
39dfb6a5e26113d56dec69375070ed8cf13a32204af967dc584c232e788f74f0
Upload date
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.5.1

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

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

This release

1.1.15 This release

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