Run real-time queries against Azure Data Explorer
K
Kevin Puventhiranathan
Enable the ability to run real-time queries against Azure Data Explorer (ADX) directly within Port pages, allowing users to aggregate and correlate data from both Port and ADX using KQL (Kusto Query Language).
Leveraging Microsoft’s ADX query capabilities as described in their integration documentation (https://learn.microsoft.com/en-us/azure/data-explorer/integrate-query-overview?tabs=connectors) should make it possible to achieve:
1) Real-time execution of KQL queries against ADX clusters directly from Port pages.
2) Context-aware querying, where:
- Port entity fields (e.g., service name, team, environment, tags) can be injected into KQL queries dynamically.
3) Cross-data aggregation, enabling:
- KQL queries that join or filter based on Port metadata.
4) Embedded query widgets within Port dashboards/pages:
- Tabular results
- Charts (time series, aggregates)
- Aggregations (counts, percentiles, error rates, etc.)