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
Hi Vuram team, we have downloaded the latest plugin ,but checking the jar files, we could see some files showing component version(maybe some meta data reference) as 3.19.0, which is not latest as per the release of the plugin , can we expect new version release with this addressed?
error-result-guidanceCannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is nulljava.lang.NullPointerException: Cannot invoke "Object.getClass()" because the return value of "java.sql.ResultSet.getObject(int)" is nullReceiving this error after updating to v3.1.2. It seems like there is an error when trying to query Integers/Numbers with NULL values.
Hello, how can we add a "GROUP BY" clause when using the Retrieve Integration? Where would we type that and what is the syntax?
Is is possible to do Count, Group By, or Not Null with this?
Hello Snowflake Team,We're having an issue in Retrieve Integration on Snowflake Connected system for DATE Metadata. For example, querying a date 11/08/2024 will give us a result of 11/07/2024. We are using 24.3 Appian Environment with the plugin version of Snowflake 3.1.1
Hi Lokesh,Thanks for reaching out!!The maximum query timeout in Appian Integration is 300 seconds, while the default timeout is 30 seconds. In Snowflake, the maximum timeout is 604800 seconds.
Hi Team What is the Max Query timeout limit ?
Can you please share exact steps followed to fix the issue? Seems this is frequent error and any detailed steps to fix it will help a lot.