Four Stars

Connection to Snowflake - JDBC error

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

3 REPLIES
Moderator

Re: Connection to Snowflake - JDBC error

Hello,

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

1.png

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Connection to Snowflake - JDBC error

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

 

 

 

Moderator

Re: Connection to Snowflake - JDBC error

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.