apache-airflow-providers-snowflake
Provider package apache-airflow-providers-snowflake for Apache Airflow
Decision gist · record as of 2026-08-14
Yes. This is a production-stable, actively maintained provider package from the Apache Airflow project with no known vulnerabilities. Install it if you use Airflow and need to orchestrate Snowflake workloads. The low install friction, permissive license, and tight integration with Airflow's task model make it the standard choice for this use case. No blockers for typical deployments.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires an existing Airflow installation (>=2.11.0) and a configured Snowflake connection in Airflow's metadata database.
- Low friction installation as a wheel; active maintenance with a release 6 days old.
- Requires Apache Airflow >=2.11.0 and Python 3.10–3.14.
License · maintenance · safety
Apache-2.0 (permissive) — Apache License 2.0 (permissive). No restrictions on commercial or private use; you may modify and distribute under the same license terms.
last release 2026-08-08 (6 days) · last repo commit 2026-08-14 · 46,475 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 23,456,567 downloads/mo, #944 on PyPI
Alternatives
Verify before relying
pip install apache-airflow-providers-snowflake
from airflow.providers.snowflake.operators.snowflake import SnowflakeOperator
from airflow import DAG
from datetime import datetime
with DAG('snowflake_dag', start_date=datetime.now()) as dag:
task = SnowflakeOperator(
task_id='run_query',
sql='SELECT 1',
snowflake_conn_id='snowflake_default'
)- Specific list of operators, hooks, and sensors available in this version beyond basic query execution.
- Support for Snowflake-specific features (e.g., dynamic tables, Iceberg integration, Cortex functions).
- Performance characteristics when orchestrating large-scale data transfers or complex warehouse operations.
What it is and what it does
This is an Apache Airflow provider package that bridges Airflow's task orchestration engine with Snowflake's cloud data warehouse. It supplies operators, hooks, and sensors that let you define Snowflake operations—queries, data loads, warehouse scaling—as tasks in Airflow DAGs, enabling scheduled and event-driven automation of Snowflake workloads alongside other data pipeline steps.
The package wraps Snowflake's Python SDK (snowflake-connector-python, snowflake-sqlalchemy, snowflake-snowpark-python) and integrates with Airflow's common SQL provider framework. It is actively maintained by the Apache Airflow project, supports Python 3.10, 3.11, 3.12, 3.13, 3.14, and requires Apache Airflow >=2.11.0. Installation is straightforward via pip; the main prerequisite is an existing Airflow deployment with a configured Snowflake connection.
Use it for
- Schedule and monitor recurring SQL queries or stored procedures in Snowflake as part of a larger data pipeline.
- Orchestrate multi-step ELT workflows where data is extracted, loaded into Snowflake, and transformed using Snowflake compute.
- Trigger Snowflake warehouse scaling or clustering operations on a schedule or in response to upstream task completion.
- Integrate Snowflake operations with non-Snowflake tasks (e.g., API calls, machine learning, notifications) in a single DAG.
- Monitor Snowflake query execution and warehouse health using Airflow sensors and alerting.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
This is a production-stable, actively maintained provider package from the Apache Airflow project with no known vulnerabilities. Install it if you use Airflow and need to orchestrate Snowflake workloads. The low install friction, permissive license, and tight integration with Airflow's task model make it the standard choice for this use case. No blockers for typical deployments.
Install
apache-airflow-providers-snowflake on PyPI
Before you install
Low friction installation as a wheel; active maintenance with a release 6 days old. Requires Apache Airflow >=2.11.0 and Python 3.10–3.14. Runtime dependency on snowflake-connector-python, snowflake-sqlalchemy, and snowflake-snowpark-python adds weight but is standard for Snowflake integrations.
Requires an existing Airflow installation (>=2.11.0) and a configured Snowflake connection in Airflow's metadata database.
License in practice
Apache License 2.0 (permissive). No restrictions on commercial or private use; you may modify and distribute under the same license terms.
Quickstart
pip install apache-airflow-providers-snowflake
from airflow.providers.snowflake.operators.snowflake import SnowflakeOperator
from airflow import DAG
from datetime import datetime
with DAG('snowflake_dag', start_date=datetime.now()) as dag:
task = SnowflakeOperator(
task_id='run_query',
sql='SELECT 1',
snowflake_conn_id='snowflake_default'
)Verify before relying
- Specific list of operators, hooks, and sensors available in this version beyond basic query execution.
- Support for Snowflake-specific features (e.g., dynamic tables, Iceberg integration, Cortex functions).
- Performance characteristics when orchestrating large-scale data transfers or complex warehouse operations.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 10 packagesapache-airflowapache-airflow-providers-common-compatapache-airflow-providers-common-sqlpandaspyarrowpyOpenSSLsnowflake-connector-pythonsnowflake-sqlalchemysnowflake-snowpark-pythonsetuptools |
| Maintenance | Actively maintained 6 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 23,456,567 / month, #944 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableEnvironment :: ConsoleEnvironment :: Web EnvironmentFramework :: Apache AirflowFramework :: Apache Airflow :: ProviderIntended Audience :: DevelopersIntended Audience :: System AdministratorsProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: System :: Monitoring |
Evidence: apache_airflow_providers_snowflake-6.16.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “airflow snowflake integration”
- apache-airflow-providers-snowflakeIntegrates Apache Airflow with Snowflake, providing operators, hooks,…
- openlineage-airflowIntegrates Apache Airflow DAGs with OpenLineage to automatically…
- acryl-datahubDataHub's ingestion framework and CLI for pulling metadata from 50+…
Give your agent the search over MCP, or paste the wish link into any chat.
More Monitoring packages
Wraps any iterable to display a real-time progress bar in the terminal or Jupyter notebook, showing iteration count, elapsed time, and estimated time remaining.
Provides generated Python code for OpenTelemetry semantic conventions, enabling standardized attribute naming and constant definitions for instrumentation and telemetry collection.
Install it if you are using OpenTelemetry and want to follow semantic conventions correctly.
Provides the reference implementation of the OpenTelemetry API for collecting and exporting traces, metrics, and logs from Python applications.
Provides the abstract API and interfaces for OpenTelemetry instrumentation in Python, defining how to emit traces, metrics, and logs without tying code to a specific SDK implementation.
Exports OpenTelemetry observability data to an OpenTelemetry Collector using Protobuf-encoded messages over HTTP.
Install it if you are using OpenTelemetry in Python and need to send data to a Collector over HTTP.
Provides automatic instrumentation commands and programmatic APIs to inject distributed tracing into Python applications without code changes, detecting and instrumenting packages used by your program.
Install it if you need distributed tracing without code changes and have compatible instrumented packages in your environment.
See also apache-airflow-providers-microsoft-azure · apache-airflow-providers-postgres · apache-airflow-providers-oracle · apache-airflow-providers-databricks · apache-airflow-providers-salesforce · apache-airflow-providers-standard · snowflake-snowpark-python · apache-airflow-providers-elasticsearch · adbc-driver-snowflake · openlineage-airflow