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
Hello,
Just a heads up for anyone trying to refactor from other plugins into this one using existing Basic credentials - there's an issue with basic auth right now, so you might need to skip right into the Authorization Grant method.
I keep getting an UnsupportedOperation exception:
Digging into this further, it appears that the SnowflakeConnectedSystemTemplate is setting SF_CS_TYPE to CS_TYPE_CC rather than CS_TYPE_BASIC, which then causes the SnowflakeUtility constructor to throw the exception.
Any chance a fix could be put in for this? Also pretty happy that Key Pair is potentially a future consideration since it's in the types list.
Hi Jesse! Thanks for posting this issue and your recommendation, we'll look into the cause as soon as possible.
Hi Alex King . We are experiencing the same issue. Looking forward for an update