Snowflake - JDBC error for long running query

KNIME Analytics Platform
,
1

Dear experts,

I have an issue with a long running on Snowflake via Knime.

I can connect without problems and query Snowflake but if the query runs approx. more than 5 minutes, I receive an error:

Execute failed: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: ….snowflakecomputing.com:443 failed to respond.

On Snowflake directly, the query is running and takes about 7 minutes.

I have experimented with JDBC parameters (CLIENT_SESSION_KEEP_ALIVE, CLIENT_SESSION_KEEP_ALIVE_HEARTBEAT_FREQUENCY), with setting parameters (ALTER SESSION SET STATEMENT_TIMEOUT_IN_SECONDS = 7200) and with advances settings (“Automatically reconnect to DB” and “Restore database connection”). Nothing helps so far.

STATEMENT_TIMEOUT_IN_SECONDS is default 2 days.

Colleagues assume this to be a Firewall issue? Could this be? Or could a Knime setting help?

2

I dont know if this helps:

JDBC Snowflake Driver Timeout

3

Thanks for your answer Andi. This did unfortunately not solve the issue.

I set this in JDBC parameters to a high value. That would be the approach?

4

I have set http_client_socket_timeout_in_ms to 10,000 now, which would then lead to a “timeout” after 10s. But that’s not happening. Still fails after 5 minutes. Means the setting is not considered at all?

5

Hi @ChrisRB are you able to access the snowflake query history on Snowsight. This should show the status for each query and might give some clues about what is happening.