topic Re: Talend 7.2.1 snowflake connection Error in Talend Studio

Talend 7.2.1 snowflake connection Error

Prakash3 — Thu, 15 Aug 2019 14:45:35 GMT

Dears,

I have installed Talend 7.2.1 studio and i am trying to push the data from SQL server to Snowflake database, here snowflake connection is successfully created but there is no schema retrieved because of this i m unable to push the data towards snowflake. even i have explicitly mentioned table name and its throwing error as table not found. (in fact table is created and it is available).below is the error,

Exception in component tDBOutput_1 (DataLoad)
java.io.IOException: Table: Table_TransData not found
at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:249)
at org.talend.components.snowflake.runtime.SnowflakeWriter.initRuntimeSchemaAndMapIfNecessary(SnowflakeWriter.java:401)

Re: Talend 7.2.1 snowflake connection Error

Anonymous — Mon, 19 Aug 2019 08:16:34 GMT

Hello,

The table needs to be there when being written. Have you tried to get the list of tables with any other tool (using the same user credentials) like e.g. D Beaver ? Any right issue for it?

Best regards

Sabrina

Re: Talend 7.2.1 snowflake connection Error

Prakash3 — Mon, 19 Aug 2019 08:20:02 GMT

Hi, The table information are showing in the other tools not showing only on the Talend. even i have created Snowflake JDBC connection still the same error.

by the way the same is working in Talend 7.1.1.

Re: Talend 7.2.1 snowflake connection Error

Anonymous — Mon, 19 Aug 2019 10:20:33 GMT

Hello,

Any "case sensitive" issue in V 7.2.1? There is an option "Allow Snowflake to convert columns and tables to uppercase" which converts lowercase in the defined table name and schema column names to uppercase. Note that unquoted identifiers should match the Snowflake Identifier Syntax.

Best regards

Sabrina

Re: Talend 7.2.1 snowflake connection Error

Prakash3 — Tue, 20 Aug 2019 08:18:20 GMT

Hello,

I am unable to find that option "Allow Snowflake to convert columns and tables to uppercase" in the snowflake metadata connection, could you please help on this.

SF_Talend1.PNG