prefect-snowflake
Prefect integrations for interacting with Snowflake
Decision gist · record as of 2026-08-14
Yes, if you are already using Prefect for workflow orchestration and need to integrate Snowflake. The package is actively maintained, has low install friction, carries a permissive license, and is part of the official Prefect ecosystem. It is worth installing as a dependency when Snowflake is a core part of your data pipeline.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later and valid Snowflake credentials (account, user, password, or authentication method).
- Low install friction with a pure-Python wheel.
- Actively maintained with a recent release 70 days ago.
License · maintenance · safety
Apache License 2.0 (permissive) — Apache License 2.0 (permissive) allows free use, modification, and distribution in commercial and private projects with minimal restrictions—just retain the license notice.
last release 2026-06-05 (70 days) · last repo commit 2026-08-14 · 23,623 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 332,294 downloads/mo, #7,508 on PyPI
Alternatives
Verify before relying
pip install prefect-snowflake
from prefect_snowflake import SnowflakeConnector
from prefect import flow
@flow
def my_flow():
connector = SnowflakeConnector.load("my-connector")
# Use connector to execute queries or fetch data- Whether the package provides pre-built task templates or only low-level connector abstractions.
- Support for Snowflake authentication methods beyond basic username/password (e.g., SSO, key-pair).
- Performance characteristics and connection pooling behavior under high-concurrency workflows.
What it is and what it does
prefect-snowflake is an official Prefect integration that bridges Prefect's workflow orchestration platform with Snowflake data warehouses. It provides Prefect blocks and tasks that encapsulate Snowflake connectivity, allowing you to build data pipelines that query, load, and transform data in Snowflake as part of larger orchestrated workflows.
The package wraps snowflake-connector-python and integrates with Prefect's task and block system, so you can define Snowflake operations declaratively within Prefect flows. It handles connection management, retries (via tenacity), and credential storage through Prefect's block infrastructure. Typical use is in ETL/ELT pipelines where Snowflake is the target or source system and Prefect orchestrates the workflow across multiple steps.
Use it for
- Build ETL pipelines that extract data from external sources and load it into Snowflake tables via Prefect workflows.
- Schedule and monitor recurring SQL transformations in Snowflake as part of a larger data orchestration platform.
- Coordinate multi-step data workflows where some steps run in Snowflake and others run in external systems, all managed by Prefect.
- Fetch query results from Snowflake and pass them downstream to other Prefect tasks for further processing or alerting.
- Manage Snowflake credentials centrally through Prefect blocks and reuse them across multiple workflows.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you are already using Prefect for workflow orchestration and need to integrate Snowflake.
The package is actively maintained, has low install friction, carries a permissive license, and is part of the official Prefect ecosystem. It is worth installing as a dependency when Snowflake is a core part of your data pipeline.
Install
prefect-snowflake on PyPI
Before you install
Low install friction with a pure-Python wheel. Actively maintained with a recent release 70 days ago. Depends on prefect, snowflake-connector-python, snowflake, and tenacity—all standard workflow and database libraries. Requires Python 3.10 or later.
Requires Python 3.10 or later and valid Snowflake credentials (account, user, password, or authentication method).
License in practice
Apache License 2.0 (permissive) allows free use, modification, and distribution in commercial and private projects with minimal restrictions—just retain the license notice.
Quickstart
pip install prefect-snowflake
from prefect_snowflake import SnowflakeConnector
from prefect import flow
@flow
def my_flow():
connector = SnowflakeConnector.load("my-connector")
# Use connector to execute queries or fetch dataVerify before relying
- Whether the package provides pre-built task templates or only low-level connector abstractions.
- Support for Snowflake authentication methods beyond basic username/password (e.g., SSO, key-pair).
- Performance characteristics and connection pooling behavior under high-concurrency workflows.
Package facts
| License | Apache License 2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagessnowflakesnowflake-connector-pythonprefecttenacity |
| Maintenance | Actively maintained 70 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 332,294 / month, #7,508 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersIntended Audience :: System AdministratorsLicense :: OSI Approved :: Apache Software LicenseNatural Language :: EnglishProgramming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Topic :: Software Development :: Libraries |
Evidence: prefect_snowflake-0.28.8-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 › “prefect snowflake integration”
- prefect-snowflakePrefect integration that provides tasks and blocks for connecting…
- prefect-emailProvides Prefect workflow integration for sending emails, enabling…
- prefect-githubProvides Prefect workflow tasks and blocks for interacting with…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also prefect-email · prefect-sqlalchemy · prefect-shell · prefect-dbt · prefect-github · prefect-aws · prefect-gitlab · streamsets · prefect-gcp · prefect-docker