skills.rest
microsoft
microsoftOFFICIAL
Explore all skills by this author →
Website𝕏@OpenAtMicrosoftGitHub

azure-kusto

Run KQL queries and analyze data in Azure Data Explorer.

242|189|Updated Oct 28, 2024
Search Tags:#time-series#telemetry#Kusto#log analytics#KQL#Azure Data Explorer#ADX
One-click install
npx skills add https://github.com/microsoft/GitHub-Copilot-for-Azure --skill azure-kusto
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: azure-kusto
Source: https://github.com/microsoft/GitHub-Copilot-for-Azure/tree/main/plugin/skills/azure-kusto
Command: npx skills add https://github.com/microsoft/GitHub-Copilot-for-Azure --skill azure-kusto

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill helps teams quickly query and analyze data stored in Azure Data Explorer (Kusto) using KQL, enabling fast log analytics, telemetry insights, and time-series analysis.

Core Features & Use Cases

  • Query Execution: Run KQL queries against Azure Data Explorer (ADX) clusters and databases.

  • Schema Exploration: Discover tables, columns, and data types.

  • Resource Management: List clusters and databases.

  • Analytics & ML Readiness: Aggregations, time series, anomaly detection, and ML-ready insights.

  • Use Case: Analyze IoT telemetry streams in near real-time or perform security analytics on logs.

Quick Start

Run a basic KQL query to fetch the most recent records from a Kusto table, such as Events, in your ADX cluster.

Frequently Asked Questions about azure-kusto

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run KQL queries for log analytics in Azure Data Explorer?▼

You can run KQL queries for log analytics directly against Azure Data Explorer clusters and databases to fetch recent records, perform aggregations, and produce actionable insights from telemetry logs.

Can I discover table schemas and list databases in my Azure subscription using Kusto?▼

Yes, you can list clusters and databases across an Azure subscription and discover table schemas, columns, and data types to support ad hoc data exploration in Kusto.

What is the best way to perform time-series analysis on IoT telemetry streams?▼

The best way to perform time-series analysis on IoT telemetry is running KQL queries in Azure Data Explorer, which supports aggregations, anomaly detection, and near real-time analytics.

Does Azure Data Explorer support security analytics on logs?▼

Yes, Azure Data Explorer supports security analytics by allowing you to run KQL queries on logs to execute aggregations, detect anomalies, and generate actionable insights.

How do I prepare ML-ready insights from telemetry data stored in Azure Data Explorer?▼

You prepare ML-ready insights by running KQL queries in Azure Data Explorer to perform aggregations and time-series analysis on telemetry data, producing structured outputs for machine learning.

Related Skills

Explore More Data & Analytics Skills→
anishi1222anishi1222

azure-kusto

Execute KQL queries and manage clusters in Azure Data Explorer.

Community
Advanced
jongiojongio
6

azure-kusto

Query and analyze Azure Data Explorer data using KQL.

Community
Intermediate
attentiondotnetattentiondotnet

azure-kusto

Execute KQL queries on Azure Data Explorer for log and telemetry analysis.

Community
Intermediate
mahmoud20138mahmoud20138
10

azure-kusto

Query and analyze Azure Data Explorer data with KQL.

Community
Intermediate