Enabling Snowflake tracing log in Talend Studio components

[TalendSolutionExpert]

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

 

Option 1 - Using the Snowflake connection component

 

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

 

 

Option 2 - Using the JDBC connection component

 

Configure the JDBC URL using the following parameters:

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

 

 

Locating the trace logs

 

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"));

 

 

For more information, see the Snowflake KB article, How To: Generate log files for Snowflake Drivers & Connectors

[dgreenx]

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]

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

[dgreenx]

or you can change the

System.out.printIn

to

System.out.print

[Xiaodi_Shi]

Hello @dgreenx 

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

Best regards

Sabrina