snowflake-connector-python
Snowflake Connector for Python
Decision gist · record as of 2026-08-14
Yes. This is the official, actively maintained connector for Snowflake with no known vulnerabilities, permissive licensing, and broad platform support. Install friction is moderate due to dependencies, but prebuilt wheels minimize compilation overhead. Essential for any Python application that needs Snowflake connectivity.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; account credentials (user, password, and Snowflake account identifier) must be provided at connection time.
- Medium install friction due to 17 runtime dependencies including cryptography, boto3, and botocore.
- Active maintenance with release 7 days old; last commit 2026-08-12.
License · maintenance · safety
Apache-2.0 (permissive) — Apache-2.0 permissive license allows commercial and private use with minimal restrictions; you must include a copy of the license and notice of modifications.
last release 2026-08-07 (7 days) · last repo commit 2026-08-12 · 725 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 193,645,891 downloads/mo, #212 on PyPI
Alternatives
Verify before relying
pip install snowflake-connector-python
import snowflake.connector
conn = snowflake.connector.connect(
user='username',
password='password',
account='account_id'
)
cursor = conn.cursor()
cursor.execute('SELECT * FROM table')
results = cursor.fetchall()- Whether the 17 runtime dependencies introduce transitive security concerns beyond the 0 known vulnerabilities in this package itself
- Performance characteristics for large-scale data transfers or high-concurrency workloads
- Compatibility with async/await patterns or whether the connector is synchronous-only
What it is and what it does
This is the official Python connector for Snowflake, implementing the DB API 2.0 standard for SQL database access. It handles authentication (including OAuth, SAML, JWT key-pair, and workload identity), SQL execution, result fetching, and data staging operations for Snowflake's cloud data warehouse. The connector manages connection pooling, TLS verification, and multi-platform binary support through prebuilt wheels.
The package brings together cryptographic libraries (cryptography, pyOpenSSL, pyjwt), HTTP clients (requests, boto3 for S3/Azure staging), and utility dependencies to abstract Snowflake's API. Recent releases (4.7.x) focus on authentication robustness, file-transfer reliability, and support for newer Python versions including free-threaded Python 3.14t. It is actively maintained with frequent bug fixes and security improvements.
Use it for
- Execute SQL queries and fetch results from Snowflake warehouses in Python applications
- Load data into Snowflake via staged PUT operations or pandas DataFrames
- Authenticate using OAuth, SAML, JWT key-pair, or cloud workload identity in production environments
- Integrate Snowflake as a data source in ETL/ELT pipelines or analytics workflows
- Download query results or bulk data from Snowflake stages using GET operations
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
This is the official, actively maintained connector for Snowflake with no known vulnerabilities, permissive licensing, and broad platform support. Install friction is moderate due to dependencies, but prebuilt wheels minimize compilation overhead. Essential for any Python application that needs Snowflake connectivity.
Install
snowflake-connector-python on PyPI
Before you install
Medium install friction due to 17 runtime dependencies including cryptography, boto3, and botocore. Active maintenance with release 7 days old; last commit 2026-08-12. Supports Python 3.10–3.14 with prebuilt wheels for major platforms (macOS arm64/x86_64, Linux x86_64/aarch64, Windows).
Requires Python 3.10 or later; account credentials (user, password, and Snowflake account identifier) must be provided at connection time.
License in practice
Apache-2.0 permissive license allows commercial and private use with minimal restrictions; you must include a copy of the license and notice of modifications.
Quickstart
pip install snowflake-connector-python
import snowflake.connector
conn = snowflake.connector.connect(
user='username',
password='password',
account='account_id'
)
cursor = conn.cursor()
cursor.execute('SELECT * FROM table')
results = cursor.fetchall()Verify before relying
- Whether the 17 runtime dependencies introduce transitive security concerns beyond the 0 known vulnerabilities in this package itself
- Performance characteristics for large-scale data transfers or high-concurrency workloads
- Compatibility with async/await patterns or whether the connector is synchronous-only
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 packagesasn1cryptocryptographypyOpenSSLpyjwtpytzrequestspackagingcharset_normalizeridnacertifityping_extensionsfilelocksortedcontainersplatformdirstomlkitboto3botocore |
| Maintenance | Actively maintained 7 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 193,645,891 / month, #212 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.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 |
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
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 › “snowflake sql queries”
- snowflake-connector-pythonConnects Python applications to Snowflake data warehouses using the…
- snowflake-snowpark-pythonSnowpark Python provides APIs to query and process data directly in…
- apache-airflow-providers-snowflakeIntegrates Apache Airflow with Snowflake, providing operators, hooks,…
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 salesforce-cdp-connector · snowflake · snowflake-sqlalchemy · django-snowflake · snowflake.core · snowflake-snowpark-python · prefect-snowflake · databricks-sql-connector · adbc-driver-snowflake · dbt-snowflake