snowflake-sqlalchemy
Snowflake SQLAlchemy Dialect
Decision gist · record as of 2026-08-14
Yes. This is a stable, actively maintained package (no known vulnerabilities, recent release, 270 GitHub stars) with low install friction and permissive licensing. Install it if you are building a Python application that needs to connect to Snowflake and prefer SQLAlchemy's abstraction layer over raw SQL or the connector API. The only caveat is that the current version supports SQLAlchemy 1.4 (a legacy version); if you require SQLAlchemy 2.x, monitor the project for the planned release candidate.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires valid Snowflake account credentials and network access to Snowflake; sensitive connection parameters (host, protocol, token_file_path, private_key_file, etc.) must be passed via connect_args in create_engine(), not in the URL query string as of v1.11.0.
- Low friction installation; the package is a pure-Python wheel that automatically installs its two runtime dependencies (snowflake-connector-python and sqlalchemy).
- Actively maintained with a recent release (37 days old) and no known vulnerabilities.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache-2.0 (permissive), allowing use in commercial and proprietary projects with minimal restrictions beyond attribution.
last release 2026-07-08 (37 days) · last repo commit 2026-08-13 · 270 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 79,567,809 downloads/mo, #427 on PyPI
Alternatives
Verify before relying
pip install snowflake-sqlalchemy
from sqlalchemy import create_engine
engine = create_engine(
'snowflake://{user}:{password}@{account}/'.format(
user='your_user',
password='your_password',
account='your_account'
)
)
connection = engine.connect()
results = connection.execute('select current_version()').fetchone()
connection.close()- Specific performance characteristics or query optimization features beyond standard SQLAlchemy
- Extent of support for Snowflake-specific SQL extensions (VARIANT, ARRAY, OBJECT, VECTOR, etc.) in ORM contexts
- Timeline and feature set for planned SQLAlchemy 2.x-only release candidate
What it is and what it does
Snowflake SQLAlchemy acts as a bridge between SQLAlchemy applications and Snowflake databases by implementing a SQLAlchemy dialect. It runs on top of the Snowflake Connector for Python and allows developers to use standard SQLAlchemy ORM and Core patterns to query and manipulate data in Snowflake, rather than writing raw SQL or using the connector directly.
The package supports a range of Snowflake-specific features including key-pair authentication, bulk insert optimization, Alembic migrations, structured data types (MAP, OBJECT, ARRAY), dynamic tables, Iceberg tables with Snowflake Catalog, and hybrid tables. Connection parameters can be customized via the connection string or connect_args, and the package handles Snowflake-specific behaviors like case sensitivity and auto-increment semantics. It is actively maintained and supports Python 3.8 through 3.13.
Use it for
- Building data analytics applications that query Snowflake using SQLAlchemy ORM models instead of raw SQL
- Migrating existing SQLAlchemy applications from other databases to Snowflake with minimal code changes
- Automating database schema management and migrations for Snowflake using Alembic
- Performing bulk data loads into Snowflake with ORM-level optimization
- Integrating Snowflake with Python web frameworks (Pyramid) or data analysis tools (Pandas, Jupyter)
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
This is a stable, actively maintained package (no known vulnerabilities, recent release, 270 GitHub stars) with low install friction and permissive licensing. Install it if you are building a Python application that needs to connect to Snowflake and prefer SQLAlchemy's abstraction layer over raw SQL or the connector API. The only caveat is that the current version supports SQLAlchemy 1.4 (a legacy version); if you require SQLAlchemy 2.x, monitor the project for the planned release candidate.
Install
snowflake-sqlalchemy on PyPI
Before you install
Low friction installation; the package is a pure-Python wheel that automatically installs its two runtime dependencies (snowflake-connector-python and sqlalchemy). Actively maintained with a recent release (37 days old) and no known vulnerabilities.
Requires valid Snowflake account credentials and network access to Snowflake; sensitive connection parameters (host, protocol, token_file_path, private_key_file, etc.) must be passed via connect_args in create_engine(), not in the URL query string as of v1.11.0.
License in practice
Licensed under Apache-2.0 (permissive), allowing use in commercial and proprietary projects with minimal restrictions beyond attribution.
Quickstart
pip install snowflake-sqlalchemy
from sqlalchemy import create_engine
engine = create_engine(
'snowflake://{user}:{password}@{account}/'.format(
user='your_user',
password='your_password',
account='your_account'
)
)
connection = engine.connect()
results = connection.execute('select current_version()').fetchone()
connection.close()Verify before relying
- Specific performance characteristics or query optimization features beyond standard SQLAlchemy
- Extent of support for Snowflake-specific SQL extensions (VARIANT, ARRAY, OBJECT, VECTOR, etc.) in ORM contexts
- Timeline and feature set for planned SQLAlchemy 2.x-only release candidate
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.8 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagessnowflake-connector-pythonsqlalchemy |
| Maintenance | Actively maintained 37 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 79,567,809 / month, #427 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 :: Other EnvironmentIntended Audience :: DevelopersIntended Audience :: EducationIntended Audience :: Information TechnologyIntended Audience :: System AdministratorsLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: SQLTopic :: DatabaseTopic :: Scientific/Engineering :: Information AnalysisTopic :: Software DevelopmentTopic :: Software Development :: LibrariesTopic :: Software Development :: Libraries :: Application FrameworksTopic :: Software Development :: Libraries :: Python Modules |
Evidence: snowflake_sqlalchemy-1.11.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 › “sqlalchemy snowflake dialect”
- snowflake-sqlalchemySnowflake SQLAlchemy is a SQLAlchemy dialect that enables SQLAlchemy…
- sqlalchemy-pgspiderProvides a SQLAlchemy dialect that enables connections to PGSpider…
- sqlalchemy-databricksProvides a SQLAlchemy dialect that connects to Databricks workspaces…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also databricks-sqlalchemy · django-snowflake · snowflake-connector-python · snowflake.core · snowflake · sqlalchemy-databricks · agate-sql · fakesnow · snowflake._legacy · sqlalchemy-bigquery