Snowflake driver not showing in driver section in Splunk DB Connect UI.

Applicability

Description

With Splunk DB Connect version 3.9.0, when user tries to install snowflake driver (Splunk DBX Add-on for Snowflake JDBC version 1.2.1) from Splunkbase, the driver does not show up on the UI. The driver doesn't show up even after adding required JAR file (snowflake-jdbc-3.13.7.jar) in the Splunk DB connect driver directory.

Reference screenshot has been attached below that shows JAR file (snowflake-jdbc-3.13.7.jar) has been added in the Splunk DB connect driver directory.

Below screenshot from UI shows that the driver is still not populating on the UI.

Investigation

In investigation, it was found that the default stanza for the Snowflake driver was missing in the db_connection_types.conf file. The db_connection_types.conf file lists the supported database types, driver parameters, and test queries. The file contains the specification for database connection types.

Default driver file path:

splunk_app_db_connect/default/db_connection_types.conf

Resolution

This issue can be resolved by adding the following stanza to db_connection_types.conf in the Splunk DB Connect default directory, followed by a Splunk restart.

Path where the changes need to be performed mentioned below:

$SPLUNK_HOME/etc/apps/splunk_app_db_connect/default/db_connection_types.conf

Stanza that needs to be added in db_connection_types.conf as below:

[snowflake]
displayName = Snowflake
serviceClass = com.splunk.dbx2.SnowflakeJDBC
jdbcDriverClass = net.snowflake.client.jdbc.SnowflakeDriver
supportedVersions = 3.0
jdbcUrlFormat = jdbc:snowflake://<host>.snowflakecomputing.com/
testQuery = SELECT current_date()
useConnectionPool = true

Please refer to the documentation for more information.