skills.rest
weiflycc-cmd
weiflycc-cmdCOMMUNITY
Explore all skills by this author →
GitHub

eventhouse-consumption-cli

Execute read-only KQL queries against Microsoft Fabric Eventhouse via CLI.

Updated Jun 1, 2026
Search Tags:#azure#data query#time-series#kql#kusto#eventhouse#microsoft fabric
One-click install
npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill eventhouse-consumption-cli-weiflycc-cmd
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: eventhouse-consumption-cli
Source: https://github.com/weiflycc-cmd/skills-for-fabric/tree/main/plugins/fabric-skills/skills/eventhouse-consumption-cli
Command: npx skills add https://github.com/weiflycc-cmd/skills-for-fabric --skill eventhouse-consumption-cli-weiflycc-cmd

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the need for manual portal navigation to run read-only KQL queries against Fabric Eventhouse and KQL Databases, enabling data analysts and engineers to quickly explore real-time and time-series data, monitor ingestion health, and generate insights directly from the command line.

Core Features & Use Cases

  • Read-Only KQL Query Execution: Run KQL queries using standard operators (where, summarize, join, render) against Eventhouse and KQL Databases via the Kusto REST API.
  • Schema & Metadata Discovery: Explore table schemas, functions, materialized views, policies, and ingestion mappings to understand data structure before writing queries.
  • Real-Time & Operational Monitoring: Track active KQL queries, ingestion failures, and command history to diagnose performance and data freshness issues.
  • Use Case: For example, a data analyst can use this Skill to quickly discover tables in an Eventhouse, sample 10 rows of an AppEvents table, and run a time-series query to count errors per source over the last hour to identify outages.

Quick Start

Use the eventhouse-consumption-cli skill to run a KQL query that counts error events from the AppEvents table in your Fabric Eventhouse over the last 2 hours, grouped by source.

Frequently Asked Questions about eventhouse-consumption-cli

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

FAQPage Schema
How do I run KQL queries against a Microsoft Fabric Eventhouse from the command line?▼

You can run KQL queries against a Microsoft Fabric Eventhouse from the command line by using a Skill that leverages the Kusto REST API via `az rest` to execute read-only operations for real-time data exploration.

Can I discover table schemas and ingestion mappings in a KQL Database without using the Azure portal?▼

Yes, you can discover table schemas, functions, materialized views, policies, and ingestion mappings in a KQL Database directly via CLI, eliminating the need for manual portal navigation to understand data structure.

Do I need Azure CLI authentication to query time-series data in a Fabric Eventhouse?▼

Yes, querying time-series data in a Fabric Eventhouse requires Azure CLI authentication, along with valid access to the Fabric workspace and KQL Database, to authorize Kusto REST API operations.

How does CLI-based KQL query execution compare to using standard data analytics tools for Microsoft Fabric?▼

CLI-based KQL query execution enables quick data exploration and operational diagnostics via `az rest` without portal navigation, whereas standard data analytics tools often provide visual interfaces but may lack direct command-line automation for ingestion monitoring.

What are the limitations of running read-only KQL queries for real-time intelligence via CLI?▼

The approach is limited to read-only KQL queries, meaning you cannot perform data ingestion or schema modifications, and it depends entirely on existing KQL Database permissions and Fabric workspace access for operational diagnostics.

Can I monitor KQL Database ingestion failures and active queries using command line tools?▼

Yes, you can monitor KQL Database ingestion failures, track active queries, and review command history using command line tools to diagnose performance and data freshness issues in your Fabric Eventhouse.

Related Skills

Explore More Data & Analytics Skills→
patrikboroschpatrikborosch
14

eventhouse-authoring-cli

Manage KQL database objects, ingestion workflows, and policies for Microsoft Fabric Eventhouse via Azure CLI.

Community
Intermediate
yangchuanshengyangchuansheng
9

World Bank Open Data — Scraping & Data Extraction

Query the World Bank indicators API and extract newest non-null values.

Community
Intermediate
patrikboroschpatrikborosch
14

eventhouse-consumption-cli

Runs read-only KQL queries against Microsoft Fabric Eventhouse via command-line.

Community
Intermediate
jgezelscorpjgezelscorp

azure-kusto

Execute KQL queries against Azure Data Explorer for log analytics.

Community
Advanced