How to Ingest data from appian to snowflake?? any plugins

Did you try the SnowFlake Connected System?

https://docs.appian.com/suite/help/26.8/snowflake-connected-system.html

,

You can create an Integration using Snowflake Connected system(Snowflake Connected System - Appian 26.8). Select Insert/Update as Operation method and provide the required Warehouse, Database, Schema and Table Details. Add required query in the Update parameter and specify corresponding clause in the Condition parameter.

You can refer Snowflake | Appian AppMarket for Integration configurations. 

You could simple create a table in Snowflake and write to it via a Custom JDBC (see my comment below) plugin or Rest API.

Hi,

You may not need a plug-in. You can create an Appian Web API to provide the table data, then use an ETL tool to load it into Snowflake.

For small or real-time updates, you can also call the Snowflake API from Appian using an HTTP Connected System. For large amounts of data, an ETL process is the better option.