snowflake-connector-python 3.1.0

Release

on Python PyPI

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:

  • On Linux: ~/.config/snowflake/, but follows XDG settings
  • On Mac: ~/Library/Application Support/snowflake/
  • On Windows: %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))"
  

  • Bumped cryptography dependency from <41.0.0,>=3.1.0 to >=3.1.0,<42.0.0.
  • Improved OCSP response caching to remove tmp cache files on Windows.
  • Improved OCSP response caching to reduce the times of disk writing.
  • Added a parameter server_session_keep_alive in SnowflakeConnection that skips session deletion when client connection closes.
  • Tightened our pinning of platformdirs, to prevent their new releases breaking us.
  • Fixed a bug where SFPlatformDirs would incorrectly append application_name/version to its path.
  • Added retry reason for queries that are retried by the client.
  • Fixed a bug where 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.
  • Remove Python 3.7 support.
  • Worked around a segfault which sometimes occurred during cache serialization in multi-threaded scenarios.
  • Improved error handling of connection reset error.
  • Fixed a bug about deleting the temporary files happened when running PUT command.
  • Allowed to pass type_mapper to fetch_pandas_batches() and fetch_pandas_all().
  • Fixed a bug where pickle.dump segfaults during cache serialization in multi-threaded scenarios.
  • Improved retry logic for okta authentication to refresh token if authentication gets throttled.
  • Note that this release does not include the changes introduced in the previous 3.1.0a1 release. Those will be released at a later time.

Please check our community page for release notes.