tdboutput snowflake with Table Action as Create if not exists

[vinodn1989]

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]

[Denis_Segard]

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-...

Kind regards
Denis

[Denis_Segard]

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

[vinodn1989]

This is also gives the same error.,

[vinodn1989 · Accepted solution]

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.