How to generate JDBC driver log for snowflake database

[Nanda_Ravindra]

When debugging connection issue to snowflake during the  ETL process in Compose, we may need to trace the JDBC driver log to identify the issue.

Environment

• Qlik Compose
• Qlik Compose for Data Warehouse

Enabling the JDBC trace log is done by simply adding ‘ tracing=ALL’ to the end of the connection string information in the Data warehouse advance connection properties setting in the Compose UI.

Example:

jdbc:snowflake://attunity_partner.east-us-2.azure.snowflakecomputing.com/?user=USER_NAME&warehouse=WH_NAME;queryTimeout=6000&tracing=ALL

Note:  Replace the snowflake URL, USER_NAME, and WH_NAME  with the correct values.

Once done debugging the issue, please remove the tracing from the connection string as this will create a large file.

Naming convention for log file(s): Snowflake*.log.

Logfile location:

In Windows environments, the default directory is usually C:\temp. or in c:\windows\temp
In Mac OS environments, the default directory is usually either /tmp or /var/tmp.

To temporarily change where JDBC logs are generated:

Pass java.io.tmpDir as a JVM argument in the connection string 

Example:

jdbc:snowflake://attunity_partner.east-us-2.azure.snowflakecomputing.com/?user=USER_NAME&warehouse=WH_NAME;queryTimeout=6000&tracing=ALL& Djava.io.tmpdir=/my/custom/logpath