tdboutput snowflake with Table Action as Create if not exists

vinodn1989 — Wed, 30 Jul 2025 18:28:13 GMT

Getting the below error, I see table already exists, if we drop the table and rerun also same issue is happening.

Error Log:

Starting job Load_Tables_Demographics at 13:24 30/07/2025. [statistics] connecting to socket on port 3809 [statistics] connected Jul 30, 2025 1:24:22 PM net.snowflake.client.core.SFSession open INFO: Opening session with server: https://*****.snowflakecomputing.com:443/, account: *******, user: ********, password is provided, role: null, database: DEMO_DB, schema: Public, warehouse: COMPUTE_WH, validate default parameters: null, authenticator: null, ocsp mode: FAIL_OPEN, passcode in password: null, passcode is not provided, private key is not provided, disable socks proxy: null, application: Talend-8.0, app id: JDBC, app version: 3.22.0, login timeout: 15, retry timeout: null, network timeout: null, query timeout: null, connection timeout: null, socket timeout: null, tracing: null, private key file: null, private key pwd is not provided, enable_diagnostics: not provided, diagnostics_allowlist_path: null, session parameters: client store temporary credential: null, gzip disabled: null, browser response timeout: null Jul 30, 2025 1:24:22 PM net.snowflake.client.core.SFSession open INFO: Connecting to GLOBAL Snowflake domain [FATAL] 13:24:25 qpresales.load_tables_demographics_0_1.Load_Tables_Demographics- tDBOutput_2 Table: DEMOGRAPHICS not found java.io.IOException: Table: DEMOGRAPHICS not found at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:294) ~[components-snowflake-runtime-0.37.47.jar:?] at org.talend.components.snowflake.runtime.SnowflakeWriter.initRuntimeSchemaAndMapIfNecessary(SnowflakeWriter.java:782) ~[components-snowflake-runtime-0.37.47.jar:?] at org.talend.components.snowflake.runtime.SnowflakeWriter.write(SnowflakeWriter.java:394) ~[components-snowflake-runtime-0.37.47.jar:?] at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.tFileInputDelimited_1Process(Load_Tables_Demographics.java:2559) [classes/:?] at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.tDBConnection_1Process(Load_Tables_Demographics.java:846) [classes/:?] at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.runJobInTOS(Load_Tables_Demographics.java:3608) [classes/:?] at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.main(Load_Tables_Demographics.java:3115) [classes/:?] Exception in component tDBOutput_2 (Load_Tables_Demographics) java.io.IOException: Table: DEMOGRAPHICS not found at org.talend.components.snowflake.runtime.SnowflakeSourceOrSink.getSchema(SnowflakeSourceOrSink.java:294) at org.talend.components.snowflake.runtime.SnowflakeWriter.initRuntimeSchemaAndMapIfNecessary(SnowflakeWriter.java:782) at org.talend.components.snowflake.runtime.SnowflakeWriter.write(SnowflakeWriter.java:394) at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.tFileInputDelimited_1Process(Load_Tables_Demographics.java:2559) at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.tDBConnection_1Process(Load_Tables_Demographics.java:846) at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.runJobInTOS(Load_Tables_Demographics.java:3608) at qpresales.load_tables_demographics_0_1.Load_Tables_Demographics.main(Load_Tables_Demographics.java:3115) [statistics] disconnected Job Load_Tables_Demographics ended at 13:24 30/07/2025. [Exit code = 1]

Re: tdboutput snowflake with Table Action as Create if not exists

Denis_Segard — Wed, 30 Jul 2025 19:34:08 GMT

Hello,

Could you set the log4jLevel to TRACE in order to get a more detailed execution log ?

https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2024-06/customizing-log4j-output-level-at-runtime

Kind regards
Denis

Re: tdboutput snowflake with Table Action as Create if not exists

Denis_Segard — Thu, 31 Jul 2025 08:36:10 GMT

and did you test to set the "Table Action" to : DROP_IF_EXISTS_AND CREATE ?

Re: tdboutput snowflake with Table Action as Create if not exists

vinodn1989 — Thu, 31 Jul 2025 17:01:53 GMT

This is also gives the same error.,

Re: tdboutput snowflake with Table Action as Create if not exists

vinodn1989 — Thu, 31 Jul 2025 17:03:08 GMT

Found the solution.

Schema name all Caps - PUBLIC is working.

Public (Sentense Case) - is working when tdbconnection but not the tdboutput. So we make all Caps (PUBLIC), it works fine.

topic Re: tdboutput snowflake with Table Action as Create if not exists in Talend Studio

tdboutput snowflake with Table Action as Create if not exists

Re: tdboutput snowflake with Table Action as Create if not exists

Re: tdboutput snowflake with Table Action as Create if not exists

Re: tdboutput snowflake with Table Action as Create if not exists

Re: tdboutput snowflake with Table Action as Create if not exists