---
id: snowflake-sqlalchemy
version: "1.11.0"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# snowflake-sqlalchemy — Snowflake SQLAlchemy Dialect

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install snowflake-sqlalchemy
uv add snowflake-sqlalchemy
poetry add snowflake-sqlalchemy

## Description

# Snowflake SQLAlchemy

[![Build and Test](https://github.com/snowflakedb/snowflake-sqlalchemy/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-sqlalchemy/actions/workflows/build_test.yml)
[![codecov](https://codecov.io/gh/snowflakedb/snowflake-sqlalchemy/branch/main/graph/badge.svg)](https://codecov.io/gh/snowflakedb/snowflake-sqlalchemy)
[![PyPi](https://img.shields.io/pypi/v/snowflake-sqlalchemy.svg)](https://pypi.python.org/pypi/snowflake-sqlalchemy/)
[![License Apache-2.0](https://img.shields.io/:license-Apache%202-brightgreen.svg)](http://www.apache.org/licenses/LICENSE-2.0.txt)
[![Codestyle Black](https://img.shields.io/badge/code%20style-black-000000.svg)](https://github.com/psf/black)

Snowflake SQLAlchemy runs on the top of the Snowflake Connector for Python as a [dialect](http://docs.sqlalchemy.org/en/latest/dialects/) 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`,...

## AI interpretation — verify before relying

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

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.

[View on SkillFed](https://skillfed.io/packages/snowflake-sqlalchemy) · [View on PyPI](https://pypi.org/project/snowflake-sqlalchemy/)