NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI, #275 most downloaded on PyPI
Snowflake DB driver for Python
Latest stable
5.2.0
Last release 15 days ago
04 Nov 2026
Ships fairly regularly
a new release about every 2 weeks
Nearly every release is documented
notes for 59 of the last 60 stable releases
6 versions withdrawn
withdrawn after publishing
9 years old
193 releases · first in 2017
Drag across the ruler to compare, or tap a release to open it.
Bumped vendored urllib3 to 1.26.18
v3.4.1(November 08, 2023)
Added support for use_logical_type in write_pandas.
v3.4.0(November 03,2023)
use_logical_type in write_pandas.backoff_policy argument to snowflake.connector.connect allowing for configurable backoff policy between retries of failed requests. See available implementations in the backoff_policies module.socket_timeout argument to snowflake.connector.connect specifying socket read and connect timeout.login_timeout and network_timeout behaviour. Retries of login and network requests are now properly halted after these timeouts expire.urllib.Your coding agent can read these notes before it upgrades. Set up the MCP server →
Added for non-Windows platforms command suggestions (chown/chmod) for insufficient file permissions of config files.
v3.3.1(October 18, 2023)
ImportError when the c extensions are not compiled.Updated to Apache arrow-nanoarrow project for result arrow data conversion.
v3.3.0(October 10,2023)
NANOARROW_USAGE environment variable to allows switching between the nanoarrow converter and the arrow converter. Valid values include:
FOLLOW_SESSION_PARAMETER, which uses the converter configured in the server.DISABLE_NANOARROW, which uses arrow converter, overriding the server setting.ENABLE_NANOARROW, which uses the nanoarrow converter, overriding the server setting.snowflake.connector.cursor.NanoarrowUsage enum, whose members include:
NanoarrowUsage.FOLLOW_SESSION_PARAMETER, which uses the converter configured in the server.NanoarrowUsage.DISABLE_NANOARROW, which uses arrow converter, overriding the server setting.NanoarrowUsage.ENABLE_NANOARROW, which uses the nanoarrow converter, overriding the server setting.snowflake.connector.cursor.NANOARROW_USAGE module variable to allow switching between the nanoarrow converter and the arrow converter. It works in conjunction with the snowflake.connector.cursor.NanoarrowUsage enum.Version 3.3.0b1 is the snowflake-connector-python based on apache nanoarrow project, which reduces the package size as well as removes a hard dependen
Removed the deprecation warning from the vendored urllib3 about urllib3.contrib.pyopenssl deprecation.
v3.2.1(September 26,2023)
Made the parser -> manager renaming more consistent in snowflake.connector.config_manager module.
v3.2.0(September 06,2023)
parser -> manager renaming more consistent in snowflake.connector.config_manager module.Fixed a bug in retry logic for okta authentication to refresh token.
v3.1.1(August 28,2023)
RSAPublicKey when constructing AuthByKeyPair in addition to raw bytes.proxy_header is missing on SOCKSProxyManager.Added a feature that lets you add connection definitions to the connections.toml configuration file. A connection definition refers to a collection of
v3.1.0(July 31,2023)
Added a feature that lets you add connection definitions to the connections.toml configuration file. A connection definition refers to a collection of connection parameters, for example, if you wanted to define a connection named `prod``:
[prod]
account = "my_account"
user = "my_user"
password = "my_password"
By default, we look for the connections.toml file in the location specified in the SNOWFLAKE_HOME environment variable (default: ~/.snowflake). If this folder does not exist, the Python connector looks for the file in the platformdirs location, as follows:
~/.config/snowflake/, but follows XDG settings~/Library/Application Support/snowflake/%USERPROFILE%\AppData\Local\snowflake\You can determine which file is used by running the following command:
python -c "from snowflake.connector.constants import CONNECTIONS_FILE; print(str(CONNECTIONS_FILE))"
server_session_keep_alive in SnowflakeConnection that skips session deletion when client connection closes.write_pandas fails when user does not have the privilege to create stage or file format in the target schema, but has the right privilege for the current schema.type_mapper to fetch_pandas_batches() and fetch_pandas_all().Please check our community page for release notes.
Version 3.1.0a2 is built on top of 3.1.0a1, including all the latest changes in the released GA version 3.1.0.
Version 3.1.0a2 is built on top of 3.1.0a1, including all the latest changes in the released GA version 3.1.0.
Version 3.1.0a1 is our first efforts to build snowflake-connector-python based on apache nanoarrow project, which reduces the package size as well as
Version 3.1.0a1 is our first efforts to build snowflake-connector-python based on apache nanoarrow project, which reduces the package size as well as removes a hard dependency on a specific version of pyarrow. This version also includes the following features and bug fixes from the unreleased v3.0.5:
New Features and Improvements
Added a feature that lets you add connection definitions to the config.toml configuration file. A connection definition refers to a collection of connection parameters. The connection configuration name must begin with connections, similar to the following that defines the parameters for the prod connection:
[connections.prod]
account = "my_account"
user = "my_user"
password = "my_password"
By default, we look for the config.toml file in the location specified in the SNOWFLAKE_HOME environment variable (default: ~/.snowflake). If this folder does not exist, the Python connector looks for the file in the platformdirs location, as follows:
~/.config/snowflake/, but follows XDG settings~/Library/Application Support/snowflake/%USERPROFILE%\AppData\Local\snowflake\You can determine which file is used by running the following command:
python -c "from snowflake.connector.constants import CONFIG_FILE; print(str(CONFIG_FILE))"
Bumped cryptography dependency from <41.0.0,>=3.1.0 to >=3.1.0,<42.0.0.
Allowed to pass type_mapper to fetch_pandas_batches() and fetch_pandas_all().
Added a parameter server_session_keep_alive in SnowflakeConnection that skips session deletion when client connection closes.
Added retry reason for queries that are retried by the client.
Improved error handling of connection reset error.
Improved OCSP response caching to remove tmp cache files on Windows.
Improved OCSP response caching to reduce the times of disk writing.
Tightened our pinning of platformdirs, to prevent their new releases breaking us.
Remove Python 3.7 support.
Bug Fixes
write_pandas fails when user does not have the privilege to create stage or file format in the target schema, but has the right privilege for the current schema.Added the json_result_force_utf8_decoding connection parameter to force decoding JSON content in utf-8 when the result format is JSON.
New Features and Improvements
Bug Fixes
Please check our community page for release notes.
Added a parameter that allows users to skip file uploads to stage if file exists on stage and contents of the file match.
SnowflakeCursor.execute method.snowflake.connector.pandas_tool.write_pandas.snowflake.connector.pandas_tool.write_pandas.snowflake.connector.pandas_tool.write_pandas.Please check our community page for release notes.
Improved logging to mask tokens in case of errors.
New Features
Bug Fixes
Please check our community page for release notes.
Improved the robustness of OCSP response caching to handle errors in cases of serialization and deserialization.
New Features
Bug Fixes
Fixed a bug where write_pandas did not use user-specified schemas and databases to create intermediate objects
Behavior Changes
New Features and Updates
Bug Fixes
Please check our community page for release notes.
Reworked authentication internals to allow users to plug custom key-pair authenticators.
New Features
Bug Fixes
Released to PyPI on December 14, 2022
Bumped cryptography dependency from <39.0.0 to <41.0.0
Improved performance of regexes used for PUT/GET SQL statement detection. CVE-2022-42965
Bumped cryptography dependency from <37.0.0 to <39.0.0
Fixed a bug where rowcount was deleted when the cursor was closed
Fixed a bug where timestamps fetched as pandas.DataFrame or pyarrow.Table would overflow for the sake of unnecessary precision. In the case where an o
Added minimum version pin to typing_extensions
Release wheels are now built on manylinux2014
Fixed a bug where errors raised during get_results_from_sfqid() were missing errno
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.