
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the latest version of snowflake-jdbc jar supported by Talend Open Studio Version: 7.2.1
Our project is based on Snowflake and Talend Open Studio 7.2.1, and Snowflake JDBC driver is used for the connectivity requirements.
Following are the JDBC driver and associated Talend component details.
- Snowflake-jdbc-3.12.11.jar
- components-snowflake-definition version 0.28.9
- components-snowflake-runtime version 0.28.9
We tried to upgrade Snowflake JDBC driver to newer versions such as 3.12.17/ 3.13.6
with the latest version of components-snowflake-definition and components-snowflake-runtime, 0.33.0
After the upgrade getting below error,
“java.lang.RuntimeException: JDBC driver encountered communication error. Message: HTTP status=403.Incorrect Snowflake Account was specified“ in tSnowflakeconnection step.
As per our analysis snowflake region is missing in the connection string post JDBC upgrade.
For e.g.
Before upgrade connection string :
https://xyzaccount.xyzregion.snowflakecomputing.com:443/session/v1After upgrade connection string:
https://xyzaccount.snowflakecomputing.com:443/session/v1We are searching for more details around compatibility between latest Snowflake JDBC drivers and Talend provided components such as components-snowflake-definition and components-snowflake-runtime
Can you please share any details on the upgrade path already implemented for Snowflake and Talend connectivity?
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
You can connect to Snowflake (via Talend) by using a JDBC connector, as JDBC connector is using the latest JDBC driver for Snowflake which resolves the OSCP issue.
We have upgrade snowflake JDBC driver to 3.11.X since V 7.3.1
The version of Snowflake JDBC driver in V 7.3.1 is snowflake-jdbc-3.11.1
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How can I upgrade the JDBC driver of snowflake component in Talend

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
The source code of component is located in <studio installation directory>\plugins\org.talend.designer.components.localprovider_7.3.1.x.xx.x\components. Back up the component folder and have a try to modify an existing component. This could very well lead to errors.
It is recommended that you should upgrade to v8 and you will get snowflake-jdbc/3.13.1/jar
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sabrina,
Thanks for the information.
As you mentioned Talend V7.2.1 will not support Snowflake JDBC 3.13.x., so I tried upgrading to Talend V8 which has snowflake jdbc 3.13.1 by default.
My code uses tSQLScriptParser custom component extensively and It looks like tSQLScriptParser is not compatible with Talend V8.
So could you please provide any help on this.
Thanks,
Sabir

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello @Sabir Khan
As tSQLScriptParser is a custom component and written by talend community user, we don't have the source code of these components. It is the ownership of the person who built it.
Please feel free to contact the author directly.
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Ying Li
We are trying to upgrade talend from V7.2.1 to V8.
Our code uses tSQLScriptParser custom component extensively and It looks like tSQLScriptParser is not compatible with Talend V8.
Could you please provide any help on this.
Thanks,
Sabir

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sabrina,
Is there any core Talend component which can be used in place of tSQLScriptParser. The component should be able to read a .sql file containing multiple sql statements and execute them iteratively.
Thanks,
Sabir

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
I will make an investigation on this custom tSQLScriptParser to see if there is any alternative solution in talend and then come back to you as soon as possible.
Best regards
Sabrina

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sabrina,
Wanted to check if you found anything on this.
Thanks,
Sabir

- « Previous Replies
-
- 1
- 2
- Next Replies »