Snowflake-connector-python

- v3.3.0(October 10,2023)

- Updated to Apache arrow-nanoarrow project for result arrow data conversion.
- Introduced the `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.
- Introduced the `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.
- Introduced the `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.
- The newly-introduced environment variable, enum, and module variable are temporary. They will be removed in a future release when switch from arrow to nanoarrow for data conversion is complete.

- 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 dependency on a specific version of pyarrow.
This version is built on top of v3.2.0, and it includes the following nanoarrow related improvements:
- Updated arrow-nanoarrow dependency which improved error handling.
- Aligned error experience of handling corrupted arrow data with the GA versions.

- v3.2.1(September 26,2023)

- Fixed a bug where url port and path were ignored in private link oscp retry.
- Added thread safety in telemetry when instantiating multiple connections concurrently.
- Bumped platformdirs dependency from >=2.6.0,<3.9.0 to >=2.6.0,<4.0.0.0 and made necessary changes to allow this.
- Removed the deprecation warning from the vendored urllib3 about urllib3.contrib.pyopenssl deprecation.
- Improved robustness in handling authentication response.

- v3.2.0(September 06,2023)

- Made the ``parser`` -> ``manager`` renaming more consistent in ``snowflake.connector.config_manager`` module.
- Added support for default values for ConfigOptions
- Added default_connection_name to config.toml file

v3.1.1(August 28,2023)

- Fixed a bug in retry logic for okta authentication to refresh token.
- Support `RSAPublicKey` when constructing `AuthByKeyPair` in addition to raw bytes.
- Fixed a bug when connecting through SOCKS5 proxy, the attribute `proxy_header` is missing on `SOCKSProxyManager`.
- Cherry-picked https://github.com/urllib3/urllib3/commit/fd2759aa16b12b33298900c77d29b3813c6582de onto vendored urllib3 (v1.26.15) to enable enforce_content_length by default.
- Fixed a bug in tag generation of OOB telemetry event.

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``:

toml
[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](https://github.com/platformdirs/platformdirs/blob/main/README.rst) 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](https://community.snowflake.com/s/article/Snowflake-Connector-for-Python-Release-Notes).