resolves #331

Description

Bump to support Python 3.11 . Unfortunately Snowflake isn't planning to support wheels for this until 2023.

However, they are up for this: snowflakedb/snowflake-connector-python#1349

So it looks like it could come sooner than expected, hopefully :).

So to test this is a bit fiddly, you have a few options:

Option 1) Use my wheels
I've built the above PR, and I'm using the wheels locally. For dbt-snowflake you will need to edit setup.py and change snowflake-connector-python to the following:

"snowflake-connector-python[secure-local-storage] @ https://pub-06bff9b264344d5c807b16a2c12bf62d.r2.dev/snowflake_connector_python-2.9.0-cp311-cp311-linux_x86_64.whl",

Linux: https://pub-06bff9b264344d5c807b16a2c12bf62d.r2.dev/snowflake_connector_python-2.9.0-cp311-cp311-linux_x86_64.whl
Mac: https://pub-06bff9b264344d5c807b16a2c12bf62d.r2.dev/snowflake_connector_python-2.8.3-cp311-cp311-macosx_12_0_arm64.whl

Not sure why these versions are different 🤷

Option 2) Use that branch and build your wheels
If you are on Linux, you can use that branch above:

git clone https://github.com/snowflakedb/snowflake-connector-python
cd snowflake-connector-python
git fetch origin pull/1349/head:feature/3.11 # check out the branch
git checkout feature/3.11

Now you have a few options:

1. Build the wheel using docker (probably easiest)
2. Install arrow dependencies and try your luck :)

Docker: ./ci/build_docker.sh 3.11
Shell (Mac): ./ci/build_darwin.sh 3.11
Shell (Linux): ./ci/build_linux.sh 3.11 # Note this didn't work for me, it's designed for their CI environment

If using a mac and you want to build wheels, you're going to want to brew install apache-arrow if using homebrew to grab the latest 10.0.0-1 which supports Python 3.11.

Checklist

• I have read the contributing guide and understand what's expected of me
• I have signed the CLA
• I have run this code in development and it appears to resolve the stated issue
• This PR includes tests, or tests are not required/relevant for this PR
• I have opened an issue to add/update docs, or docs changes are not required/relevant for this PR
• I have run changie new to create a changelog entry