Overview
Snowflake is a cloud-based data platform built for scalable storage, fast querying, and secure data sharing across structured and semi-structured datasets. It separates compute and storage for flexible scaling and supports advanced analytics with strong performance across major cloud providers.
Appian helps you get more from Snowflake by turning raw data into action through low-code applications and AI-powered automation. With Appian’s data fabric, you can connect to Snowflake to enable unified views, streamlined workflows, and faster decisions, all while keeping Snowflake as your system of record.
Use this Appian Connected System to authenticate with OAuth 2.0: Authorization Code Grant in order to access and execute actions on your Snowflake resources. Through the integrations provided in this plug-in, you can select, insert, update, delete, and call a function or stored procedure in any accessible warehouse, schema, or table.
This plug-in was originally authored by Appian's partner, WNS Vuram. It is now maintained by the Appian Technology Partner Team.
Key Features & Functionality
Our test environment was upgraded to 24.2 Sunday night. After the upgrade we could no longer sync with Snowflake. Up to that point, everything worked perfectly fine. Now, we get errors when the sync tries to run.
"Unable to sync due to an error in the Record Data Source during batch number 1
The Record Data Source returned an error. Title: Error Occurred Detail: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:586). in query SELECT * FROM vwTHERAPYTYPE OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY Message: JDBC driver internal error: exception creating result java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.jdbc.internal.apache.arrow.memory.RootAllocator at net.snowflake.client.jdbc.SnowflakeResultSetSerializableV1.create(SnowflakeResultSetSerializableV1.java:586)."
This solution works!!
24.2 utilizes Java 17. There is a known Snowflake issue regarding this. As a workaround, we were able to update the connection string within Snowflake to allow us to start syncing again.
ALTER USER [USER] SET JDBC_QUERY_RESULT_FORMAT='JSON';
We're getting the same error. Appian 24.2 with plugin version 3.1.0. Test connection from the Connected System object is successful, but all integrations getting the error.