Snowflake Connector for Python
This package includes the Snowflake Connector for Python, which conforms to the Python DB API 2.0 specification.
The Snowflake Connector for Python provides an interface for developing Python applications that can connect to Snowflake and perform all standard operations. It provides a programming alternative to developing applications in Java or C/C++ using the Snowflake JDBC or ODBC drivers.
The connector has no dependencies on JDBC or ODBC.
It can be installed using pip on Linux, Mac OSX, and Windows platforms
where Python 3.11.0 (or higher) is installed.
Development
Prerequisites
- Python 3.11+
- uv package manager
- Hatch build tool
- Rust toolchain (for building core library)
- Credentials:
../parameters.json(see main README.md for setup instructions)
Setup
Install uv and Hatch:
# Install uv
curl -LsSf https://astral.sh/uv/install.sh | sh
# Install Hatch
uv tool install hatch
Note: The Rust core library is built automatically during the build process via a custom Hatch build hook. You don't need to build it manually.
Environment Variables
IMPORTANT: Set up required environment variables before running tests:
export PARAMETER_PATH="$(pwd)/../parameters.json"
Hatch Environments
This project uses Hatch to manage development environments. There are two primary environments for running tests, each designed for a different use case:
dev Environment (for local development)
The dev environment is designed for human developers during active development. It installs the package from sources in editable mode, meaning any code changes are immediately reflected without reinstallation.
Key characteristics:
- Installs from sources (
skip-install = false) - Editable mode enabled (
dev-mode = true) - Changes to source code are immediately available
- Supports Python matrix: 3.11, 3.12, 3.13, 3.14
Usage:
# Run all tests with the dev environment
hatch run dev:all
# Run specific test types
hatch run dev:unit # Unit tests only
hatch run dev:integ # Integration tests only
hatch run dev:e2e # End-to-end tests only
# Run with coverage
hatch run dev:all-cov
# Run with specific Python version
hatch run dev.py3.12:all
# Pass additional pytest arguments
hatch run dev:all -k test_connection --maxfail=1
test Environment (for CI/CD pipelines)
The test environment is designed for CI systems to test the end-to-end software development lifecycle (SDLC). It does not install from sources - instead, it expects a pre-built wheel to be installed, simulating how end users would install and use the package.
Key characteristics:
- Skips source installation (
skip-install = true) - No editable mode (
dev-mode = false) - Requires explicit wheel installation via
install-wheelscript - Tests the actual built artifact, not source code
Usage:
# First, build the wheel
hatch build
# Then install and test with the test environment
hatch run test:install-wheel
hatch run test:all
# Or with specific Python version
hatch run test.py3.12:install-wheel
hatch run test.py3.12:all
Environment Comparison
| Aspect | dev |
test |
|---|---|---|
| Purpose | Local development | CI/CD pipelines |
| Installs from | Source (editable) | Pre-built wheel |
| Code changes | Immediately reflected | Requires rebuild |
| Tests | Source code | Built artifact |
| Use case | Developer workflow | E2E SDLC validation |
Other Environments
# Code quality checks
hatch run precommit:check # Run all checks (format, lint, type)
hatch run precommit:fix # Auto-fix formatting and linting issues
# Reference connector tests (for compatibility testing, installs latest v4.x)
hatch run reference:test
# Pin a specific version if needed:
PYTHON_REFERENCE_DRIVER_VERSION='==4.3.0' hatch run reference:test
References
11 maintainers
Metadata
11 maintainers
Release files for snowflake-connector-python 5.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| snowflake_connector_python-5.0.0.tar.gz | 1.9 MB | Details |
Built distributions (wheels)
Total release size: 283.0 MB
Release files / snowflake_connector_python-5.0.0.tar.gz
| Download URL | snowflake_connector_python-5.0.0.tar.gz |
|---|---|
| Size | 1.9 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
94677d66208a3b1626324e0b9312b577cab99f6431b21aee19b24c9ec9acf648
|
|
BLAKE2b-256 checksum How to use checksums |
cbb92da3619b66e0a5225a7c63a44ab93337c92f85b880fa4f8f2ff1eeedb089
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp314-cp314-win_amd64.whl
| Download URL | snowflake_connector_python-5.0.0-cp314-cp314-win_amd64.whl |
|---|---|
| Size | 12.2 MB |
| Tags | CPython 3.14 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
d614ef97d88036c44ebf8c3a1ed5d1fa5131b64e9a4d24cdefb6e63ac7762239
|
|
BLAKE2b-256 checksum How to use checksums |
71f01d00669357595f207c7adafdfa2d41362cda519b43e150f65e757b4dde7c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp314-cp314-manylinux_2_28_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp314-cp314-manylinux_2_28_x86_64.whl |
|---|---|
| Size | 18.8 MB |
| Tags | CPython 3.14 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
74eb680b69ef8f6990c42a66bd9883eb2e25207a5caef9e366ccf517e9259288
|
|
BLAKE2b-256 checksum How to use checksums |
dce9d000c003a25108f14c4db8a446c2c44969692a91d3462cc9dc07f492086f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp314-cp314-manylinux_2_28_aarch64.whl
| Download URL | snowflake_connector_python-5.0.0-cp314-cp314-manylinux_2_28_aarch64.whl |
|---|---|
| Size | 17.7 MB |
| Tags | CPython 3.14 Linux glibc 2.28+ ARM64 |
|
SHA-256 checksum How to use checksums |
3926b2df0f57ce67202fe7d5c399f026e806fe2f5431a5039215043d574de730
|
|
BLAKE2b-256 checksum How to use checksums |
932c6def82379a3d455b618415776015eb9ad67d391261b82c26650ba57d6725
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp314-cp314-macosx_11_0_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp314-cp314-macosx_11_0_arm64.whl |
|---|---|
| Size | 10.9 MB |
| Tags | CPython 3.14 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
77ce8c006e0c765facb8b6fb05a20c87044602d0a16a7ec09c779f3809959183
|
|
BLAKE2b-256 checksum How to use checksums |
61270298144e727166edb67f13db14cb0a669e1ee413ae3eb50c44272c96f497
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp314-cp314-macosx_10_15_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp314-cp314-macosx_10_15_x86_64.whl |
|---|---|
| Size | 11.6 MB |
| Tags | CPython 3.14 macOS 10.15+ x86-64 |
|
SHA-256 checksum How to use checksums |
83348aece70fd0ad0e4e60d71636188d69e80672fcb87d202fab83217a94e3b7
|
|
BLAKE2b-256 checksum How to use checksums |
c9840340c5f76fd9acac799f26a89af0e204f7ebd43a631ec3218927449b22af
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp313-cp313-win_amd64.whl
| Download URL | snowflake_connector_python-5.0.0-cp313-cp313-win_amd64.whl |
|---|---|
| Size | 11.7 MB |
| Tags | CPython 3.13 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
615ec181d1b4e9980eb66adb0ce04ddb9e302a555e1452874b52c23afece4edd
|
|
BLAKE2b-256 checksum How to use checksums |
250f77bdef65a3b4a8160cb22b45ccb4e38be53c999f8ec791a1285251a5217d
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp313-cp313-manylinux_2_28_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp313-cp313-manylinux_2_28_x86_64.whl |
|---|---|
| Size | 17.0 MB |
| Tags | CPython 3.13 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
071a3021149fda531e426157dab0d137c772f5cdb89d03516a3aac7519261837
|
|
BLAKE2b-256 checksum How to use checksums |
fdd9b81b486b252bf70ce55184357311a0e744f4d4b8c436402963768a60de90
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp313-cp313-manylinux_2_28_aarch64.whl
| Download URL | snowflake_connector_python-5.0.0-cp313-cp313-manylinux_2_28_aarch64.whl |
|---|---|
| Size | 16.0 MB |
| Tags | CPython 3.13 Linux glibc 2.28+ ARM64 |
|
SHA-256 checksum How to use checksums |
f200fd88b3255c649a1eaf7f2c24f7b5b5e93f2b25020ab03d6b8d055200514e
|
|
BLAKE2b-256 checksum How to use checksums |
437329234b82a1d96845ec87dbbea5032df23bc995db53543bf05ec7b060090b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp313-cp313-macosx_11_0_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp313-cp313-macosx_11_0_arm64.whl |
|---|---|
| Size | 10.7 MB |
| Tags | CPython 3.13 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
33303d157f2457f439895ae20485f7b93e7e23b4bfc13f714c3dcb21b9f5edb3
|
|
BLAKE2b-256 checksum How to use checksums |
d03dc2f1b825798c7accb4e6d30d5622feb710ab0419737cf8f5ad59e5aa5ecb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp313-cp313-macosx_10_14_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp313-cp313-macosx_10_14_x86_64.whl |
|---|---|
| Size | 11.4 MB |
| Tags | CPython 3.13 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
8216b006ea5c08f4ae1e14c4440db8f4881c671690f73c89027f81ccb2f0cc0e
|
|
BLAKE2b-256 checksum How to use checksums |
95f47b6530a8b844917eadc59bc1686eb09f0c697197d8d340b36b4c9d909635
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-win_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-win_arm64.whl |
|---|---|
| Size | 10.9 MB |
| Tags | CPython 3.12 Windows ARM64 |
|
SHA-256 checksum How to use checksums |
8fdfbc3078d35d7bbb7b6054ac0954915acaccbc64cdceb97a7f221e90e934d9
|
|
BLAKE2b-256 checksum How to use checksums |
b956cb5a5805086ae2fa4fa6ea9e454d8a66216cc2aeb40fc4fadcbcdc087069
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-win_amd64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-win_amd64.whl |
|---|---|
| Size | 11.6 MB |
| Tags | CPython 3.12 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
724d58959aef18afc4c7075161488da8ddde22fbb4fa82190a53ea21c4f63cb5
|
|
BLAKE2b-256 checksum How to use checksums |
459d09a201949455c5f580d286c41b364f2eb9fe9375b07f1ea87f5661de3811
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-manylinux_2_28_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-manylinux_2_28_x86_64.whl |
|---|---|
| Size | 15.2 MB |
| Tags | CPython 3.12 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
a97160c98d9ddecaf8329a2223f15691566ba681e8b3a7fd827ee9c25e473287
|
|
BLAKE2b-256 checksum How to use checksums |
6e0e4b5eef7c6c99fa781aa40599a8052b94740b6b0ca55ee04960bf5754d79f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-manylinux_2_28_aarch64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-manylinux_2_28_aarch64.whl |
|---|---|
| Size | 14.2 MB |
| Tags | CPython 3.12 Linux glibc 2.28+ ARM64 |
|
SHA-256 checksum How to use checksums |
ac7930d970707251ef6646eb98ef8e836c404642c20dc0d15d1597962b2597bc
|
|
BLAKE2b-256 checksum How to use checksums |
49517a33757c27cbd2d9c0de75df5f627ea7cedc6335292535611ea394b6ec43
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-macosx_11_0_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-macosx_11_0_arm64.whl |
|---|---|
| Size | 10.6 MB |
| Tags | CPython 3.12 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
2326fa7ae44d5d9163d70bb82e12317e9864413fd8dac206203b47b1ba7e2e09
|
|
BLAKE2b-256 checksum How to use checksums |
1d09f7da1efc081123c8af0e65d1946b407512d10dfe37e685222107ef552031
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp312-cp312-macosx_10_14_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp312-cp312-macosx_10_14_x86_64.whl |
|---|---|
| Size | 11.2 MB |
| Tags | CPython 3.12 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
7042b58fceaffcebf21562e4144fe3c22fbe5626f3bcde8b47236468818fb908
|
|
BLAKE2b-256 checksum How to use checksums |
f77e48b05f1600c7185e28e9455e023b50fbccaf47e9682360622cb5db0008c3
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-win_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-win_arm64.whl |
|---|---|
| Size | 10.9 MB |
| Tags | CPython 3.11 Windows ARM64 |
|
SHA-256 checksum How to use checksums |
b557caddbfdd2cc0eb65ce2db415f09ddbb5ffc7cc2bcb75aead466ace7c5fa2
|
|
BLAKE2b-256 checksum How to use checksums |
054995509088aa0546ede0950c639e8703c86e082e5e11285faa71b8cb2f69f1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-win_amd64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-win_amd64.whl |
|---|---|
| Size | 11.5 MB |
| Tags | CPython 3.11 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
9d118f8809cb640c50f36ddac404140c36bbbc0b4b7c715273cb5fd18cb4d940
|
|
BLAKE2b-256 checksum How to use checksums |
c1602fc246a60bee678baaf111bb9a3555dacc4dcc976e5410f36f66c0a84a6c
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-manylinux_2_28_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-manylinux_2_28_x86_64.whl |
|---|---|
| Size | 13.4 MB |
| Tags | CPython 3.11 Linux glibc 2.28+ x86-64 |
|
SHA-256 checksum How to use checksums |
8f468c9b0f1433a41b5ec46f030a966569f40b2398825a3733b3ef224b12ffef
|
|
BLAKE2b-256 checksum How to use checksums |
aa96a14b0dc3dcdeba256c6d286c9a233e1460153d8d147dda773e573378dc12
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-manylinux_2_28_aarch64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-manylinux_2_28_aarch64.whl |
|---|---|
| Size | 12.4 MB |
| Tags | CPython 3.11 Linux glibc 2.28+ ARM64 |
|
SHA-256 checksum How to use checksums |
0a33770621f29a2b37d9b7eb20060300c02368ab09cd4ad78aebea2b799c83e4
|
|
BLAKE2b-256 checksum How to use checksums |
5549c20d27b64f59e31716fe997794c8447b05d83f35fafd315db55b8756993e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-macosx_11_0_arm64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-macosx_11_0_arm64.whl |
|---|---|
| Size | 10.4 MB |
| Tags | CPython 3.11 macOS 11.0+ ARM64 |
|
SHA-256 checksum How to use checksums |
ff1280242a77a0362fb057213c1bc071eae90e6ceabc505e0b299301ca563bc7
|
|
BLAKE2b-256 checksum How to use checksums |
feac8bbf76798e76e4b2dc8714449246d46a6778e0f1230bcda98c7630ff3dd1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
Release files / snowflake_connector_python-5.0.0-cp311-cp311-macosx_10_14_x86_64.whl
| Download URL | snowflake_connector_python-5.0.0-cp311-cp311-macosx_10_14_x86_64.whl |
|---|---|
| Size | 11.0 MB |
| Tags | CPython 3.11 macOS 10.14+ x86-64 |
|
SHA-256 checksum How to use checksums |
aa37f23e46a939d8ae97def93c224ab88d69ceee0ce590ef0a43304f4667de30
|
|
BLAKE2b-256 checksum How to use checksums |
46195e84de489fb7014e7bda9857db66637c9e6c69203ab82ec83778e06d6ce6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/7.0.0 CPython/3.11.16
|
