Snowflake

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.
Anonymous
Parents
  • 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

    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?

  • 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

  • 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)
Comment
  • 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