​
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
)