Connection to Snowflake - JDBC error

[Saravanan1]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Saravanan1]

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

[Anonymous]

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

 

[manish19]

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

[manodwhb]

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

[Anonymous]

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

[Anonymous]

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

[manodwhb]

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

[Anonymous]

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.