I am trying to set up a database connection to my Snowflake 30-day free trial account. The connection parameters are shown below. When I test the connection, it takes a long time (about 5 minutes), and then get a Read timeout error as shown below. I have no problem login to Snowflake web console using https://IN17188.us-east-2.aws.snowflakecomputing.com. I use the account "IN17188.us-east-2.aws" in the FME database connection Account Name parameter. I use FME Desktop 2021.1.1. Anybody experienced this issue? I just try to follow the FME - Snowflake tutorial - https://www.safe.com/training/recorded/connect-data-even-geospatial-snowflake/
net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to IN17188.us-east-2.aws.snowflakecomputing.com:443 [IN17188.us-east-2.aws.snowflakecomputing.com/3.20.44.68, IN17188.us-east-2.aws.snowflakecomputing.com/13.58.248.132, IN17188.us-east-2.aws.snowflakecomputing.com/3.13.181.210] failed: Read timed out.
at net.snowflake.client.jdbc.RestRequest.execute(RestRequest.java:284)
at net.snowflake.client.core.HttpUtil.executeRequestInternal(HttpUtil.java:493)
at net.snowflake.client.core.HttpUtil.executeRequest(HttpUtil.java:438)
at net.snowflake.client.core.HttpUtil.executeGeneralRequest(HttpUtil.java:405)
at net.snowflake.client.core.SessionUtil.newSession(SessionUtil.java:574)
.........
Best answer by steveatsafe
View original