SNOW-452575: Replace pyopenssl with python's default ssl implementation

[thomasaarholt]

What is the current behavior?

snowflake-connector-python will not run on M1 Macs (Silicon, Arm processor): See #799 and dbt-labs/dbt#3722.
That error is due to pyca/pyopenssl#873. This comment implies that a fix will not be forthcoming, and that it would be better to swap out the relevant pyopenssl functionality for Python's built-in SSL library. Would this be possible?

What is the desired behavior?

A functioning snowflake-connector-python on M1 macs.

How would this improve snowflake-connector-python?

Macs are heavily used in the data science world. At the moment, one has to run dbt through the rosetta emulator in order to run it on Mac, which makes it very difficult for non-technical users to use snowflake-connector-python or one of its dependants. One currently either has to install brew in rosetta and then dbt in that, or miniconda in rosetta and dbt in that).

[sfc-gh-hkapre]

@thomasaarholt This is not currently possible due to our use of OCSP. We are starting to look into what will be needed to support M1 and will provide an update once we have completed our analysis.

[sfc-gh-mkeller]

Same thing as in #799 (comment)
Please reach out if the issue still persists for some reason!

[sucre1990]

this issue still exists and anyone has a solution yet? It is a blocker for me.

[jpzhangvincent]

Ya using "snowflake-connector" on Mac M1 is really challenging . Is it possible to remove the "pyopenssl" dependencies?

[leifericf]

This is a blocker for me (on behalf of Elkjøp Nordic's data science team, a large enterprise Snowflake customer), and I would appreciate a solution sooner rather than later. Can someone at Snowflake give us an update, please?

@sfc-gh-mkeller, please reopen this issue.

[sfc-gh-achandrasekaran]

Please follow this workaround on M1 machines