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
Issue exists
Hi Team,
While deploying Snowflake Appian plugin in DEV and TEST , we encountered the following error.
The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-019 An Error Has Occurred Expression evaluation error [evaluation ID = e63cc:5ed72] : An error occurred while executing a save: java.util.UnknownFormatConversionException: Conversion = 'D'
Could you please help to resolve the issue.
Regards,
Hema
Hi Scott, Is this issue still up?
Getting this error when trying to add this plug-in. I've confirmed this error in 2 different environments. Other plug-ins deploy without issue.
Hi Santhosh -
Thank you for the comment. That's what I was missing, and this works as expected. Thank you!
Hi robk, Let me assist you in providing the input for the Account Name. For instance, if your Snowflake domine is https://abcdef.us-central1.gcp.snowflakecomputing.com, use the string between https:// and snowflakecomputing.com. ie, abcdef.us-central1.gcp. Kindly do comment back if you still face the issue.
I loaded this to my cloud instance, and when I put my account name in, which is located in us-east-1, it replies: Something went wrong: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Certificate for <Account Name> doesn't match any of the subject alternative names: [*.us-west-2.snowflakecomputing.com, *.us-west-2.aws.snowflakecomputing.com, *.global.snowflakecomputing.com, *.snowflakecomputing.com, *.prod1.us-west-2.aws.snowflakecomputing.com, *.prod2.us-west-2.aws.snowflakecomputing.com].