Connecting to Snowflake Questions


#1

Issue Summary

I’ve installed the connector and enabled the query runner, but I can’t connect.

Technical details:

  • Redash Version: 5.0.0
  • Browser/OS: Chrome on Mac
  • How did you install Redash:
    • Docker-compose on Mac, with the docker-compose.production.yml configuration.
    • Built a local Docker Image called redash:with_snowflake. I uncommented the Snowflake connector in the requirements_all_ds.txt file.
    • Updated docker-compose.production.yml to (a) use my custom local image, and (b) set the REDASH_ADDITIONAL_QUERY_RUNNERS environment variable on both the server and the worker.

Issue Detail

When I put in my connection credentials and test my connection, it can’t connect, and outputs this:

server_1    | [2018-10-10 20:34:44,043][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTPS connection (1): <my snowflake instance>.snowflakecomputing.com
server_1    | [2018-10-10 20:34:44,214][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1    | [2018-10-10 20:34:44,218][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1    | [2018-10-10 20:34:44,221][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.netsolssl.com
server_1    | [2018-10-10 20:34:44,268][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com

[~300 repeated messages]

server_1    | [2018-10-10 20:34:47,721][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1    | [2018-10-10 20:34:47,745][PID:16][INFO][botocore.vendored.requests.packages.urllib3.connectionpool] Starting new HTTP connection (1): ocsp.usertrust.com
server_1    | Exception in thread RequestExec-0:
server_1    | Traceback (most recent call last):
server_1    |   File "/usr/lib/python2.7/threading.py", line 801, in __bootstrap_inner
server_1    |     self.run()
server_1    |   File "/usr/lib/python2.7/threading.py", line 754, in run
server_1    |     self.__target(*self.__args, **self.__kwargs)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/network.py", line 704, in request_exec
server_1    |     auth=SnowflakeAuth(token),
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/sessions.py", line 465, in request
server_1    |     resp = self.send(prep, **send_kwargs)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/sessions.py", line 573, in send
server_1    |     r = adapter.send(request, **kwargs)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/adapters.py", line 370, in send
server_1    |     timeout=timeout
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 544, in urlopen
server_1    |     body=body, headers=headers)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 341, in _make_request
server_1    |     self._validate_conn(conn)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connectionpool.py", line 761, in _validate_conn
server_1    |     conn.connect()
server_1    |   File "/usr/local/lib/python2.7/dist-packages/botocore/vendored/requests/packages/urllib3/connection.py", line 238, in connect
server_1    |     ssl_version=resolved_ssl_version)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/ssl_wrap_socket.py", line 483, in ssl_wrap_socket_with_ocsp
server_1    |     ).validate(server_hostname, ret.connection)
server_1    |   File "/usr/local/lib/python2.7/dist-packages/snowflake/connector/ocsp_pyopenssl.py", line 1103, in validate
server_1    |     u'hostname={0}, err={1}', hostname, r.get()))
server_1    |   File "/usr/lib/python2.7/multiprocessing/pool.py", line 567, in get
server_1    |     raise self._value
server_1    | PyAsn1Error: Attempted "__eq__" operation on ASN.1 schema object
server_1    |

#2

Try installing newer version of the Snowfalke connector. The latest seems to be 1.6.10.


#3

That did the trick. Thanks!


#4

Thanks for the follow up! I will update the reqs file.