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 objects.
The connected system supports specifying a database, warehouse, schema, and role (all import customizable), as well as account and credentials.
Using integration objects, a designer is able to create integrations that can make Select, Insert, Update or Delete queries, as well as call a Function or Stored Procedure. Filters and Paging Configurations can be configured on the inputs of the Select operation. The results from the queries executed by the integration objects return in a dictionary format, allowing easy parsing the returned result sets.
All of the queries taking potentially unvalidated inputs are called using prepared statements, mitigating the risk of SQL injection.
© 2020 Appian. All rights reserved.