article Enabling Snowflake tracing log in Talend Studio components in Official Support Articles

Enabling Snowflake tracing log in Talend Studio components

TalendSolutionExpert — Tue, 23 Jan 2024 02:35:30 GMT

Use one of the following options to enable the Snowflake tracing log.

Add "tracing=All" to the component Advanced Settings > Additional JDBC Parameters field.

Configure the JDBC URL using the following parameters:

jdbc:snowflake://<account>.snowflakecomputing.com?db=<dbname>&warehouse=<whname>&schema=<scname>&tracing=ALL

You can locate the trace log, stored in the tmp log file directory, by running a tJava component with the following code:

System.out.printIn(System.getProperty("java.io.tmpdir"));

dgreenx — Thu, 25 Apr 2024 14:01:40 GMT

The above does not generate/compile.

Better to use something like this:

tSetGlobalVar: myData is set to System.getProperty("java.io.tmpdir")

tMsgBox has something like the following:

"Hello world!
Here is myData: " + ((String)globalMap.get("myData"))

dgreenx — Thu, 25 Apr 2024 14:04:17 GMT

I was referring to the tJava component to find the temp dir. I am using Java 17 environment.

dgreenx — Thu, 25 Apr 2024 14:07:14 GMT

or you can change the

System.out.printIn

System.out.print

Xiaodi_Shi — Fri, 26 Apr 2024 01:58:12 GMT

Thanks for your input and suggestion. We will check the issue you raised and update this article later

Best regards

Sabrina