finds.dev

snowflakedb/snowflake-connector-python

Snowflake Connector for Python

View on GitHubHomepage ↗

★ 727PythonApache-2.0updated Jun 2026

// the take

The official Snowflake Python connector — DB-API 2.0 compliant, with both sync and async interfaces. It's the standard way to connect Python applications to Snowflake, and it ships precompiled Arrow/Rust native libraries for result deserialization. If you're using Snowflake from Python, this is what you use; there's no real alternative.

Arrow-based result streaming via nanoarrow C++ extension means large result sets don't materialize entirely in memory before you can iterate them. The async interface under `snowflake.connector.aio` is a proper rewrite, not a thin wrapper around threads. Workload identity federation (WIF) support means you can authenticate via cloud IAM without storing credentials. Package signatures via cosign are a nice supply-chain touch.

The Rust `sf_mini_core` library is a precompiled binary blob checked into the repo — you can't audit or build it yourself without hunting down the separate universal-driver repo. GCP regional endpoints are explicitly unsupported, which will surprise anyone running in a GCP region with data residency requirements. The sync and async implementations are largely duplicated under separate directories rather than sharing a core; that's a maintenance surface area that will diverge over time. Test infrastructure requires live Snowflake credentials with GPG-encrypted parameter files — there's no way to run anything meaningful locally without an actual account.

We read the README, the directory tree and a key source file in June 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
727
Forks
557
Language
Python
License
Apache-2.0
Last commit
10 Jun 2026

// nearby

If snowflake-connector-python isn't quite it.

All repos →