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


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. |
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 | |
Client Secret | |
Tenant Id | The Id of the tenant to which the Client belongs. |
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. |
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 is useful when querying data by joining multiple tables.
Refer to Identifier Quoting when your query includes identifiers that are the same as keywords or contain special characters. |
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. |
Special Characters in Identifier Names
These special characters are supported: (_) Underscore, (-) Dash, (.) Period and ( ) Space.
The following special characters in ADX Query are not supported and will result in errors:
- (*) Asterisk (Request is invalid and cannot be executed.)
- (\) Backslash and (\\) Double Backslash (Parse error. No Values will be displayed.)
- (.) Period (No Values will be displayed.)
Refer to Azure Data Explorer's Identifier Naming Rules for more information when creating your entity.
Property | Description |
---|---|
Column | The column used to detecting new rows. Ideally, the selected column should have a unique, incrementing value for each new row. |
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. |
Last modified 4h ago