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

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Newer release available (1.11.1)

11 maintainers

PyPI data
Data sourced directly from PyPI's database.
Avatar for angel.avalos from gravatar.com angel.avalos Avatar for ankit.bhatnagar from gravatar.com ankit.bhatnagar Avatar for azhan from gravatar.com azhan
+8 more Avatar for enkwate from gravatar.com enkwate Avatar for harshc from gravatar.com harshc Avatar for hyu from gravatar.com hyu Avatar for kirandama from gravatar.com kirandama Avatar for notkriswagner from gravatar.com notkriswagner Avatar for snowflakerelease from gravatar.com snowflakerelease Avatar for stakeda from gravatar.com stakeda Avatar for Tianyi from gravatar.com Tianyi

Credits

Author: Snowflake Computing, Inc

License

Apache Software License (Apache License, Version 2.0)

Tags

Snowflake db database cloud analytics warehouse

Classifiers

Report project as malware

Release files for snowflake-sqlalchemy 1.1.11

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.11
File Size Uploaded
snowflake-sqlalchemy-1.1.11.tar.gz 26.6 kB Details

Built distribution (wheel)

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

Total release size: 53.9 kB

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

Download URL snowflake-sqlalchemy-1.1.11.tar.gz
Size 26.6 kB
Tags Source
SHA-256 checksum
How to use checksums 		7e024fd2737eee71c834bb58df8c5f2e44dd7da9b872411ebd9b1355575c9fe6
BLAKE2b-256 checksum
How to use checksums 		66f83b2e0151284342de439d755dc887ddc62bb6eda67dcc6901d0ac6103509a
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.4.8

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

Download URL snowflake_sqlalchemy-1.1.11-py2.py3-none-any.whl
Size 27.3 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums 		69501dc0cda65b8c4e8f90793d0890222a8c60079c888bf12f8e41daaa561d63
BLAKE2b-256 checksum
How to use checksums 		1e4b22651b6b87d0c5676b34357c03fae1a58be0a140abf3226cf819157c861c
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.4.8

Release history Release notifications | RSS feed

Pre-release

2.0.0rc2

2 release files

Pre-release

2.0.0rc1

2 release files

Pre-release

2.0.0a2

2 release files

Pre-release

2.0.0a0

2 release files

1.11.1

2 release files

1.11.0

2 release files

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

Yanked

1.5.2

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

Yanked

1.4.5

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

Yanked

1.4.0

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

Yanked

1.2.5

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

2 release files

1.1.17

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

2 release files

This release

1.1.11 This release

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