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.
Do we have the option to load the internal stage with data ? Like the put operation present in snowflake?
© 2021 Appian. All rights reserved.