Snowflake Connected System

Overview

Snowflake is an analytic data warehouse that is fast, easy to use, and pliable. We have built the Snowflake Connected system to employ these benefits in Appian. You can use this connected system to create an integration object that can help perform SELECT, INSERT, UPDATE, DELETE, CALL FUNCTION or STORED PROCEDURE operations in the Snowflake Database tables or views.

To establish the connection, while creating a connected system you will need

Account Name: Full name of your account (provided by Snowflake). Note that your full account name might include additional segments that identify the region and cloud platform where your account is hosted. ex: <account>.snowflakecomputing.com
Role: Default access control role to use in the Snowflake session. The specified role should be an existing role that has already been assigned to the specified user. If the specified role has not already been assigned to the user, the role is not used when the session. ex: ACCOUNTADMIN, SECURITYADMIN, SYSADMIN, PUBLIC. (Only provide single role)
User: Login name of the user for the connection.
Password: Password of the account

Key Features & Functionality

Queried data from Snowflake will be returned in the integration as Dictionary format.
Added Warehouse, DB and Schema as the optional parameters.
The result will contain the total number of rows returned from Snowflake.
The result will contain the column metadata.

Parents

Hema Kumar over 1 year ago

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
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
naveeng over 1 year ago in reply to Hema Kumar

Hi Hema,

Since this error is occurring when deploying the plugin, please raise a support ticket to Appian regarding this.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Santhosh Kumar over 1 year ago in reply to Sridhar Subba Rao

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.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Appian AppMarket over 1 year ago in reply to Sridhar Subba Rao

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.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Sridhar Subba Rao over 1 year ago in reply to Santhosh Kumar

Can we expect a fix anytime soon?
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Santhosh Kumar over 1 year ago in reply to Sridhar Subba Rao

Thanks for the update.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Sridhar Subba Rao over 1 year ago in reply to Santhosh Kumar

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
- Cancel
- Up +1 Down
- Reply
- More
- Cancel
Sridhar Subba Rao over 1 year ago in reply to naveeng

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
- Cancel
- Up 0 Down
- Reply
- More
- Cancel
Sridhar Subba Rao over 1 year ago in reply to Santhosh Kumar

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.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Sridhar Subba Rao over 1 year ago in reply to Santhosh Kumar

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)

Comment

Sridhar Subba Rao over 1 year ago in reply to Santhosh Kumar

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)

Children

No Data