Unable to connect Snowflake

[jenn3]

Hello,

I have a problem accessing Snowflake data.

When I create a Snowflake metadata and test the connection, everything is OK.

I visualize the tables of my database.

However, the setting cannot be saved ("Failed to save").

Can you help me please ?

[Anonymous]

Can you tell us.....

Which version you are using (Free or licensed/subscription)?,

Have you taken any patches?

What operating system you are running it on?

What version of Java you are using?

Also, as an attempt at a quick fix, can you back up for your work by exporting it to a zip file. Shutdown Studio. Then go to the Studio folder, cut the workspace folder and move it somewhere else. Then create a new workspace folder in its place. Then restart Studio and import your backup. After that, try this again.

[Charly1]

Hello,

I got the same issue here

When I try to add Snowflake on my metadata :

• Test connexion : OK
• Listing tables : OK
• Retriveve collumns from a selected table : KO

If i look into Snowflake logs, all command from talend finished in succeed statut

The only problem I see is Snowflake which tells me that the JDBC version is unsupported (despite than the 2 first steps finished without any problem)

OS : Windows Serveur 2019

Talend version : TOS Talend 7.0.1 (Free)

[Anonymous]

Hello,

Could you please let us know the snowflake jar which you are using and also check the same connection to see if it is working fine outside of Talend?

Best regards

Sabrina

[Charly1]

Hello,

Thanks for your help

My Snowflake JAR : snowflake-jdbc-3.5.3.jar

No problem with the same login on DBeaver (Connexion, listing, select)

Best regards

Charly

[Anonymous]

What version of Java are you using?

[Anonymous]

Hello,

With your V 7.0.1 studio, are you using JDK 1.8?

We met this issue before and the root cause was a user installed wrong JDK version.

Please ensure proper version of JDK is installed. For v6 of Talend products JDKv1.8 is required instead of JRE.

You should post the studio log file. You will find it here: <studio-root>/configuration/XXXX.log

and the workspace log file: <workspace-root>/.metadata/.log

Best regards

Sabrina

[jenn3]

I use Talend Open Studio 8.0.1 on Windows x64.

I have jdk-18.0.2.1

I tried your suggestion to export in zip format... But without success

[Charly1]

Hello,

Today report :

I switch to JDK1.8 instead of JRE1.8

Same isues when I try to retrieve table schemas (from metadata or from any snowflake module input/ouput)

I try a manual query with a built-in schema : thats work!

I upgrade my jdbc to JDBC 3.13.6, manual query still work, retrieve schema still crash

In snowflake log my manual query use JDBC 3.13.6 but when i try to add snowflake in metadata i saw JDBC 3.5.3 query on log with this sql (statut of the query : ok) :

"show /* JDBC:DatabaseMetaData.getColumns() */ columns in schema "DB"."SCHEMA""

I dont see anything on both log at the timestamp of the crash :'(

Any new ideas ?

[Anonymous]

You should be using v11 of the Java jdk. v18 isn't supported for TOS at the moment. That may not be issue here, but it also could be.