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): 24.2
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Snowflake

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 with version 3.1.3 of the plugin and 24.3 of Appian we are experiencing some weird behavior. After a server restart we get an error in the integrations saying

    [success:false,result:[],error:[title=Error Occurred, message=No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com, detail=java.sql.SQLException: No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com
     in query CALL PROD.EDW.GET_WORKORDER_DETAILS('81027108')],authType:[name=authType, value=SnowflakeConnectedSystemTemplate, timestamp=2/4/2025 11:04 AM PST]]

    (account id was removed for this post)

    The only way we have found to fix this is we have to click the 'Test Connection' button in the connected system details for each server instance.

Comment

  • Hi with version 3.1.3 of the plugin and 24.3 of Appian we are experiencing some weird behavior. After a server restart we get an error in the integrations saying

    [success:false,result:[],error:[title=Error Occurred, message=No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com, detail=java.sql.SQLException: No suitable driver found for jdbc:snowflake://accountID.snowflakecomputing.com
     in query CALL PROD.EDW.GET_WORKORDER_DETAILS('81027108')],authType:[name=authType, value=SnowflakeConnectedSystemTemplate, timestamp=2/4/2025 11:04 AM PST]]

    (account id was removed for this post)

    The only way we have found to fix this is we have to click the 'Test Connection' button in the connected system details for each server instance.

Children
No Data
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.