Information
  • Author: Vuram
  • Type: Plug-in (Connected System)
  • Support: This plug-in or utility is not supported by the author. The content is free to use with a licensed product, but it is made available as-is and Community supported.
  • Industry: All Industries
  • Compatible Version(s): 23.2
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Snowflake Connected System

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.
Anonymous
  • in reply to ajaykumarg2793

    Hi  ,

    1. I have downloaded the package now and the files are present inside the ZIP package.
    2. And regarding the Add plugin option, we will investigate with the app market team and let you know.



    Let us know if you need any information.

    Thanks,
    Vignesh E 

  • in reply to vigneshe

    Can i know why it is not longer listing as part of- Add-Plugin  - "Appian AppMarket Plugins" search option.

    Also please download and check the latest version of the plugin, it says ".zip" file is empty.

  • in reply to ajaykumarg2793

    Hi  ,

    Thanks for reaching out!

    You are trying to deploy the combined files zip file. Kindly unzip it and you will find the plugin jar. Use that jar file for deployment. 



    Let us know if you need any information.

    Thanks,
    Vignesh E 

  • Hi Team,

    We have the connected system running in lower environments but today when i tried to search for the same under "Appian AppMarket Plugins" in a new environment, it's no longer available.

    Later we tried adding the plugin through direct upload using a previously downloaded copy available on the system, we saw the below error. (currently we are on 24.1 version), Please look into this and provide any available alternative.

    ERROR com.appiancorp.plugins.DeployUploadedPluginReaction - Failed to deploy plugin file Snowflake Connected System Combined Files 12122023.zip
com.appiancorp.suiteapi.common.exceptions.AppianException: Snowflake Connected System Combined Files 12122023.zip is not an Appian validated plug-in. Contact Appian Support to authorize the plug-in. (APNX-1-4523-019)
  • in reply to vigneshe

    Thanks Vignesh for the response. The above issue has been addressed.

  • in reply to Rohan Narla

    Hi Rohan

    Thanks for reaching out!

    This plugin is compatible from version 23.2 and will function properly in version 23.4 as well. The issue you encountered is not related to the Appian version.

    Regards,
    Vignesh E

  • Hi Team,
    The Appian Version on our System is 23.4 and here the compatible version is 23.2.
    Will the compatibility play a key role in the working of this connected system because when we tried to run a basic query to retrieve data we are receiving a Null pointer Exception Error

  • in reply to ajaykumarg2793

    Hi  ,

    Thanks for reaching out!

    Could you please share the version of the Appian environment you are in and the plugin version you are using, and share the image of the connected system you are trying to create? This will make it easier for us to further investigate.

    Regards,
    Vignesh E

  • Hi Team, Currently we are trying to integrate our Appian Dev with Snowflake (both systems are hosted on AWS private cloud).

    We have installed the plugin but when trying to create a connected system, we are seeing the below error in Appian, Please review and suggest.

    Something went wrong: JDBC driver encountered communication error. Message: Certificate for <*.snowflakecomputing.com> doesn't match any of the subject alternative names <*.snowflakecomputing.com>.

© 2024 Appian. All rights reserved.