Snowflake connector.connect中断，并显示一条错误消息，但没有任何提示

Question

我通过命令pip3 install snowflake-connector-python[pandas]==2.3.3 asn1crypto==1.3.0 --user安装了snowflake连接器

我尝试通过以下方式连接：

from snowflake import connector

        con = connector.connect(
                  host='.snowflakecomputing.com',
                  user='THE USER I USE FOR LOGGING IN TO MY TRIAL ACCOUNT',
                  password='THE PASSWORD I USE FOR LOGGING IN TO MY TRIAL ACCOUNT',
                  account='zka81761.us-east-1',
                  warehouse='COMPUTE_WH',
                  database='DEMO_DB',
                  schema='PUBLIC',
                  protocol='https',
                  port=443)

当执行上面的代码时，它挂起了几分钟，然后我得到了一个错误：

snowflake.connector.errors.OperationalError: 250003: Failed to execute request: encoding with 'idna' codec failed (UnicodeError: label empty or too long)

较长的版本为：

  File "tests/integration_tests/data_sources/test_snowflake_ds.py", line 6, in test_snowflake_ds
    ds = SnowflakeDS(query='SELECT * FROM HEALTHCARE_COSTS', host='.snowflakecomputing.com', user='GEORGE3D6', password='a passwordd', account='zka81761.us-east-1', warehouse='COMPUTE_WH', database='DEMO_DB', schema='PUBLIC', protocol='https', port=443)
  File "/home/george/mindsdb_native/mindsdb_native/libs/data_types/data_source.py", line 13, in __init__
    df, col_map = self._setup(*args, **kwargs)
  File "/home/george/mindsdb_native/mindsdb_native/libs/data_sources/snowflake_ds.py", line 21, in _setup
    port=port)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/__init__.py", line 52, in Connect
    return SnowflakeConnection(**kwargs)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/connection.py", line 219, in __init__
    self.connect(**kwargs)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/connection.py", line 414, in connect
    self.__open_connection()
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/connection.py", line 613, in __open_connection
    self._authenticate(auth_instance)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/connection.py", line 839, in _authenticate
    self.__authenticate(self.__preprocess_auth_instance(auth_instance))
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/connection.py", line 869, in __authenticate
    session_parameters=self._session_parameters,
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/auth.py", line 209, in authenticate
    socket_timeout=self._rest._connection.login_timeout)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/network.py", line 509, in _post_request
    _include_retry_params=_include_retry_params)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/network.py", line 586, in fetch
    **kwargs)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/network.py", line 676, in _request_exec_wrapper
    conn, full_url, cause)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/network.py", line 706, in handle_invalid_certificate_error
    'errno': ER_FAILED_TO_REQUEST,
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/errors.py", line 128, in errorhandler_wrapper
    connection.errorhandler(connection, cursor, error_class, error_value)
  File "/home/george/.local/lib/python3.7/site-packages/snowflake/connector/errors.py", line 90, in default_errorhandler
    done_format_msg=error_value.get('done_format_msg'))
snowflake.connector.errors.OperationalError: 250003: Failed to execute request: encoding with 'idna' codec failed (UnicodeError: label empty or too long)

此错误消息不会告诉我任何信息，任何帮助都会显示出来

Answer 1

根据python API上的documentation，不再使用host字段，因此请尝试删除它。此外，即使使用了它，也没有正确地用引号将其括起来：

你有：host='.snowflakecomputing.com,

应为：host='.snowflakecomputing.com',

首先，我会看看删除主机是否完全解决了您的问题，因为无论如何都不应该使用它。

谷歌错误，以及错误消息本身，表明问题是由于URL太长，所以我想说错误是由于您没有正确地将其括起来。

Answer 2

我过去常常从python连接snowflake，如下所示：

​

import snowflake.connector as sf

sfconnection = sf.connect(
                user='THE USER I USE FOR LOGGING IN TO MY TRIAL ACCOUNT',
                password='THE PASSWORD I USE FOR LOGGING IN TO MY TRIAL ACCOUNT',
                account='zka81761.us-east-1',
                warehouse='COMPUTE_WH',
                database='DEMO_DB',
                schema='PUBLIC')

​

Answer 3

显然，文档是错误的，host现在应该是完整的URL (所以，在我的例子中是zka81761.us-east-1.snowflakecomputing.com)。也就是说，它应该包括account。