Hello,
I’m getting this error when I try to run a workflow involving a Snowflake connector on Knime Business hub:
ERROR Snowflake Connector 3:77: Execute failed: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to … failed: Connect timed out.
Does anyone please have an idea on how to fix this error? Thanks
The error is pointing to a connection/timeout issue. You can confirm if snowflake is being blocked from KBH by running this command:
kubectl exec -it <executor-pod> – curl -v https://<your_account>.snowflakecomputing.com
If it doesn’t work, the standard connection simply can’t be established, which could be internet access, firewall, any other security blocks.
If it does work, then you can investigate proxy, TLS/certificates, among other things.
You can also test connectivity between KBH and Snowflake however you would like, and that can help find the root cause. (Just make sure you’re trying to connect to snowflake from the executor pod that’s actually running the workflows)