topic Re: Connection to Snowflake - JDBC error in Talend Studio

Connection to Snowflake - JDBC error

Saravanan1 — Tue, 27 Jun 2017 13:28:24 GMT

Hi,

I am trying to connect to Snowflake account from Talend Open Studio for Data Integration

Get the below exception.

Error: Exception in component tSnowflakeConnection_1 (Snowflake_test)
java.lang.RuntimeException: java.sql.SQLException: No suitable driver found for jdbc:snowflake://https:URL...

Downloaded the JDBC driver (version - 3.0.21) from https://repo1.maven.org/maven2/net/snowflake/snowflake-jdbc/3.0.21/

The jar file does not gets installed on Windows 10.

Error: no main manifest attribute, in snowflake-jdbc-3.0.21.jar

Could some one assist to resolve this? Thanks in advance.

Regards

Saravanan

Re: Connection to Snowflake - JDBC error

Anonymous — Mon, 03 Jul 2017 08:05:09 GMT

Hello,

Did you follow up document about:TalendHelpCenter:Installing external modules to install required jar file?

Best regards

Sabrina

Re: Connection to Snowflake - JDBC error

Saravanan1 — Wed, 05 Jul 2017 12:16:58 GMT

Hi,

Thank you for the response. Did try installing the jar files earlier, but had no luck.

The issue was due to the "Account" was not provided in the expected format in tSnowflake connection. The Account should NOT be a full URL - https://myaccount.snowflakecomputing.com, instead should be "myaccount".

Correcting this resolved the issue and I am now able to connnect to my Snowflake account.

Thanks

Re: Connection to Snowflake - JDBC error

Anonymous — Thu, 06 Jul 2017 07:08:08 GMT

Hello,

Thanks for posting your solution here. Please mark this topic as resolved. This way, other users will be informed that this thread has been resolved.

Many thanks

Best regards

Sabrina

Re: Connection to Snowflake - JDBC error

manish19 — Sat, 11 Apr 2020 13:16:22 GMT

I new to Talend but trting to connect my snowflake trail account with Talend. At the creating new connection from metadata for Snowflake it is showing me error while connecting. After just changing account name as talend it is showing me wrong id pass, which is not.

Error : JDBC driver encountered communication error . Message: HTTP status 403

Kindly help to resolve this issue. or suggest me some solution.

Capture.JPG

Re: Connection to Snowflake - JDBC error

manodwhb — Sat, 11 Apr 2020 15:23:31 GMT

Your account name is not correct which you need to take from the snowflake URL.

Check the below link how to know account name and which you need to provide.
https://docs.snowflake.com/en/user-guide/connecting.html

Re: Connection to Snowflake - JDBC error

Anonymous — Thu, 25 Jun 2020 14:53:32 GMT

While trying to connect from Talend Studio (DI 7.0.1 or 7.2.1) to snowflake Trial account, encountering errors. I am able to see with same credentials Talend Cloud trial account (talend pipeline) connection to snowflake is successful. Strange !! Any settings / whitelisting / proxy settings need to be done which I am missing from studio ? Please suggest. My snowflake account is : .ap-southeast-2.snowflakecomputing dot com I am using account : account id username: snowflake user name used to login to account pwd: snowflake account pwd, Talend DI Open studio 7.2.1 connectivity to Snowflake Account Fails
snowflake_talend_error.jpg

Re: Connection to Snowflake - JDBC error

Anonymous — Fri, 26 Jun 2020 06:12:39 GMT

Hi @manodwhb , do you have any clue about the issue I am facing. I got it tested (same credentials) from Talend Enterprise, connecting success.

Re: Connection to Snowflake - JDBC error

manodwhb — Fri, 26 Jun 2020 08:06:55 GMT

@snayak, can you share both screenshots of configuration from Talend enterprise and open studio?

Re: Connection to Snowflake - JDBC error

Anonymous — Sun, 28 Jun 2020 07:05:52 GMT

Hi, Error screenshot provided on my first post. I tried both using TOS DI 701 and 721 , same error. I had installed the driver with snowflake component so no prompt for driver coming at component level atleast. Is there any post 443 settings need to be done anywhere or whitelisting ? because I remember when I connected from Stitch Data Loader, same setup worked fine except the fact that stitch automatically got some 3-4 IP address whitelisted by it self to snowflake trial account as target connection.

Re: Connection to Snowflake - JDBC error

Anonymous — Sun, 28 Jun 2020 07:05:52 GMT