Curreently wnen you run snowflke provider, it monkeypatches urlllb in a way that is not compatible with other libraries (for example presto SSL with kerberos, google,  amazon, qubole and many others).

This is not critical (as in 2.0 we have provider separation and snowflake code will not even be there until you choose [snowflake] extra or install provider manually,

For now we decided to release but immediately yank the snowflake provider!

Additional links: 

* Issue: https://github.com/snowflakedb/snowflake-connector-python/issues/324

Offending code:

* https://github.com/snowflakedb/snowflake-connector-python/blob/133d6215f7920d304c5f2d466bae38127c1b836d/src/snowflake/connector/network.py#L89-L92


tests/providers/presto/hooks/test_presto.py
@pytest.mark.integration("presto")
    @mock.patch.dict('os.environ', AIRFLOW_CONN_PRESTO_DEFAULT="presto://airflow@presto:8080/")
    def test_should_record_records(self):
        hook = PrestoHook()
        sql = "SELECT name FROM tpch.sf1.customer ORDER BY custkey ASC LIMIT 3"
        records = hook.get_records(sql)
        self.assertEqual([['Customer#000000001'], ['Customer#000000002'], ['Customer#000000003']], records)
    @pytest.mark.xfail(
        condition=True,
        reason="""
This test will fail when full suite of tests are run, because of Snowflake monkeypatching urllib3
library as described in https://github.com/snowflakedb/snowflake-connector-python/issues/324
the offending code is here:
https://github.com/snowflakedb/snowflake-connector-python/blob/133d6215f7920d304c5f2d466bae38127c1b836d/src/snowflake/connector/network.py#L89-L92
This test however runs fine when run in total isolation. We could move it to Heisentests, but then we would
have to enable integrations there and make sure no snowflake gets imported.
In the future Snowflake plans to get rid of the MonkeyPatching.
Issue to keep track of it: https://github.com/apache/airflow/issues/12881
""",
    )
    @pytest.mark.integration("presto")
    @pytest.mark.integration("kerberos")
    def test_should_record_records_with_kerberos_auth(self):