skills.rest
9vantage
9vantageCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

eventhouse-authoring-cli

Execute KQL management commands against Fabric Eventhouse and KQL Databases via Azure CLI.

Updated Jul 14, 2026
Search Tags:#ingestion#fabric#azure cli#kql#materialized views#eventhouse#schema deployment
One-click install
npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill eventhouse-authoring-cli-9vantage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: eventhouse-authoring-cli
Source: https://github.com/9vantage/skills-for-fabric-clone/tree/main/plugins/fabric-authoring/skills/eventhouse-authoring-cli
Command: npx skills add https://github.com/9vantage/skills-for-fabric-clone --skill eventhouse-authoring-cli-9vantage

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve? Authoring Fabric Eventhouse and KQL Database objects—tables, ingestion mappings, policies, functions, and materialized views—requires precise KQL management commands and correct REST API authentication, which is error-prone when done manually. ## Core Features & Use Cases - Table and Schema Management: Create, alter, and drop KQL tables idempotently using .create-merge and .alter-merge commands via az rest. - Data Ingestion: Ingest data inline, from Blob Storage, or from OneLake with CSV/JSON ingestion mappings. - Policies and Views: Configure retention, caching, and streaming ingestion policies, plus materialized views, stored functions, and update policies. - Schema Deployment: Deploy multi-command .kql schema files and export existing schemas for CI/CD using ready-made Bash and PowerShell templates. - Use Case: A data engineer needs to create a SensorData table with a 90-day retention policy, hot caching, and a JSON ingestion mapping in a Fabric Eventhouse—this Skill generates and executes the exact KQL commands. ## Quick Start Ask the AI to create a KQL table with retention and caching policies in your Fabric Eventhouse using this skill.

Frequently Asked Questions about eventhouse-authoring-cli

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

FAQPage Schema
How do I create a KQL table in Fabric Eventhouse using CLI?▼

Use the `.create-merge table` command sent via `az rest` POST to the cluster's `/v1/rest/mgmt` endpoint with resource `https://kusto.kusto.windows.net`. The `.create-merge` variant is idempotent, so it safely adds columns without failing on existing tables.

How to ingest data into Eventhouse from OneLake or Blob Storage?▼

Use `.ingest into table` 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 with the source fields.

What permissions are required for KQL management commands in Eventhouse?▼

Authoring operations require the Admin or Ingestor database role on the KQL Database. Without these roles, management commands return a 403 Forbidden error; verify access with `.show database principals` before authoring.

Why does KQL ingestion succeed but the table stays empty?▼

This usually means the ingestion mapping does not match the source data's column order or field names. Check existing mappings with `.show table T ingestion csv mappings` and create an explicit mapping referencing the correct ordinals or JSON paths.

Can I deploy KQL schema changes through CI/CD scripts?▼

Yes. Save management commands one per line in a `.kql` file and execute each via `az rest` in a loop using the provided Bash or PowerShell templates. Export the current schema with `.show database DB schema as csl script` for version control.

Related Skills

Explore More Data & Analytics Skills→
microsoftmicrosoft
952

eventhouse-authoring-cli

Automate KQL management and Eventhouse authoring tasks via CLI.

Official
Advanced
weiflycc-cmdweiflycc-cmd

powerbi-consumption-cli

Execute DAX queries against Microsoft Fabric Power BI semantic models for metadata discovery and data retrieval.

Community
Intermediate
jonkikyjonkiky

canary

Monitor live app health and alert on regressions during deployments.

Community
Intermediate
air-gappedair-gapped
5

vllm-nvidia-hardware

Size NVIDIA vLLM deployments by hardware SKU, power, and facility readiness.

Official
Advanced