`apache-airflow-providers-snowflake`¶

Content¶

Guides

References

Python API

Resources

Commits

Detailed list of commits

Package apache-airflow-providers-snowflake¶

Snowflake

Release: 3.1.0

Provider package¶

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

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

Requirements¶

PIP package	Version required
`apache-airflow`	`>=2.2.0`
`apache-airflow-providers-common-sql`
`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`

Downloading official packages¶

You can download officially released packages and verify their checksums and signatures from the Official Apache Download site

Changelog¶

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¶

This release of provider is only available for Airflow 2.2+ as explained in the Apache Airflow providers support policy https://github.com/apache/airflow/blob/main/README.md#support-for-providers

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)

Warning

Due to apply_default decorator removal, this version of the provider requires Airflow 2.1.0+. If your Airflow version is < 2.1.0, and you want to install this provider version, first upgrade Airflow to at least version 2.1.0. Otherwise your Airflow package version will be upgraded automatically and you will have to manually run airflow upgrade db to complete the migration.

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.