skills.rest
rritec
rritecCOMMUNITY
Explore all skills by this author →
Website𝕏@rritecGitHub

eventhouse-consumption-cli

Run read-only KQL queries against Fabric Eventhouse via az rest.

3|6|Updated Jun 21, 2024
Search Tags:#cli#time-series#fabric#kql#kusto#schema discovery#eventhouse
One-click install
npx skills add https://github.com/rritec/Microsoft-Fabric --skill eventhouse-consumption-cli-rritec
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: eventhouse-consumption-cli
Source: https://github.com/rritec/Microsoft-Fabric/tree/main/skills/plugins/fabric-skills/skills/eventhouse-consumption-cli
Command: npx skills add https://github.com/rritec/Microsoft-Fabric --skill eventhouse-consumption-cli-rritec

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill removes the friction of exploring Fabric Eventhouse and KQL Database data by letting you run safe, read-only KQL queries from the command line. It helps you discover schemas, inspect live ingestion and query activity, and analyze real-time or time-series data without manually piecing together REST calls.

Core Features & Use Cases

  • Read-only KQL execution: Run queries against Eventhouse or KQL Database endpoints using az rest and the Kusto REST API.
  • Schema and metadata discovery: Inspect tables, columns, functions, views, policies, and security settings before writing targeted queries.
  • Real-time analytics workflows: Use KQL operators such as where, summarize, join, render, and bin to analyze event streams and time-series patterns.
  • Operational monitoring: Check ingestion failures, active queries, and recent commands to troubleshoot stale or slow data.
  • Practical export and reporting: Save query results to JSON or transform them for downstream analysis.
  • Use case: A data analyst needs to find error spikes in the last hour, discover the relevant table schema, and export the result set for reporting without leaving the terminal.

Quick Start

Ask the Skill to discover your Eventhouse tables, inspect the schema of the most relevant table, and generate a read-only KQL query for the analysis you want.

Frequently Asked Questions about eventhouse-consumption-cli

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

FAQPage Schema
How do I query Fabric Eventhouse data from the command line?▼

Query Eventhouse or KQL Database schemas by executing read-only KQL queries through the az rest command against the Kusto REST API, inspecting tables, columns, functions, and policies before writing targeted analysis queries.

What is the best way to discover schemas in a KQL Database without writing manual REST calls?▼

Schema discovery in a KQL Database is handled by executing read-only KQL queries through the az rest command against the Kusto REST API, inspecting tables, columns, functions, views, and policies directly from your terminal.

Can I monitor real-time ingestion failures and active queries in Fabric Eventhouse via CLI?▼

Yes, you can monitor ingestion failures and active queries in Fabric Eventhouse via CLI by running read-only KQL queries that inspect live ingestion activity, recent commands, and active query statuses directly from the terminal.

Does this approach require write access to run time-series analysis on Eventhouse data?▼

No, running time-series analysis on Eventhouse data does not require write access because the process executes safe, read-only KQL queries using operators like where, summarize, join, render, and bin to analyze event streams.

How do I export KQL query results to JSON from a Fabric Eventhouse?▼

Export KQL query results to JSON from a Fabric Eventhouse by running read-only queries via the az rest command against the Kusto REST API, returning data suitable for saving to JSON files or transforming for downstream analysis workflows.

Related Skills

Explore More Data & Analytics Skills→
weiflycc-cmdweiflycc-cmd

eventhouse-consumption-cli

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

Community
Intermediate
Manvendra08Manvendra08
1

clickhouse-io

Design, optimize, and operate ClickHouse databases for high-volume analytical workloads.

Community
Intermediate
HouseGarofaloHouseGarofalo
3

fabric-rti-mcp

Query Eventhouse databases with KQL and manage Eventstreams, Activator triggers, and Map items.

Official
Advanced
jgezelscorpjgezelscorp

azure-kusto

Execute KQL queries against Azure Data Explorer for log analytics.

Community
Advanced