Snowflake triggers and actions

A Trigger is an event or condition that initiates the execution of specific actions or workflows. Following is the list of supported Snowflake triggers.

Trigger	Description
Scheduled Query	Provide SQL statement. Rows matching the SQL query will be processed.
New Row in a Table	Process newly inserted rows in a table.
New or Updated Row in a Table	Process newly inserted or updated rows in a table.
Select Rows	Select rows from a table.

A Snowflake Action, for example, Insert Row, is required to send data to Snowflake using the Snowflake app connector. Following is the list of supported Snowflake actions. 

Action	Description
Insert Row	Inserts row in a table.
Update row	Updates row in a table based on a specified unique key.
Update Multiple Rows	Updates multiple rows in a table based on the specified WHERE condition.
Delete Row	Deletes rows from a table based on a specified unique key.
Delete Multiple Rows	Deletes multiple rows from a table based on specified WHERE condition.
Run custom SQL	Runs a single custom SQL query.
Run long query using custom SQL	Runs multiple custom SQL queries.
Select Rows	Selects rows from a table.
Insert Row In Batch	Inserts Row contacts (bulk) in a table snowflakes database in Batch.
Delete Row in Batch	Deletes multiple rows from a table in Batch.
Upsert Rows	Creates a new row or updates an existing row.
Upsert Rows in Batch	Creates new rows or updates existing rows in batch.