At Macedon, we've had a number of clients ask about Appian's ability to connect to cloud Snowflake warehouses. As the functionality is not built-in, we started to look into if a connection to a Snowflake instance would be possible through a Connected System plug-in which would allow designers to build integrations to perform queries to Snowflake warehouses, schemas, and tables.
This connected system plug-in lets you connect to a Snowflake data warehouse by creating a Connected System with credentials and then make different queries broken out into different integration templates. By using integration objects a user is able to create integration objects that can make Select, Insert, Update or Delete queries after selecting the warehouse, schema, database table (or view) and then entering other inputs to make the queries execute successfully. The results from the queries executed by the integration objects return in a dictionary format, which can easily be translated to Appian CDTs or parsed as they are returned.
© 2020 Appian. All rights reserved.