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
Every time the server needs a restart, i.e. upgrade, general maintenance, etc., we have to go into the Connected System and click Test Connect for this plugin to work. We are on the latest version 3.1.4. I created a ticket with Support and they said this was a known issue with your plugin. Is there any plan to fix this issue?
We are experiencing the same issue, even with v3.1.4.
Hi Team,
Is there a plan to enable key pair authentication to this plug-in.
Thanks,
Hello,
Is there any plan to update the plugin to handle MFA or key-pair authentication?
Thanks
Snowflake will begin blocking single-factor password authentication by November, 2025. Will the plugin be updated to handle MFA or key-pair authentication?
https://www.snowflake.com/en/blog/blocking-single-factor-password-authentification/
Hi with version 3.1.3 of the plugin and 24.3 of Appian we are experiencing some weird behavior. After a server restart we get an error in the integrations saying [success:false,result:[],error:[title=Error Occurred, message=No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com, detail=java.sql.SQLException: No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com in query CALL PROD.EDW.GET_WORKORDER_DETAILS('81027108')],authType:[name=authType, value=SnowflakeConnectedSystemTemplate, timestamp=2/4/2025 11:04 AM PST]] (account id was removed for this post)The only way we have found to fix this is we have to click the 'Test Connection' button in the connected system details for each server instance.
How to insert multiple rows data to snowflake from Appian, via SP