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 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 Hema,
Since this error is occurring when deploying the plugin, please raise a support ticket to Appian regarding this.
Hi Sridhar Subba Rao
The Snowflake plugin doesn't need any read/write permission to the file system. The newer version will be listed in App Market soon to fix the deployment issue.
We have contacted the plug-in owner to report this issue. Once the plug-in gets fixed, we will update it in the AppMarket. Thanks for your patience.
Can we expect a fix anytime soon?
Thanks for the update.
This is the feedback from Appian support.
I'm following up from the previous communication to share some further information that I've found that suggests the snowflake plugin will not work on Appian Cloud sites but only for Self-Managed due to the fact that it needs read/write permissions to the file system
The 3.01 version is installed successfully on many cloud instances. The version 3.02 is throwing the above error during installation on multiple cloud instances. Please check what is different that has caused this issue.
The log contains the below error message. Please help as this is critical issue.
2022-08-18 10:00:50,367 [ajp-nio-0.0.0.0-8009-exec-12] ERROR com.atlassian.plugin.manager.DefaultPluginManager - There was an error loading the descriptor 'SnowflakeConnectedSystemTemplate' of plugin 'com.vuram.snowflake'. Disabling. java.lang.RuntimeException: com.vuram.snowflake.templates.SnowflakeConnectedSystemTemplate is not of type com.appian.connectedsystems.templateframework.sdk.ConnectedSystemTemplate at com.appiancorp.connectedsystems.templateframework.osgi.ConnectedSystemTemplateModuleParser.lambda$getClasses$1(ConnectedSystemTemplateModuleParser.java:152) at com.appiancorp.connectedsystems.templateframework.osgi.ConnectedSystemTemplateModuleParser.logClassExtractionTimings(ConnectedSystemTemplateModuleParser.java:172) at com.appiancorp.connectedsystems.templateframework.osgi.ConnectedSystemTemplateModuleParser.getClasses(ConnectedSystemTemplateModuleParser.java:140) at com.appiancorp.connectedsystems.templateframework.osgi.ConnectedSystemTemplateModuleParser.getConnectedSystemClass(ConnectedSystemTemplateModuleParser.java:127) at com.appiancorp.connectedsystems.templateframework.osgi.OsgiConnectedSystemTemplateModuleMapper.enabledTemplateDescriptorsFromModuleParser(OsgiConnectedSystemTemplateModuleMapper.java:34) at com.appiancorp.connectedsystems.templateframework.osgi.OsgiDiscoveryStrategyImpl.onModuleDisabled(OsgiDiscoveryStrategyImpl.java:61) at com.appiancorp.connectedsystems.templateframework.osgi.ConnectedSystemTemplateModuleDescriptor.disabled(ConnectedSystemTemplateModuleDescriptor.java:42)