Splunk DBX Add-on for Snowflake JDBC : How to enable DEBUG logging for Snowflake JDBC Driver with in Splunk App DB Connect.

Applicability

Description

To troubleshoot or gain deeper insights into the Snowflake JDBC driver behavior within Splunk DB Connect, one can enable DEBUG-level logging using either of two methods, depending on DB Connect version mentioned in this knowledge article.

Investigation

This KB is only for Knowledge sharing purpose on how to achieve an DEBUG logging inside driver.

Resolution

Approach 1: For DB Connect v3.18.0

1. Edit the dbx_task_server.yml

   • Path: $SPLUNK_HOME/etc/apps/splunk_app_db_connect/config/dbx_task_server.yml

   • Change logging level:

     logging:
         level: DEBUG
         loggers:

   • Save changes.

   • Restart Splunk.

Note:

• DEBUG logs appear when level is set to DEBUG.

• Only ERROR logs appear when reverted back to INFO.
  
  

Approach 2: For DB Connect v4.0.0

1. Upgrade to DB Connect v4.0.0.

2. Configure Logging via UI:

   • Go to:
     DB Connect UI → Configurations → Settings → Logging

   • Set "Other Features" to DEBUG and save.

3. Restart Splunk.

Note:
Reverting "Other Features" to INFO will stop DEBUG logs from showing.