This section explains each of the properties in the configuration blade.
This associates this Agent to a specific Collection and defaults to that of the current Data Stream.
Polling Interval (seconds)
This determines how often the data cache is refreshed during runtime - which depends how often your data changes e.g. hourly.
Use Connection Variables
Tick to select saved variables; or enter the text manually for server connection properties.
The MySQL server name / IP address.
e.g. localhost / 127.0.0.1
The MySQL login username.
The MySQL login password.
A list of Schemas to be selected.
The name of the table to connect to. Once selected, the Columns To Return property will be populated with the list of columns from the selected table.
Columns to Return
The columns which the Agent should return. If no columns are specified, the Agent will return all the columns from the table.
Limit Rows By
Optional criteria for limiting the output.
Defaulted to None.
Number of Rows
Limit the number of rows to be returned based on the value.
Applies when Limit Rows By selected as Number of Rows.
The metric of duration used for limiting the output.
Defaulted to Day.
Applies when Limit Rows By property value is selected as Duration.
Limit the number of rows to be returned based on the Duration Value configured.
The value will be compared against the selected Timestamp Column. Applies when Limit Rows By property value is selected as Duration.
A list of DateTime columns in the selected table. Applies when Limit Rows By property value is selected as Duration.
The optional filter(s) applied to the database table contents, expressed with the column name, operator (Contains, Does not contain, Starts with, Ends with and Equals) and compare value.
The attribute(s) by which the output should be sorted in Ascending / Descending order (optional).
Records in the selected Table will be made available to this endpoint with attributes matching the configured schema.
If errors are encountered during the execution of this Agent they will be published on this endpoint.