topic Re: Snowflake connection issue in Talend Studio

Snowflake connection issue

Anonymous — Sat, 16 Nov 2024 06:09:21 GMT

Hi,

I have created a connection to snowflake account in repository and it connects successfully with DB. But the same connection component throws a run time error in the job. Below is the error message, also attaching the error log file.

Thanks in advance!

"java.net.UnknownHostException: This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server (myaccount.snowflakecomputing.com)"

Re: Snowflake connection issue

manodwhb — Thu, 04 Apr 2019 10:45:09 GMT

@navali ,it could be your network connection was blocking to connect to that snowflake db. why cannot try with other network?

Re: Snowflake connection issue

Anonymous — Thu, 04 Apr 2019 16:07:01 GMT

@manodwhb It doesn't look like that, I can connect to DB from repository and since it is a office network, we don't have other network.

Re: Snowflake connection issue

manodwhb — Fri, 05 Apr 2019 05:05:13 GMT

@navali ,i have faced same issue i was able to connect in metadata connection but when i used to execute the job has failed in from office location,so that i have tested same thing from my home network it has executed successfully. Since I understand that it was because of network.

you need check with your network team to make connection between from your office network to snowflake DB.

Re: Snowflake connection issue

Anonymous — Fri, 05 Apr 2019 06:51:20 GMT

@manodwhb Okay, Let me check. Thank you!