KB-2338 Snowflake Connected System Breaks after Upgrade to 24.2

Symptoms

After upgrading to Appian 24.2, the following error message appears when trying to query the snowflake connected system through an integration: 

JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.util.MemoryUtil at net.snowflake.client.jdbc.internal.apache.arrow.memory.ArrowBuf.getDirectBuffer(ArrowBuf.java:234)

Cause

Beginning in Appian 24.2, Appian uses Java 17. Snowflake has an existing issue with its JDBC driver's compatibility with Java 17.

This incompatibility causes the JDBC driver to throw the error message seen above when trying to query through Appian's Connected System object.

Action

This can be remediated by adding the following to the connection URL within the connected system:  JDBC_QUERY_RESULT_FORMAT=JSON

An example URL is provided below:

jdbc:snowflake://<URL>.snowflakecomputing.com/?warehouse=COMPUTE_WH&JDBC_QUERY_RESULT_FORMAT=JSON

Affected Versions

This article applies to Appian versions 24.2 and later.

Last Reviewed: July 2024

Related
Recommended