Snowflake Data Change Trigger
The Snowflake Data Change Trigger monitors query results and triggers a transfer when changes occur. To do this, a select query is defined in the Snowflake Data Change Trigger. The columns to be monitored are specified in the "General" tab. The "Filter" tab allows you to define more precisely when a transfer should be triggered. For example, a transfer should only be triggered when a column has a specific value.
Properties:
"General" tab
| Term | Explanation |
|---|---|
| DB access data | The configured instances of the Snowflake plug-in are available for selection here. |
| Table | Table from which columns are to be monitored. Note: The specified table must have a primary key. Tables without a primary key are not supported. |
| Available | All available columns in the selected table that have not yet been selected for the "Used" area. Select the columns to be monitored. |
| Used | All columns of the selected table that have already been selected. You can add or remove fields using the arrows between the "Available:" and "Used:" areas or by double-clicking. |
| Trigger on connect | If this option is set, a transfer is triggered when the router connects to the database. |
| Do not use change notifications | If this option is set, the polling interval configured in the plug-in is used for querying instead of the change notifications. |
"Filter" tab
Here, filters and filter groups can be created and configured graphically. The SQL statement is constructed from the tree. Unlike with the DB transfer object, the filter values must be entered here. Use the "Add" button to add individual filter criteria and the "Add Group" button to add a filter group. The button with the minus sign deletes the respective filter or filter group.
Filter A filter consists of three elements:
- Column: The column to which the filter refers.
- Filter operator: The operator determines how the filter value is used to filter the records.
- Filter value: The value used to filter the records. An explanation of the various filter operators can be found here.
"AND"/"OR" Clicking on the AND or OR text changes the type of group to the other.
ANDmeans that all conditions in the group must be met for the group as a whole to apply.ORmeans that one condition in the group must be met for the group as a whole to apply.