eventhouse-authoring-cli

Create and manage KQL database objects and ingestion commands for Fabric Eventhouse.

3|6|Updated Jun 21, 2024
One-click install
npx skills add https://github.com/rritec/Microsoft-Fabric --skill eventhouse-authoring-cli-rritec
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: eventhouse-authoring-cli
Source: https://github.com/rritec/Microsoft-Fabric/tree/main/skills/plugins/fabric-authoring/skills/eventhouse-authoring-cli
Command: npx skills add https://github.com/rritec/Microsoft-Fabric --skill eventhouse-authoring-cli-rritec

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill removes the manual friction of authoring and deploying KQL changes in Fabric Eventhouse by turning table, ingestion, policy, function, and view operations into repeatable CLI-driven steps.

Core Features & Use Cases

  • Table Management: Create, merge, alter, and drop KQL tables safely with idempotent commands.
  • Data Ingestion: Load data inline, from Blob Storage, or from OneLake while handling mappings and impersonation requirements.
  • Operational Control: Configure retention, caching, streaming ingestion, update policies, and materialized views for production databases.
  • Use Case: A data engineer can use this Skill to deploy a new Eventhouse schema, ingest sample data, and verify policies without manually composing ad hoc commands.

Quick Start

Use this skill to create or update a Fabric Eventhouse table, ingest data into it, and verify the resulting schema and policies.

Frequently Asked Questions about eventhouse-authoring-cli

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

FAQPage Schema
How do I manage KQL database objects and ingestion commands for Fabric Eventhouse?

You can manage Fabric Eventhouse KQL databases by executing JSON-based management commands through the Kusto REST API to handle table creation, data loading, and policy configuration.

What do I need to set up before authoring KQL changes in Fabric Eventhouse?

Authoring KQL changes in Fabric Eventhouse requires Azure CLI authentication, a KQL cluster URI, elevated database roles, and JSON-based management commands prepared for execution.

How does data ingestion from Blob Storage or OneLake into a KQL table work?

Data ingestion into KQL tables works by loading data inline, from Blob Storage, or from OneLake while handling mappings and impersonation requirements via CLI-driven steps.

Can I configure retention, caching, and materialized views for a production Eventhouse database?

Yes, you can configure retention, caching, streaming ingestion, update policies, and materialized views for production Eventhouse databases using operational control commands.

What is the best way to automate KQL schema deployment and data policies in Microsoft Fabric?

The best way to automate KQL schema deployment and data policies in Microsoft Fabric is using repeatable CLI-driven steps to safely create, merge, alter, and drop tables idempotently.

Why should I use CLI commands instead of manual authoring for Fabric Eventhouse update-policy workflows?

Using CLI commands removes the manual friction of authoring update-policy workflows in Fabric Eventhouse by turning operational control and table management into repeatable steps.