Connection error to Snowflake in Talend BigData platform

[rahulp]

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.

[manodwhb]

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

Thanks,

Manohar

[manodwhb]

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

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

Thanks,

Manohar

[rahulp]

@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

[manodwhb]

@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?

[rahulp]

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

[manodwhb]

@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

[Anonymous]

Hello,

Here is online documentation about: TalendHelpCenter: Installing external modules

Hope it helps.

Best regards

Sabrina

[rahulp]

@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

[manodwhb]

@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