skills.rest
patrikborosch
patrikboroschCOMMUNITY
Explore all skills by this author →
GitHub

eventhouse-authoring-cli

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

14|3|Updated Mar 13, 2026
Search Tags:#data ingestion#analytics engineering#azure cli#schema deployment#fabric eventhouse#kql authoring#kusto rest api
One-click install
npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill eventhouse-authoring-cli-patrikborosch
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: eventhouse-authoring-cli
Source: https://github.com/patrikborosch/AnalyticsPlatformAgents/tree/main/creator/skills/eventhouse-authoring-cli
Command: npx skills add https://github.com/patrikborosch/AnalyticsPlatformAgents --skill eventhouse-authoring-cli-patrikborosch

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill eliminates the manual, error-prone work of managing KQL databases, tables, ingestion pipelines, and policies in Microsoft Fabric Eventhouse, replacing repetitive CLI tasks with automated, idempotent commands that reduce human error and speed up analytics platform deployment.

Core Features & Use Cases

  • KQL Object Management: Create, alter, and drop KQL tables, columns, functions, and materialized views with idempotent commands that avoid duplicate object errors.
  • Ingestion & Policy Configuration: Set up inline, storage, OneLake, and streaming ingestion, plus configure retention, caching, and partitioning policies for optimal performance and cost.
  • Schema Evolution & Deployment: Safely deploy KQL schemas via script files, export existing schemas for version control, and perform zero-downtime schema changes.
  • Use Case: For example, a data engineer can use this Skill to deploy a full IoT Eventhouse schema, set 90-day data retention with 7-day hot cache, and configure CSV ingestion mappings in minutes instead of hours of manual CLI work.

Quick Start

Use the eventhouse-authoring-cli skill to create a new KQL table for sensor data, set a 90-day retention policy, and configure a CSV ingestion mapping for your Fabric Eventhouse.

Frequently Asked Questions about eventhouse-authoring-cli

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

FAQPage Schema
How do I automate KQL table schema creation and data ingestion in Microsoft Fabric Eventhouse?▼

Automate KQL table schema creation and data ingestion in Microsoft Fabric Eventhouse using idempotent Azure CLI commands and the Kusto REST API. This approach eliminates manual setup by deploying tables, columns, and ingestion mappings without duplicate object errors.

Can I configure retention and caching policies for KQL Databases via the Azure CLI?▼

Yes, you can configure retention and caching policies for KQL Databases via the Azure CLI. This allows you to set specific data retention periods and manage hot cache durations to optimize performance and cost within your Fabric Eventhouse.

What permissions do I need to manage KQL database objects and ingestion workflows?▼

To manage KQL database objects and ingestion workflows, you need Azure CLI authentication with appropriate Fabric and Kusto permissions. Specifically, you must have Admin or Ingestor database roles to execute schema and policy commands.

How do I deploy KQL functions and materialized views to Fabric Eventhouse without downtime?▼

Deploy KQL functions and materialized views to Fabric Eventhouse without downtime by executing script files through the Kusto REST API. This enables safe schema evolution, version control exports, and zero-downtime changes to materialized views.

What's the best way to ingest data into KQL Databases from inline or OneLake sources?▼

The best way to ingest data into KQL Databases from inline or OneLake sources is using automated CLI commands. This Skill supports setting up inline, storage, OneLake, and streaming ingestion workflows directly through the Kusto REST API.

How do I resolve workspace and item references when authoring KQL via CLI?▼

Resolve workspace and item references when authoring KQL via CLI by applying JMESPath filtering. This ensures accurate workspace and item resolution before executing Azure CLI commands against your Fabric Eventhouse environment.

Related Skills

Explore More Data & Analytics Skills→
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
wardawgmalviciouswardawgmalvicious
2

fabric-eventhouse

Automate Microsoft Fabric Eventhouse database schema evolution and data ingestion.

Community
Advanced
BagelHoleBagelHole
46

arm-templates

Deploy Azure resources using ARM templates and Bicep with Azure CLI validation.

Community
Intermediate