topic Re: Unable to connect Snowflake in Talend Studio

Unable to connect Snowflake

jenn3 — Fri, 15 Nov 2024 22:32:32 GMT

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 ?

Re: Unable to connect Snowflake

Anonymous — Tue, 20 Sep 2022 14:14:51 GMT

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.

Re: Unable to connect Snowflake

Charly1 — Tue, 20 Sep 2022 14:55:14 GMT

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)

Re: Unable to connect Snowflake

Anonymous — Wed, 21 Sep 2022 02:37:32 GMT

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

Re: Unable to connect Snowflake

Charly1 — Wed, 21 Sep 2022 11:30:13 GMT

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

Re: Unable to connect Snowflake

Anonymous — Wed, 21 Sep 2022 20:24:33 GMT

What version of Java are you using?

Re: Unable to connect Snowflake

Anonymous — Thu, 22 Sep 2022 03:41:00 GMT

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

Re: Unable to connect Snowflake

jenn3 — Thu, 22 Sep 2022 08:29:58 GMT

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

Re: Unable to connect Snowflake

Charly1 — Thu, 22 Sep 2022 15:18:54 GMT

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 ?

Re: Unable to connect Snowflake

Anonymous — Thu, 22 Sep 2022 15:28:59 GMT

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.

Re: Unable to connect Snowflake

jenn3 — Thu, 22 Sep 2022 16:37:29 GMT

Now, I'm using Java jdk v11 but still the same error

Re: Unable to connect Snowflake

Anonymous — Thu, 22 Sep 2022 16:51:45 GMT

OK. This is strange. I am running this version and have no issue here at all. Never have. This is the reason I wanted to make sure you are running a fully supported environment. Can you go to your workspace folder, then go to the .metadata folder and add your log here for me to look at? Before you do this, take a quick look and make sure there is nothing private in there that you are not comfortable with sharing.

Re: Unable to connect Snowflake

Charly1 — Fri, 23 Sep 2022 11:51:27 GMT

I got this log :

Échec de la sauvegarde.

org.eclipse.core.runtime.CoreException: Error when saving the connection

at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:295)

at org.eclipse.core.internal.resources.Workspace.run(Workspace.java:2313)

at org.talend.repository.generic.ui.GenericConnWizard.createOrUpdateConnectionItem(GenericConnWizard.java:303)

at org.talend.repository.generic.ui.GenericConnWizard.performFinish(GenericConnWizard.java:258)

at org.eclipse.jface.wizard.WizardDialog.finishPressed(WizardDialog.java:853)

at org.eclipse.jface.wizard.WizardDialog.buttonPressed(WizardDialog.java:438)

at org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Dialog.java:619)

at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

at org.eclipse.jface.window.Window.runEventLoop(Window.java:832)

at org.eclipse.jface.window.Window.open(Window.java:808)

at org.talend.repository.generic.action.GenericAction.doRun(GenericAction.java:71)

at org.talend.repository.ui.actions.AContextualAction$2.run(AContextualAction.java:633)

at org.talend.repository.RepositoryWorkUnit.executeRun(RepositoryWorkUnit.java:99)

at org.talend.core.repository.model.AbstractRepositoryFactory.executeRepositoryWorkUnit(AbstractRepositoryFactory.java:258)

at org.talend.repository.localprovider.model.LocalRepositoryFactory.executeRepositoryWorkUnit(LocalRepositoryFactory.java:3420)

at org.talend.core.repository.model.ProxyRepositoryFactory.executeRepositoryWorkUnit(ProxyRepositoryFactory.java:2247)

at org.talend.repository.ui.actions.AContextualAction.run(AContextualAction.java:639)

at org.eclipse.jface.action.Action.runWithEvent(Action.java:519)

at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:595)

at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:511)

at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:420)

at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4353)

at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1061)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4172)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1151)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1032)

at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:148)

at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:636)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:579)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

at org.talend.rcp.intro.Application.start(Application.java:265)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:648)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:603)

