What is the latest version of snowflake-jdbc jar supported by Talend Open Studio Version: 7.2.1

[SKhan122]

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/v1

After upgrade connection string:

https://xyzaccount.snowflakecomputing.com:443/session/v1

We 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?

[Anonymous]

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

[since_1995]

How can I upgrade the JDBC driver of snowflake component in Talend

[Anonymous]

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

[SKhan122]

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

[Anonymous]

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

[SKhan122]

@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

[SKhan122]

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

[Anonymous]

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

[SKhan122]

Hi Sabrina,

Wanted to check if you found anything on this.

Thanks,

Sabir