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
Team,
We are connecting to Snowflake database through connected system using this plugin in one of our applications. The connected system is successfully getting connected. While using it in a Retrieve Integration operation, it is throwing the below error in our UAT environment which is in 24.2.
Error Occurred
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). 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 ISO_ENGLISH_SHORTNAME_NM FROM VW_MDM_COUNTRY ORDER BY ISO_ENGLISH_SHORTNAME_NM ASC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY
We have found out that the same integration is working fine in our DEV environment which is in 24.1. Can someone help us on fixing this issue.
Regards,
Deepak
Our Test environment was upgraded to 24.2 last night and we started getting these exact errors today. Has there been any response or fixes yet?
Up
Also encountering this issue on 3 separate environments. We are on 24.2 alreadyThank you