Skip to main content
Pre-release

This release is a pre-release and may not be stable for production use.

Package apache-airflow-providers-snowflake

Release: 4.0.1rc3

Snowflake

Provider package

This is a provider package for snowflake provider. All classes for this provider package are in airflow.providers.snowflake python package.

You can find package information and changelog for the provider in the documentation.

Installation

You can install this package on top of an existing Airflow 2 installation (see Requirements below for the minimum Airflow version supported) via pip install apache-airflow-providers-snowflake

The package supports the following python versions: 3.7,3.8,3.9,3.10

Requirements

PIP package

Version required

apache-airflow

>=2.3.0

apache-airflow-providers-common-sql

>=1.3.1

snowflake-connector-python

>=2.4.1

snowflake-sqlalchemy

>=1.1.0

Cross provider package dependencies

Those are dependencies that might be needed in order to use all the features of the package. You need to install the specified provider packages in order to use them.

You can install such cross-provider dependencies when installing from PyPI. For example:

pip install apache-airflow-providers-snowflake[common.sql]

Dependent package

Extra

apache-airflow-providers-common-sql

common.sql

apache-airflow-providers-slack

slack

Changelog

4.0.1

Bug Fixes

  • Fix errors in Databricks SQL operator introduced when refactoring (#27854)

  • Bump common.sql provider to 1.3.1 (#27888)

  • Fixing the behaviours of SQL Hooks and Operators finally (#27912)

4.0.0

This release of provider is only available for Airflow 2.3+ as explained in the Apache Airflow providers support policy.

Breaking changes

In SnowflakeHook, if both extra__snowflake__foo and foo existed in connection extra dict, the prefixed version would be used; now, the non-prefixed version will be preferred.

  • Update snowflake hook to not use extra prefix (#26764)

Misc

  • Move min airflow version to 2.3.0 for all providers (#27196)

Features

  • Add SQLExecuteQueryOperator (#25717)

Bug fixes

  • Use unused SQLCheckOperator.parameters in SQLCheckOperator.execute. (#27599)

3.3.0

Features

  • Add custom handler param in SnowflakeOperator (#25983)

Bug Fixes

  • Fix wrong deprecation warning for 'S3ToSnowflakeOperator' (#26047)

3.2.0

Features

  • Move all "old" SQL operators to common.sql providers (#25350)

  • Unify DbApiHook.run() method with the methods which override it (#23971)

3.1.0

Features

  • Adding generic 'SqlToSlackOperator' (#24663)

  • Move all SQL classes to common-sql provider (#24836)

  • Pattern parameter in S3ToSnowflakeOperator (#24571)

Bug Fixes

  • S3ToSnowflakeOperator: escape single quote in s3_keys (#24607)

3.0.0

Breaking changes

Bug Fixes

  • Fix error when SnowflakeHook take empty list in 'sql' param (#23767)

2.7.0

Features

  • Allow multiline text in private key field for Snowflake (#23066)

2.6.0

Features

  • Add support for private key in connection for Snowflake (#22266)

Bug Fixes

  • Fix mistakenly added install_requires for all providers (#22382)

2.5.2

Misc

  • Remove Snowflake limits (#22181)

2.5.1

Misc

  • Support for Python 3.10

2.5.0

Features

  • Add more SQL template fields renderers (#21237)

Bug Fixes

  • Fix #21096: Support boolean in extra__snowflake__insecure_mode (#21155)

2.4.0

Features

  • Support insecure mode in SnowflakeHook (#20106)

  • Remove unused code in SnowflakeHook (#20107)

  • Improvements for 'SnowflakeHook.get_sqlalchemy_engine' (#20509)

  • Exclude snowflake-sqlalchemy v1.2.5 (#20245)

  • Limit Snowflake connector to <2.7.2 (#20395)

2.3.1

Bug Fixes

  • Remove duplicate get_connection in SnowflakeHook (#19543)

2.3.0

Features

  • Add test_connection method for Snowflake Hook (#19041)

  • Add region to Snowflake URI. (#18650)

2.2.0

Features

  • Add Snowflake operators based on SQL Checks (#17741)

2.1.1

Misc

  • Optimise connection importing for Airflow 2.2.0

2.1.0

Features

  • Adding: Snowflake Role in snowflake provider hook (#16735)

2.0.0

Breaking changes

  • Auto-apply apply_default decorator (#15667)

Features

  • Add 'template_fields' to 'S3ToSnowflake' operator (#15926)

  • Allow S3ToSnowflakeOperator to omit schema (#15817)

  • Added ability for Snowflake to attribute usage to Airflow by adding an application parameter (#16420)

Bug Fixes

  • fix: restore parameters support when sql passed to SnowflakeHook as str (#16102)

1.3.0

Features

  • Expose snowflake query_id in snowflake hook and operator (#15533)

1.2.0

Features

  • Add dynamic fields to snowflake connection (#14724)

1.1.1

Bug fixes

  • Corrections in docs and tools after releasing provider RCs (#14082)

  • Prepare to release the next wave of providers: (#14487)

1.1.0

Updated documentation and readme files.

Features

  • Fix S3ToSnowflakeOperator to support uploading all files in the specified stage (#12505)

  • Add connection arguments in S3ToSnowflakeOperator (#12564)

1.0.0

Initial version of the provider.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

apache-airflow-providers-snowflake-4.0.1rc3.tar.gz (25.2 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

File details

Details for the file apache-airflow-providers-snowflake-4.0.1rc3.tar.gz.

File metadata

File hashes

Hashes for apache-airflow-providers-snowflake-4.0.1rc3.tar.gz
Algorithm Hash digest
SHA256 b022674983a19e96cca44242045b323bc691708aa664b549d413b1fc42c7a098
MD5 14c2d02c4df7b5cdaa7edd9799712d1c
BLAKE2b-256 b82c6f98836ae9a529c79c271c9f6cd22303c4d86ecf2c6e02cf883e87be1dd7

See more details on using hashes here.

File details

Details for the file apache_airflow_providers_snowflake-4.0.1rc3-py3-none-any.whl.

File metadata

File hashes

Hashes for apache_airflow_providers_snowflake-4.0.1rc3-py3-none-any.whl
Algorithm Hash digest
SHA256 8a3237b197f2f393ff84f6958494da3bf4c618753172f887617bef514e061487
MD5 3686bce54561489d780f78fb3e0fe339
BLAKE2b-256 22f08441977fec9088882bf3665d4ec22a0b34bc8d7f681330ef49eb1b32f535

See more details on using hashes here.

Release history Release notifications | RSS feed

6.16.1

2 files

6.16.0

2 files

6.15.0

2 files

6.14.0

2 files

6.13.0

2 files

6.12.2

2 files

6.12.1

2 files

6.12.0

2 files

6.11.0

2 files

6.10.0

2 files

6.9.1

2 files

6.9.0

2 files

6.8.2

2 files

6.8.1

2 files

6.8.0

2 files

6.7.0

2 files

6.6.1

2 files

6.6.0

2 files

6.5.4

2 files

6.5.3

2 files

6.5.2

2 files

6.5.1

2 files

6.5.0

2 files

6.4.0

2 files

6.3.1

2 files

6.3.0

2 files

6.2.2

2 files

6.2.1

2 files

6.2.0

2 files

6.1.1

2 files

6.1.0

2 files

6.0.0

2 files

5.8.1

2 files

5.8.0

2 files

5.7.1

2 files

5.7.0

2 files

5.6.1

2 files

5.6.0

2 files

5.5.2

2 files

5.5.1

2 files

5.5.0

2 files

5.4.0

2 files

5.3.1

2 files

5.3.0

2 files

5.2.1

2 files

5.2.0

2 files

5.1.2

2 files

5.1.1

2 files

5.1.0

2 files

5.0.1

2 files

5.0.0

2 files

4.4.2

2 files

4.4.1

2 files

4.4.0

2 files

4.3.1

2 files

4.3.0

2 files

4.2.0

2 files

4.1.0

2 files

4.0.5

2 files

4.0.4

2 files

4.0.3

2 files

4.0.2

2 files

4.0.1

2 files

This release

4.0.1rc3 This release

2 files

4.0.0

2 files

3.3.0

2 files

3.2.0

2 files

3.1.0

2 files

3.0.0

2 files

2.7.0

2 files

2.6.0

2 files

2.5.2

2 files

2.5.1

2 files

2.5.0

2 files

2.4.0

2 files

2.3.1

2 files

2.3.0

2 files

2.2.0

2 files

2.1.1

2 files

2.1.0

2 files

2.0.0

2 files

1.3.0

2 files

1.2.0

1 file

1.1.1

2 files

1.1.0

2 files

1.0.0

2 files

1.0.0rc1

2 files

1.0.0b2

2 files

1.0.0b1

2 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