Azure Data Explorer Connector
The Azure Data Explorer Connector allows you to connect to an Azure Data Explorer instance and retrieve data as requested by the Application.
The Azure Data Explorer platform is a fully managed, high-performance, big data analytics platform that makes it easy to analyze high volumes of data in near real-time.
Please see their store page and documentation for more information about the Azure Data Explorer platform.
Read on for examples, its configuration, and release notes.
Live Updates
This Connector supports Live Updates, i.e. it can update the entity to display the most up-to-date information.
This capability is available when the Connector is configured for time series data (See Is Time Series) and polling (See Enable Polling).
Pre-requisites
The user must have credentials to an Azure subscription with permission to read Azure Data Explorer instances.
Azure Data Explorer's Kusto limits the number of records returned to 500,000, and the overall data size for those records to 64 MB. Read more about limits on the result set size here.
Current Version
Request the Azure Data Explorer Connector v1.97
Contact XMPro if you're looking for an older version of this Connector.
Connector Release Notes
v1.97, 22 Jun 2023
Include Materialized Views in the Table property dropdown
v1.96, 08 Mar 2023
Handle column names with allowed special characters
v1.95, 27 Feb 2023
Made Column To Return optional unless Timeseries Aggregation is selected
2022
v1.94, 14 Oct 2022
Fixed live update issue
v1.93, 26 Sep 2022
Handle sub-queries within the ADX query
v1.92, 30 Jun 2022
When the app page does not supply query parameter values during runtime, the Connector will use the original values that were specified as query parameters in the ADX query
v1.91, 28 Jun 2022
Disable default date filter parameters when using query parameters
v1.90, 27 Jun 2022
Implemented query parameters functionality
v1.83, 22 Jun 2022
Optimized aggregation query using shuffle strategy and materialize function
v1.82, 22 Jun 2022
All non-numeric columns are added by default to the group by clause when using aggregation
Changed the KQL operator from contains to has in filter module for better performance
v1.81, 21 Jun 2022
Added help text to the Aggregation Parameters section: at least one column must be numeric
v1.80, 16 Jun 2022
Added live update functionality
v1.70, 14 Jun 2022
Added Timeseries dynamic aggregation functionality
2021
v1.60, 30 Nov 2021
Resolved minor issue to make Sort, Take, and Order work at the source i.e. ADX
v1.50, 01 Sep 2021
Added Insert and Update operations to the entity to support refresh on button click without actual insert/update functionality
v1.40, 28 Jun 2021
Fixed issue with GetCustomQueryColumns
v1.30, 25 Jun 2021
Name change
v1.20, 24 Jun 2021
Non-static with token caching and HttpClient
v1.10, 23 Jun 2021
Non-static without token caching
v1.00, 23 Jun 2021
Initial Release
Last updated