snowflake-connector-python

Snowflake Connector for Python

snowflake-connector-python Permissive license Apache-2.0 Active ★ 725 v4.7.2 released 2026-08-07

Install

snowflake-connector-python on PyPI

pip

pip install snowflake-connector-python

uv

uv add snowflake-connector-python

poetry

poetry add snowflake-connector-python

Package facts

License	Apache-2.0 (permissive)
Python support	supports the current Python release (>=3.10)
Install friction	medium — platform-specific wheel
Runtime dependencies	17 — asn1crypto, cryptography, pyOpenSSL, pyjwt, pytz, requests, packaging, charset_normalizer, idna, certifi, typing_extensions, filelock, sortedcontainers, platformdirs, tomlkit, boto3, botocore
Maintenance	actively maintained — 6 days since the last release
Last repo commit	2026-08-12
First released	2017-08-31
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_connector_python-4.7.2-cp310-cp310-macosx_14_0_arm64.whl; snowflake_connector_python-4.7.2-cp310-cp310-macosx_15_0_x86_64.whl; snowflake_connector_python-4.7.2-cp310-cp310-manylinux2014_aarch64.manylinux_2_17_aarch64.whl; snowflake_connector_python-4.7.2-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl; snowflake_connector_python-4.7.2-cp310-cp310-win_amd64.whl; snowflake_connector_python-4.7.2-cp311-cp311-macosx_14_0_arm64.whl; snowflake_connector_python-4.7.2-cp311-cp311-macosx_15_0_x86_64.whl; snowflake_connector_python-4.7.2-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.whl; snowflake_connector_python-4.7.2-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl; snowflake_connector_python-4.7.2-cp311-cp311-win_amd64.whl; snowflake_connector_python-4.7.2-cp312-cp312-macosx_14_0_arm64.whl; snowflake_connector_python-4.7.2-cp312-cp312-macosx_15_0_x86_64.whl; snowflake_connector_python-4.7.2-cp312-cp312-manylinux2014_aarch64.manylinux_2_17_aarch64.whl; snowflake_connector_python-4.7.2-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl; snowflake_connector_python-4.7.2-cp312-cp312-win_amd64.whl; snowflake_connector_python-4.7.2-cp313-cp313-macosx_14_0_arm64.whl; snowflake_connector_python-4.7.2-cp313-cp313-macosx_15_0_x86_64.whl; snowflake_connector_python-4.7.2-cp313-cp313-manylinux2014_aarch64.manylinux_2_17_aarch64.whl; snowflake_connector_python-4.7.2-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl; snowflake_connector_python-4.7.2-cp313-cp313-win_amd64.whl

Keywords: Snowflake, db, database, cloud, analytics, 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.14Programming Language :: Python :: Free Threading :: 2 - BetaProgramming Language :: SQLTopic :: DatabaseTopic :: Scientific/Engineering :: Information AnalysisTopic :: Software DevelopmentTopic :: Software Development :: LibrariesTopic :: Software Development :: Libraries :: Application FrameworksTopic :: Software Development :: Libraries :: Python Modules

About snowflake-connector-python

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

This package includes the Snowflake Connector for Python, which conforms to the Python DB API 2.0 specification: https://www.python.org/dev/peps/pep-0249/

Snowflake Documentation is available at: https://docs.snowflake.com/

Source code is also available at: https://github.com/snowflakedb/snowflake-connector-python

Release Notes

v4.7.2(Aug 6,2026)
Fixed a thread leak in the file transfer agent by properly shutting down ThreadPoolExecutors after PUT/GET transfers (SNOW-3556240, #2878).
Fixed split_statements treating // as SQL instead of a line comment, which could merge multiple statements when a // comment contained an apostrophe (SNOW-3772985).
Fixed large-file PUT uploads to internal Azure stages failing against the Azure 50,000-block-per-blob limit. The Azure multipart chunk size is now scaled up dynamically for very large files (mirroring the existing S3 behavior), and the default Azure chunk size was raised from 4 MB to 8 MB (consistent with S3) for better throughput (SNOW-3839943).
Fixed OAuth cached-credential connections failing with 250001 Invalid OAuth access token when the cached token was invalid (GS code 390303); the connector now...

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 Python DB API 2.0-compliant connector for Snowflake cloud data warehouse, enabling SQL queries and data operations against Snowflake accounts from Python applications.

Medium install friction due to 17 runtime dependencies and platform-specific wheels (macOS arm64/x86_64, Linux x86_64/aarch64, Windows). Maintenance is active: last release 6 days ago, repository at 725 stars with recent commits.

Licensed under Apache-2.0 (permissive), allowing commercial and private use with minimal restrictions; suitable for most production deployments.

Usage

pip install snowflake-connector-python

import snowflake.connector
conn = snowflake.connector.connect(account='your_account', user='user', password='pass')
cursor = conn.cursor()
cursor.execute('SELECT 1')
print(cursor.fetchone())

Requires Python 3.10 or later; Snowflake account credentials (account name, user, authentication method) must be configured.

Verdict: Production-ready connector with active maintenance, no known vulnerabilities, and broad Python version support (3.10–3.14 including free-threaded). Medium install friction from native dependencies is typical for database drivers. Apache-2.0 license poses no commercial barrier.

Needs verification

Whether the 17 runtime dependencies (including boto3, cryptography, pyOpenSSL) introduce transitive security concerns beyond the OSV scan.
Performance characteristics and connection pooling capabilities relative to typical Snowflake workloads.
Support status and compatibility guarantees for the beta free-threaded Python 3.14t classifier.

snowflake database connector pythonsnowflake sql clientcloud data warehouse python driversnowflake db apipython snowflake integrationsnowflake analytics connectorsnowflake cloud sql python