Join the Conversation
- Find Answers
- :
- Apps & Add-ons
- :
- All Apps and Add-ons
- :
- All Apps and Add-ons
- :
- Cloud Snowflake DB Connect Integration
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Could you please help here I tried to integrate the Snowflake with db connect.
I am using following version of JRE: /usr/java/jdk1.8.0_131/jre
I have placed snowflake at following location:
/opt/splunk/etc/apps/splunk_app_db_connect/drivers/snowflake-jdbc-3.9.1-javadoc.jar
/opt/splunk/etc/apps/splunk_app_db_connect/drivers/snowflake-libs/snowflake-jdbc-3.9.1-javadoc.jar
/opt/splunk/etc/apps/splunk_app_db_connect/jars/snowflake-jdbc-3.9.1-javadoc.jar
I have put below stanza in /opt/splunk/etc/apps/splunk_app_db_connect/local/ db_connection_types.conf
[snowflake]
displayName = Snowflake
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:snowflake://:/
jdbcDriverClass = com.snowflake.client.jdbc.SnowflakeDriver
Now when I create a connection and try to save I get following error:
Database connection snowflake is invalid
No suitable driver found for jdbc:snowflake://"":443/
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi there,
Please try the following steps:
- Make sure you download the latest Snowflake JDBC Driver
jarversion and NOTjavadoc.jar: https://docs.snowflake.net/manuals/user-guide/jdbc-download.html#downloading-the-driver OR https://search.maven.org/classic/#search%7Cga%7C1%7Csnowflake-jdbc - Drop the .jar file (driver) under $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers
- Create or update db_connection_types.conf under $SPLUNK_HOME/etc/apps/splunk_app_db_connect/local with the following:
[snowflake]displayName = SnowflakeserviceClass = com.splunk.dbx2.DefaultDBX2JDBCjdbcDriverClass = net.snowflake.client.jdbc.SnowflakeDriverjdbcUrlFormat = jdbc:snowflake://<host>:<port>/?db=<database>ui_default_catalog = $database$port = 443 - Restart Splunk
- Now, the Snowflake Driver should be available via the UI
- Create a new Identity with your Snowflake credentials
- Create a new Database Connection for Snowflake with the following:
- Snowflake Identity
- Snowflake Connection Type
- Select the Timezone set/used by your Snowflake Database/Environment
- Check the "Edit JDBC URL" checkbox, this will have to be manually provided as per
https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html or something similar to
jdbc:snowflake://<account_name>.snowflakecomputing.com/?<connection_params>ORjdbc:snowflake://<account_name>.snowflakecomputing.com/?db=<database>&warehouse=<warehouse>&schema=<schema>Replace all the<parameters>to reflect your environment. - Make sure that
Read Onlyis unchecked as this parameter is not available on Snowflake Fetch sizecan be left alone
Your Database Connection should look as follows: Screenshot
The JDBC URL can be adapted as per your environment as long as it matches their JDBC Driver Connection String: https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html#jdbc-driver-connection-string!
Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!
Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.
Index This | What travels the world but is also stuck in place?
Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data
Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...
