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.
Did you follow up document about:TalendHelpCenter:Installing external modules to install required jar file?
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 for posting your solution here. Please mark this topic as resolved. This way, other users will be informed that this thread has been resolved.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.