connection error to snowflake null response for request post

[Anonymous]

I used the Snowflake component to connect to the snowflake. The test connection was successful and I could get the tables. but when I wanted to use 't snowflake output' to insert a simple CSV file to snowflake table it raised an error: Null response for request=POST, Connection timed out

I also increased the time out for the connection from 30 to 120 but no difference, keep getting a 'null response for request post' 

[WARN ]: net.snowflake.client.jdbc.RestRequest - Null response for request=POST.................HTTP/1.1

[WARN ]: net.snowflake.client.jdbc.RestRequest - Exception encountered for: POST.................. HTTP/1.1
net.snowflake.client.jdbc.internal.apache.http.conn.HttpHostConnectException: Connect to s.eu-west-1.snowflakecomputing.com:443 [s.eu-west-1.snowflakecomputing.com/34.247.247.75, s.eu-west-1.snowflakecomputing.com/52.30.85.75, s.eu-west-1.snowflakecomputing.com/52.209.170.35] failed: Connection timed out: connect
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:159)
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.PoolingHttpClientConnectionManager.connect(PoolingHttpClientConnectionManager.java:373)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.MainClientExec.establishRoute(MainClientExec.java:381)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.MainClientExec.execute(MainClientExec.java:237)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.ProtocolExec.execute(ProtocolExec.java:185)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RetryExec.execute(RetryExec.java:89)
at net.snowflake.client.jdbc.internal.apache.http.impl.execchain.RedirectExec.execute(RedirectExec.java:111)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.InternalHttpClient.doExecute(InternalHttpClient.java:185)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:83)
at net.snowflake.client.jdbc.internal.apache.http.impl.client.CloseableHttpClient.execute(CloseableHttpClient.java:108)
at net.snowflake.client.jdbc.RestRequest.execute(RestRequest.java:164)
at net.snowflake.client.core.HttpUtil.executeRequestInternal(HttpUtil.java:369)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:318)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:290)
at net.snowflake.client.core.SessionUtil.newSession(SessionUtil.java:1257)
at net.snowflake.client.core.SessionUtil.openSession(SessionUtil.java:853)
at net.snowflake.client.core.SFSession.open(SFSession.java:396)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.<init>(SnowflakeConnectionV1.java:143)
at net.snowflake.client.jdbc.SnowflakeDriver.connect(SnowflakeDriver.java:331)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.talend.components.snowflake.runtime.utils.DriverManagerUtils.getConnection(DriverManagerUtils.java:34)
at org.talend.components.snowflake.runtime.SnowflakeRuntime.createConnection(SnowflakeRuntime.java:84)
at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.validate(SnowflakeSourceOrSink.java:72)
at org.talend.components.snowflake.runtime.SnowflakeSink.validate(SnowflakeSink.java:41)
at local_project.loaddata_0_1.loadData.tFileInputDelimited_1Process(loadData.java:1306)
at local_project.loaddata_0_1.loadData.runJobInTOS(loadData.java:2304)
at local_project.loaddata_0_1.loadData.main(loadData.java:2153)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at net.snowflake.client.jdbc.internal.apache.http.conn.ssl.SSLConnectionSocketFactory.connectSocket(SSLConnectionSocketFactory.java:339)
at net.snowflake.client.jdbc.internal.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect(DefaultHttpClientConnectionOperator.java:142)
... 27 more
[WARN ]: net.snowflake.client.jdbc.RestRequest - Null response for request=POST............................HTTP/1.1
[ERROR]: net.snowflake.client.jdbc.RestRequest - Stop retrying since elapsed time due to network issues has reached timeout. Elapsed=126071 milliseconds, timeout=30 seconds
Exception in component tDBOutput_1 (loadData)
java.lang.RuntimeException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to s.eu-west-1.snowflakecomputing.com:443 [s.eu-west-1.snowflakecomputing.com/34.247.247.75, s.eu-west-1.snowflakecomputing.com/52.30.85.75, s.eu-west-1.snowflakecomputing.com/52.209.170.35] failed: Connection timed out: connect.
at local_project.loaddata_0_1.loadData.tFileInputDelimited_1Process(loadData.java:1308)
at local_project.loaddata_0_1.loadData.runJobInTOS(loadData.java:2304)
at local_project.loaddata_0_1.loadData.main(loadData.java:2153)
[statistics] disconnected

[Anonymous]

Hello,

Could you please check if the connection port number is enabled.(port no:443)?

Best regards

Sabrina