JDBC triggers
Select trigger
You are able to provide a SELECT query with the last execution timestamp as the WHERE clause criteria.
Before executing the statement, %%EIO_LAST_POLL%% will be replaced with the ISO date of the last execution or the maximum value of the last pooled datetime, for example, 2018-08-01T00:00:00.000.
During the first execution, the date will be equal to the start of Unix Time - 1970-01-01 00:00:00.000.
Precision of the polling clause can be up to milliseconds.
The Start Polling From (optional) field should be formatted as yyyy-mm-dd hh:mi:ss[.sss]:
| Code | Description |
|---|---|
yyyy |
year |
mm |
month |
dd |
day |
hh |
hour |
mi |
minute |
ss |
second |
sss |
millisecond (optional) |
Get rows polling trigger
This trigger can poll data from the provided table.
As a WHERE clause, you can use a column with a datatype like DATE or TIMESTAMP.
Before executing the statement, %%EIO_LAST_POLL%% will be replaced with the ISO date of the last execution or the max value of the last pooled datetime, for example, 2018-08-01T00:00:00.000.
During the first execution, the date will be equal to the start of Unix Time - 1970-01-01 00:00:00.000.
Precision of the polling clause can be up to milliseconds.
The Start Polling From (optional) field should be formatted as yyyy-mm-dd hh:mi:ss[.sss]:
| Code | Description |
|---|---|
yyyy |
year |
mm |
month |
dd |
day |
hh |
hour |
mi |
minute |
ss |
second |
sss |
millisecond (optional) |
| Component snapshots will not be overwritten in real-time flows due to platform behavior, so we strongly recommend using the Get rows polling trigger in Keen flows only. |
Input fields description
| Input Field | Description |
|---|---|
Tables List |
Dropdown list with available table names, required field |
Timestamp (or similar) Column |
Dropdown list with available column names that have a type like java.sql.Date or java.sql.Timestamp, required field |
Start Polling From (optional) |
Optional field indicating the beginning time to start polling from (defaults to the current time) |
Select trigger (deprecated)
This action exists in the JDBC component only for backward compatibility. Use the Select trigger instead.