Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jan 22, 2024 9:35:30 PM
Aug 29, 2022 9:03:33 AM
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"));
For more information, see the Snowflake KB article, How To: Generate log files for Snowflake Drivers & Connectors
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"))
I was referring to the tJava component to find the temp dir. I am using Java 17 environment.
or you can change the
System.out.printIn
to
System.out.print
Hello @dgreenx
Thanks for your input and suggestion. We will check the issue you raised and update this article later
Best regards
Sabrina