Information
  • Author: Appian Corporation
  • 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): 25.1
  • First Released:
  • Last Updated:
  • Cost: Free
Resources
Share
Home » AppMarket » Snowflake

Snowflake

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

  • Use this Appian Connected System to authenticate and 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.
  • Supported Authentication Methods include Key Pair, Programmatic Access Token, Authorization Code Grant, and Basic Authorization.
  • Refer to the documentation for instructions on configuring each.
Anonymous
  • in reply to lesliem

    Hi lesliem,

    Thanks for reaching out. The query to retrieve all data is currently being executed by the plugin. We will fix this issue in the upcoming version.

    Regards,
    Ananthakrishnan S

  • vigneshe, I am not able to give a valid screenshot of the Request tab because the tab does not refresh with any information before the servers restart.

    I have included a screenshot of the activity in Snowflake.  You can see that once the initial request runs something is running a query again to retrieving all rows and all data.  Even after the successful retrieval into Appian from the PRODUCT_VALUATION_ACCOUTNING_FACT_V01 something ran the next query gathering all data.

  • in reply to lesliem

    Hi  ,

    We cant reproduce the issue you addressed can you send us more detail and please switch the request tab and check whether the Query is passed correctly.



    Regards,
    Vignesh E

  • Hello,

    I am trying retrieve data with a where clause in the Condition field on the integration, but I am having problems structuring it in the field so that it will pull back the data.  Every time I try the below query it removes the where clause and pulls back the entire data set and crashes the server.  Any help would be appreciated.

  • in reply to vigneshe

    Unfortunately this is not possible, we use it expensively and call sql directly through it. In that case, is there a way to fix the datetime issue?

    Thank you,

    Walker

  • in reply to walkers

    Hi ,

    You can reach us via team.int.swatcustomdev@vuram.com. 

    And regarding the split up, in version 2.1.0  we have only one integration called "SnowflakeJDBCIntegrationTemplate" after version 3.0.0 that is split into 5 different integrations, RetrieveIntegrationTemplate, InsertIntegrationTemplate, UpdateIntegrationTemplate, DeleteIntegrationTemplate, CallIntegrationTemplate. So you can update the Appian integration to the new one according to your usage.



    Regards,
    Vignesh E

  • in reply to vigneshe

    Hi Vigneshe,

    Thank you for getting back to me. We are using the connected system to connect Appian to Snowflake. We were on version  2.1.0.0., but I updated it to see if it would fix the date time issue. 

    What do you mean by split up? All I did was update the plugin we were using via the admin console. 

    I also reached out to a few people at Vuram via email, but have not heard back yet. 

    Thank you,

    Walker

  • in reply to walkers

    Hi ,

    Thanks for reaching out,

    Can you please share with us what integration you are trying to use? Because the integrations were split up and updated after version 3.0.0. If so please update it with the help of the document that is in the download package of the plugin.

    Please feel free to reach us if you still face any issues.

    Regards,
    Vignesh E 

  • Hello,

    I am having an issue where a date time in Snowflake is stored as ET, but when I query it using the snowflake integration in Appian, it lists the timezone in EDT and the time is 4 hours earlier than the time in Snowflake. For example, 

    2023-08-01 18:27:37.872 in the database is displayed as 8/1/23 2:27 PM EDT in Appian.

    I was on version 2.1.0.0., I updated to the most recent version, and now I am getting this error: "Error Evaluating UI Expression Expression evaluation error [evaluation ID = 769af:e47b1] in rule 'rti_snowflakeintegration' (called by rules 'rti_rule_snowflake_returnappianformatteddatabyselectstatement' > 'rti_form_displaycolumnstoselectfiltersandmodelgridforrunselectionv2' > 'rti_parent_form_dataruninuseflagselection') : Unable to find Integration Template with the id "plugin.[com.vuram.snowflake].[SnowflakeConnectedSystemTemplate].[SFJDBCIntegrationTemplate].READ""

    Is the date time issue fixed in the newest version? If so, why is it breaking?
© 2025 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.