at org.eclipse.equinox.launcher.Main.run(Main.java:1465)

Caused by: org.talend.daikon.exception.TalendRuntimeException: FAILED_INVOKE_METHOD:{class=org.talend.components.snowflake.SnowflakeTableListProperties, method=afterFormFinishMain}

at org.talend.daikon.properties.PropertiesDynamicMethodHelper.doInvoke(PropertiesDynamicMethodHelper.java:109)

at org.talend.daikon.properties.PropertiesDynamicMethodHelper.afterFormFinish(PropertiesDynamicMethodHelper.java:323)

at org.talend.daikon.properties.service.PropertiesServiceImpl.afterFormFinish(PropertiesServiceImpl.java:135)

at org.talend.components.api.service.internal.osgi.ComponentServiceOsgi.afterFormFinish(ComponentServiceOsgi.java:178)

at org.talend.repository.generic.ui.GenericConnWizard$1.run(GenericConnWizard.java:291)

... 51 more

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.talend.daikon.properties.PropertiesDynamicMethodHelper.doInvoke(PropertiesDynamicMethodHelper.java:105)

... 55 more

Caused by: org.talend.components.api.exception.ComponentException: UNEXPECTED_EXCEPTION

at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:57)

at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:47)

at org.talend.daikon.avro.AvroRegistry.inferSchema(AvroRegistry.java:154)

at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:230)

at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getEndpointSchema(SnowflakeSourceOrSink.java:205)

at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:200)

at org.talend.components.snowflake.SnowflakeTableListProperties.afterFormFinishMain(SnowflakeTableListProperties.java:89)

... 60 more

Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: Timeout waiting for the download of chunk #0(Total chunks: 1).

at net.snowflake.client.jdbc.SnowflakeChunkDownloader.getNextChunkToConsume(SnowflakeChunkDownloader.java:397)

at net.snowflake.client.core.SFResultSet.fetchNextRowUnsorted(SFResultSet.java:200)

at net.snowflake.client.core.SFResultSet.fetchNextRow(SFResultSet.java:156)

at net.snowflake.client.core.SFResultSet.next(SFResultSet.java:247)

at net.snowflake.client.jdbc.SnowflakeResultSetV1.next(SnowflakeResultSetV1.java:73)

at net.snowflake.client.jdbc.SnowflakeDatabaseMetaData$3.next(SnowflakeDatabaseMetaData.java:1531)

at org.talend.components.common.avro.JDBCAvroRegistry.inferSchemaResultSet(JDBCAvroRegistry.java:112)

at org.talend.components.common.avro.JDBCAvroRegistry$1.apply(JDBCAvroRegistry.java:55)

... 66 more

Re: Unable to connect Snowflake

Anonymous — Fri, 23 Sep 2022 13:50:24 GMT

Hi @Charly MEDINA,

I have been looking into this to see if I can recreate it. Unfortunately I cannot recreate this. However, I have found something that could provide a solution. If you take a look at this question in Community (https://community.talend.com/s/question/0D53p00007vCmYZCA0/save-failed-error-with-snowflake-metadata) you will see that the symptoms look pretty much the same and the user has provided a solution. Can you try this?

Re: Unable to connect Snowflake

jenn3 — Fri, 23 Sep 2022 14:44:15 GMT

This is my logs

Re: Unable to connect Snowflake

Anonymous — Fri, 23 Sep 2022 15:00:11 GMT

It says you are using java.version=18.0.2.1. Java 18 is not supported.

After changing your Java version to 11, can you try the solution suggested here?

https://community.talend.com/s/question/0D53p00007vCmYZCA0/save-failed-error-with-snowflake-metadata

Re: Unable to connect Snowflake

Charly1 — Tue, 27 Sep 2022 09:58:37 GMT

Hello,

Thanks for your help!

That was a firewall problem... I try outside my compagnie, all works fine with same talend & java version.

I call my network support for open snowflake ip on our firewall and all work fine !

Regards

Charly