Snowflake-connector-python

**New Features**

- Improved the robustness of OCSP response caching to handle errors in cases of serialization and deserialization.
- Replaced the dependency on setuptools in favor of packaging.
- Updated async_executes method's doc-string.
- Errors raised now have a query field that contains the SQL query that caused them when available.

**Bug Fixes**

- Fixed a bug where AuthByKeyPair.handle_timeout should pass keyword arguments instead of positional arguments when calling AuthByKeyPair.prepare.
- Fixed a bug where MFA token caching would refuse to work until restarted instead of reauthenticating.
Please check our [community page for release notes](https://community.snowflake.com/s/article/Snowflake-Connector-for-Python-Release-Notes).

**Behavior Changes**

- Fixed a bug where write_pandas did not use user-specified schemas and databases to create intermediate objects

**New Features and Updates**

- Bumped pyarrow dependency from >=8.0.0,<8.1.0 to >=10.0.1,<10.1.0
- Bumped pyOpenSSL dependency from <23.0.0 to <24.0.0
- During browser-based authentication, the SSO url is now printed before opening it in the browser
- Increased the level of a log for when ArrowResult cannot be imported
- Added a minimum MacOS version check when compiling C-extensions

**Bug Fixes**

- Fixed a bug where the HTTP 429 response code was not retried
- Fixed a bug where MFA token caching was not working

Please check our [community page for release notes](https://community.snowflake.com/s/article/Snowflake-Connector-for-Python-Release-Notes).

**New Features**

- Reworked authentication internals to allow users to plug custom key-pair authenticators.
- Multi-statement query execution is now supported through cursor.execute and cursor.executemany.
- The Snowflake parameter MULTI_STATEMENT_COUNT can be altered at the account, session, or statement level. An additional argument, num_statements, can be provided to execute to use this parameter at the statement level. It must be provided to executemany to submit a multi-statement query through the method. Note that bulk insert optimizations available through executemany are not available when submitting multi-statement queries.
- By default the parameter is 1, meaning only a single query can be submitted at a time.
- Set to 0 to submit any number of statements in a multi-statement query.
- Set to >1 to submit the specified exact number of statements in a multi-statement query.
- Bindings are accepted in the same way for multi-statements as they are for single statement queries.
- Asynchronous multi-statement query execution is supported. Users should still use get_results_from_sfqid to retrieve results.
- To access the results of each query, users can call SnowflakeCursor.nextset() as specified in the DB 2.0 API (PEP-249), to iterate through each statements results.
- The first statement's results are accessible immediately after calling execute (or get_results_from_sfqid if asynchronous) through the existing fetch*() methods.

**Bug Fixes**

- Fixed a bug where the permission of the file downloaded via GET command is changed.

Released to [PyPI](https://pypi.org/project/snowflake-connector-python/#files) on December 14, 2022

- Bumped cryptography dependency from <39.0.0 to <41.0.0
- Fixed a bug where expired OCSP response cache caused infinite recursion during cache loading

- Improved performance of OCSP response caching
- During the execution of GET commands we no longer resolve target location on the local machine
- 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
- Bumped pandas dependency from <1.5.0 to <1.6.0
- Fixed a bug where write_pandas wouldn't write an empty DataFrame to Snowflake
- When closing connection async query status checking is now parallelized
- Fixed a bug where test logging would be enabled on Jenkins workers in non-Snowflake Jenkins machines
- Enhanced the atomicity of write_pandas when overwrite is set to True