Data Inputs are not getting saved for the Splunk DB Connect for the Snowflake Database.

Available Languages

Updated:September 29, 2026

Document ID:SPLK046895

Bias-Free Language

The documentation set for this product strives to use bias-free language. For the purposes of this documentation set, bias-free is defined as language that does not imply discrimination based on age, disability, gender, racial identity, ethnic identity, sexual orientation, socioeconomic status, and intersectionality. Exceptions may be present in the documentation due to language that is hardcoded in the user interfaces of the product software, language used based on RFP documentation, or language that is used by a referenced third-party product. Learn more about how Cisco is using Inclusive Language.

Applicability

Splunk DB Connect Splunk Cloud Splunk Enterprise

Description

While attempting to configure the Input, the catalog popup indicates "cannot get catalogs," and while executing the SQL query fails to populate any results, resulting in an error as shown in the screenshot below.

Screenshot 2024-07-04 at 5.40.30 AM.png

Investigation

During investigation, it was observed that the Splunk DB Connect was operating on Java version 17. The Inputs were not saving successfully, and it failed to retrieve the row count. However, from the Snowflake side, it was evident that the SQL query executed successfully and fetched results in the Query Editor of Splunk DB Connect.

Below are the _internal logs observed for Snowflake datainput:

Exception in thread "main" net.snowflake.client.jdbc.SnowflakeSQLLoggedException: JDBC driver internal error: Fail to retrieve row count for first arrow chunk: sun.misc.Unsafe or java.nio.DirectByteBuffer.<init>(long, int) not available. at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.setFirstChunkRowCountForArrow(SnowflakeResultSetSerializableV1.java:1061) at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:550) at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:467) at net.snowflake.client.core.SFResultSetFactory.getResultSet(SFResultSetFactory.java:29) at net.snowflake.client.core.SFStatement.executeQueryInternal(SFStatement.java:219) at net.snowflake.client.core.SFStatement.executeQuery(SFStatement.java:134) at net.snowflake.client.core.SFStatement.execute(SFStatement.java:743) at net.snowflake.client.core.SFStatement.execute(SFStatement.java:639) at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQueryInternal(SnowflakeStatementV1.java:238) at net.snowflake.client.jdbc.SnowflakeStatementV1.executeQuery(SnowflakeStatementV1.java:133)

During investigation, it was observed that user was using Snowflake JDBC driver version 3.13.8 which has an issue with java version >=16. Attaching the reference link here for better clarification.

Resolution

To resolve this issue, it is advisable to use JAVA 11. Below are the Screenshots where the query got executed and Input got saved successfully.

Screenshot 2024-07-04 at 6.16.49 AM.png