snowflake-sqlalchemy

Snowflake SQLAlchemy Dialect

snowflake-sqlalchemy Permissive license Apache-2.0 Active ★ 270 v1.11.0 released 2026-07-08

Install

snowflake-sqlalchemy on PyPI

pip

pip install snowflake-sqlalchemy

uv

uv add snowflake-sqlalchemy

poetry

poetry add snowflake-sqlalchemy

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 — snowflake-connector-python, sqlalchemy
Maintenance	actively maintained — 36 days since the last release
Last repo commit	2026-08-13
First released	2017-05-18
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: snowflake_sqlalchemy-1.11.0-py3-none-any.whl

Keywords: Snowflake, analytics, cloud, database, db, warehouse

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

About snowflake-sqlalchemy

from the package's own PyPI description — quoted content, verbatim

Snowflake SQLAlchemy

Build and Test (image) codecov (image) PyPi (image) License Apache-2.0 (image) Codestyle Black (image)

Snowflake SQLAlchemy runs on the top of the Snowflake Connector for Python as a dialect to bridge a Snowflake database and SQLAlchemy applications.

> v1.11.0 — Sensitive connection parameters: We curated a set of connector parameters (host, protocol, token_file_path, private_key_file, ocsp_response_cache_filename, connection_diag_log_path, crl_cache_dir, unsafe_file_write,...

Read as markdown · JSON record · Source repository · Homepage · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

A SQLAlchemy dialect that bridges Snowflake databases and SQLAlchemy applications, enabling ORM and SQL operations against Snowflake through the standard SQLAlchemy interface.

Low friction: pure-Python wheel with only two runtime dependencies (snowflake-connector-python and sqlalchemy). Actively maintained with recent releases; repository shows 270 stars and last commit on 2026-08-13.

Apache-2.0 permissive license allows commercial use, modification, and distribution with minimal restrictions, making it suitable for most enterprise and open-source projects.

Usage

pip install snowflake-sqlalchemy

from sqlalchemy import create_engine

engine = create_engine('snowflake://{user}:{password}@{account}/')
connection = engine.connect()
results = connection.execute('select current_version()').fetchone()
connection.close()

Requires valid Snowflake account credentials (user, password, account name) and Python 3.8 or later.

Verdict: Production-ready dialect with active maintenance, no known vulnerabilities, and low install friction. Supports Python 3.8–3.13 and integrates seamlessly with SQLAlchemy 1.4 and 2.x. Suitable for applications requiring Snowflake database access through SQLAlchemy's ORM and SQL expression language.

Needs verification

Whether version 1.11.0's sensitive connection parameter restrictions (host, protocol, token_file_path, etc.) affect existing deployments relying on URL query strings.
Performance characteristics and query optimization capabilities compared to direct snowflake-connector-python usage.
Compatibility matrix details for SQLAlchemy 2.x support mentioned as a future release candidate.

snowflake sqlalchemy dialectsnowflake orm pythonsqlalchemy snowflake connectorsnowflake database pythonsnowflake sql toolkitcloud data warehouse orm