Description

Triggers enable users to define event-based actions. For example, if a table is updated, then run a query to update predictions.
Currently, you can create triggers on MongoDB data sources.

Syntax

Here is the syntax for creating a trigger:
CREATE TRIGGER trigger_name
ON integration_name.table_name
[COLUMNS column_name1, column_name2, ...]
(
    sql_code
) 
By creating a trigger on a data source, every time this data source is updated or new data is inserted, the sql_code provided in the statement will be executed. You can create a trigger either on a table…
CREATE TRIGGER trigger_name
ON integration_name.table_name
(
    sql_code
) 
…or on one or more columns of a table.
CREATE TRIGGER trigger_name
ON integration_name.table_name
COLUMNS column_name1, column_name2
(
    sql_code
)