Snowflake Transfer Status Trigger

The Snowflake Transfer Status Trigger initiates a transfer when a value in the monitored table is marked as not yet transferred.

Once the transfer is complete, the record is marked as transferred or failed. Failed transfers can optionally be retried as many times as desired using an additional counter.

note

For the Snowflake Transfer Status Trigger to work, the monitored table must have a primary key.

Properties

General tab

Term	Explanation
Data source	Database plug-in instance to be used.
Table	Table to be monitored.
Marking Column	Column in the table where the transfer status is stored. The column must be initialised with 0 or another configured value for "Not transferred". It does not work with NULL.
Marking values	Here you can set your own values for the different transfer statuses.
Repeat failed transfers	If this option is active, failed transfers are repeated as often as specified.
Number of retries	Specifies how many times failed transfers should be repeated. Note: The column must be initialised with 0. It does not work with NULL.
Delay on delay	Time interval before a transfer is retried.
Sort order	Here you can set how the values are to be sorted. If "None" is selected, no sorting is performed.
Sort column	The column to be sorted.
Limit number of records to	If this option is enabled, you can set the maximum number of records that can be transferred at one time.
Do not use change notifications	If this option is enabled, the polling interval specified in the plug-in will be used for queries even for databases with 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. The "Add" button is used to add filter criteria and the "Add Group" button to add filter groups. 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 different filter operators can be found here.

"AND"/"OR" Clicking on the AND or OR text changes the type of group to the other.

• AND means that all conditions in the group must be met for the group as a whole to apply.
• OR means that one condition in the group must be met for the group as a whole to apply.

"Columns" tab

Here you can select the columns whose values are to be used in the connection. The columns can be selected and deselected either by double-clicking or by using the buttons between the available and used columns.