Configuration
This section explains each of the properties in the configuration blade.

General

Property
Description
Collection
This associates the Agent to a specific Collection (default to that of the current Data Stream).
Polling Interval (seconds)
A timespan to specify how often should the Agent check for new data/changes or update its cache.
Refer to Collections and Stream Hosts to understand more about Collections.

Authentication

Property
Description
Use Variables
Tick to select saved variables for the Client Id, Secret Key, Tenant Id, and Cluster URL properties; or enter the text manually.
Client Id
The Id of the Azure App Registration used to connect to the Azure Data Explorer instance.
Client Secret
The Secret of the Azure App Registration used to connect to the Azure Data Explorer instance.
Tenant Id
The Id of the tenant to which the Client belongs.

Cluster

Property
Description
Cluster Url
The Host Name used to create, start, edit, list, terminate, and delete clusters - in the format https://{clusterName}.{location}.kusto.windows.net You can find the URL on the Azure Portal blade for the Data Explorer Cluster under the "URI" property.

Database

Once the Authentication and Cluster properties are entered, the Agent attempts to open a connection with the database server. If successful, the Database dropdown is populated with a list of available databases.
Property
Description
Database
The name of the database to connect to. Once selected, the Table property is populated with the list of available tables in the database.
Specify ADX Query?
Tick to query using a KQL statement, or select a table (default).
Table
The name of the table to connect to (applies when Specify ADX Query is not ticked).
ADX Query
Query Azure Data Explorer (ADX) through a KQL statement (applies when Specify ADX Query is ticked). This option is useful when querying data by joining multiple tables.
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 or query.

Filtering & Sorting

Property
Description
Limit Rows By
The limit options applied to the returned rows are:
  • None (default, no limit)
  • Number (e.g. first 100 rows)
  • Duration (e.g. 7 days or 24 hours).
Number of Rows
The number of rows that should be returned (applies when Limit Rows By is Number).
Duration Type
The duration options are Day, Hour or Minute (applies when Limit Rows By is Duration).
Duration Value
The value of the duration (applies when Limit Rows By is Duration).
Timestamp Column
The column used to calculate the row's age (applies when Limit Rows By is Duration).
Filters
Rules for filtering the returned results.
Sort By
The column(s) and direction(s) by which the results should be sorted. The direction options are ascending and descending.

Endpoints

Name
Description
Output
The read events will be made available to this endpoint with attributes matching those specified in the Columns To Return property.
Error
Errors encountered during the execution of this Agent will be published on this endpoint.