skills.rest
paulasilvatech
paulasilvatechOFFICIAL
Explore all skills by this author →
GitHub

eventhouse-cli

Author and query Fabric Eventhouse KQL databases via Azure CLI and REST APIs.

Updated Aug 19, 2026
Search Tags:#data ingestion#time-series#az CLI#Kusto#kql#eventhouse#microsoft fabric
One-click install
npx skills add https://github.com/paulasilvatech/Fabric-Agentic-SDLC --skill eventhouse-cli-paulasilvatech
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: eventhouse-cli
Source: https://github.com/paulasilvatech/Fabric-Agentic-SDLC/tree/main/.github/skills/eventhouse-cli
Command: npx skills add https://github.com/paulasilvatech/Fabric-Agentic-SDLC --skill eventhouse-cli-paulasilvatech

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Working with Microsoft Fabric Eventhouse and KQL databases requires knowing the correct Kusto REST endpoints, token audiences, and management command syntax, and mistakes in payload shape or authentication produce failed or wrong operations. This Skill provides the exact CLI patterns for both schema management and read-only analytics. ## Core Features & Use Cases - KQL Authoring: Create and alter tables, functions, materialized views, retention and caching policies, ingestion mappings, and update policies using idempotent .create-merge and .create-or-alter commands via az rest. - Read-Only KQL Consumption: Run analytical queries, discover schema with .show commands, monitor ingestion health, and export results to JSON or CSV with jq. - Use Case: A data engineer needs a KQL table for a sensor feed with a 30-day retention policy and CSV ingestion mapping. The Skill resolves the workspace and cluster URI, executes the management commands against the live KQL database, and verifies the deployed schema. ## Quick Start Ask the AI to create a KQL table with a retention policy in your Fabric Eventhouse, or to run a KQL query summarizing events per hour over the last day.

Frequently Asked Questions about eventhouse-cli

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

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

Run KQL queries by POSTing a JSON body with the database name and query to the cluster's /v1/rest/query endpoint using az rest with the https://kusto.kusto.windows.net resource. Write the body to a temp file because KQL pipe characters break inline shell escaping.

How to create a KQL table and set a retention policy in Microsoft Fabric?▼

Create tables with the idempotent .create-merge table command and set retention with .alter table policy retention, both sent to the /v1/rest/mgmt endpoint. Authoring requires the Admin or Ingestor role on the KQL database.

What is the difference between Eventhouse authoring and consumption modes?▼

Consumption mode runs only read-only KQL queries and .show commands for exploration and monitoring. Authoring mode handles state-changing commands like .create, .alter, .ingest, and .drop for schema, policies, and ingestion management.

Why does az rest fail with a 401 when querying a KQL database?▼

A 401 occurs when the wrong token audience is used. KQL data-plane calls require --resource https://kusto.kusto.windows.net, while Fabric control-plane calls require --resource https://api.fabric.microsoft.com.

Can I ingest data into a KQL database from OneLake or Blob Storage?▼

Yes, use the .ingest into table command with an abfss:// OneLake URI or Blob Storage URI, appending ;impersonate for authentication. For CSV or JSON data, create an ingestion mapping first so columns align correctly.

When should I use eventstream-cli instead of eventhouse-cli?▼

Use eventstream-cli for streaming ingestion topology such as eventstream configuration and routing. Use eventhouse-cli for anything expressed in KQL or stored in a KQL database, including tables, queries, and policies.

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
AradotsoAradotso
5

power-bi-retail-analytics-dashboard

Construct interactive Power BI dashboards for retail sales analytics.

Official
Advanced
ThomazRossitoThomazRossito
4

fabric-eventhouse-rti

Design real-time data pipelines in Microsoft Fabric using Eventstream, Eventhouse, KQL, and Activator.

Community
Advanced
ThomazRossitoThomazRossito
4

sql-generation

Generates SQL syntax for Databricks, Fabric Synapse, and KQL Eventhouse platforms.

Community
Basic