topic Re: Connection error to Snowflake in Talend BigData platform in Talend Studio

Connection error to Snowflake in Talend BigData platform

rahulp — Sat, 16 Nov 2024 01:30:37 GMT

Hi,

While creating Snowflake connection on Open Studio for Big Data, I'm getting below error.

net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Messsage: Exception encountered for HTTP request:No trusted certificate found.

What might be causing this error, any help appreciated a lot.

Re: Connection error to Snowflake in Talend BigData platform

manodwhb — Wed, 09 Sep 2020 12:40:28 GMT

@Rahul Pokharia ,could you please share how are you connecting to snowflake ?

Thanks,

Manohar

Re: Connection error to Snowflake in Talend BigData platform

manodwhb — Wed, 09 Sep 2020 12:43:17 GMT

@Rahul Pokharia ,check the below case how to connect to snowflake from Talend.

https://community.talend.com/s/feed/0D53p00007vCjH9CAK

Thanks,

Manohar

Re: Connection error to Snowflake in Talend BigData platform

rahulp — Wed, 09 Sep 2020 13:01:02 GMT

@Manohar B , i have checked the above case but the issue is not related to port. I'm, not even able to create a connection.

Thanks

Rahul

Re: Connection error to Snowflake in Talend BigData platform

manodwhb — Wed, 09 Sep 2020 13:04:42 GMT

@Rahul Pokharia , when you just drag tSnowflakeconnection component to job are you able to see red color bauble and asking for any jars to import?

Re: Connection error to Snowflake in Talend BigData platform

rahulp — Wed, 09 Sep 2020 13:09:03 GMT

@Manohar B , i'm connecting with Snowflake for the first time . The error comes up while creating a connection itself.

Re: Connection error to Snowflake in Talend BigData platform

manodwhb — Wed, 09 Sep 2020 13:12:21 GMT

@Rahul Pokharia , I Understand that , you create a job and drag tSnowflakeconnection from pallet to job and then check component tab and install the external jars and then try to create a connection from repository.

Thanks,

Manohar

Re: Connection error to Snowflake in Talend BigData platform

Anonymous — Thu, 10 Sep 2020 07:16:28 GMT

Hello,

Here is online documentation about: TalendHelpCenter: Installing external modules

Hope it helps.

Best regards

Sabrina

Re: Connection error to Snowflake in Talend BigData platform

rahulp — Thu, 10 Sep 2020 08:02:58 GMT

@Xiaodi Shi I followed the above link but i'm getting network unavailable error.Could you please help me on this as I'm quite new to talend.

Thanks

Rahul

Re: Connection error to Snowflake in Talend BigData platform

manodwhb — Thu, 10 Sep 2020 08:10:38 GMT

@Rahul Pokharia ,which is external jar which you need to download from the below link to your local system and then you need to choose there then the download and install module will be enabled and then click on it.

https://talend-update.talend.com/nexus/content/repositories/libraries/net/snowflake/snowflake-jdbc/

Thanks,

Manohar

Re: Connection error to Snowflake in Talend BigData platform

Anonymous — Fri, 11 Sep 2020 05:46:45 GMT

Hello,

Please make sure your Talend Studio has a secure Internet connection.

If you are working behind a network proxy, make sure you have correctly set up your proxy and add the web site http://talend-update.talend.com and the port 443 to your whitelist.

Best regards

Sabrina