azure-kusto

1# Azure Data Explorer (Kusto) Query & Analytics
2 
3Execute KQL queries and manage Azure Data Explorer resources for fast, scalable big data analytics on log, telemetry, and time series data.
4 
5## Overview
6 
7This skill enables querying and managing Azure Data Explorer (Kusto), a fast and highly scalable data exploration service optimized for log and telemetry data. Azure Data Explorer provides sub-second query performance on billions of records using the Kusto Query Language (KQL).
8 
9Key capabilities:
10- **Query Execution**: Run KQL queries against massive datasets
11- **Schema Exploration**: Discover tables, columns, and data types
12- **Resource Management**: List clusters and databases
13- **Analytics**: Aggregations, time series, anomaly detection, machine learning
14 
15## Core Workflow
16 
171. **Discover Resources**: List available clusters and databases in subscription. If the target table's location is unknown and multiple candidate clusters, databases, or Log Analytics workspaces exist, batch the search (see Pattern 6) and only report "not found" after all candidates are checked.
182. **Explore Schema**: Retrieve table structures to understand data model
193. **Query Data**: Execute KQL queries for analysis, filtering, aggregation
204. **Analyze Results**: Process query output for insights and reporting
21 
22## Query Patterns
23 
24### Pattern 1: Basic Data Retrieval
25Fetch recent records from a table with simple filtering.
26 
27**Example KQL**:
28```kql
29Events
30| where Timestamp > ago(1h)
31| take 100
32```
33…