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,

Sorry for our late. So far, there is no such a component in talend.

Feel free to create a new feature jira issue on talend bug tracker.

Best regards

Sabrina