Eventhouse Consumption Cli
Discover Eventhouse/KQL table schemas, functions, and materialized views during agentic analytics workflows on Microsoft Fabric.
Overview
eventhouse-consumption-cli is an agent skill for the Grow phase that supplies KQL schema discovery queries for Fabric Eventhouse consumption and agentic exploration.
Install
npx skills add https://github.com/microsoft/skills-for-fabric --skill eventhouse-consumption-cliWhat is this skill?
- Table discovery with row counts and size via .show tables details
- Schema export as JSON or CSL including compact cslschema projections
- Column statistics and sample-based profiling summarize patterns
- Function and materialized view listing with folder filters
- Structured reference blocks for agentic discovery workflows
- Sample profiling pattern uses take 10000 rows before summarize
Adoption & trust: 50 installs on skills.sh; 427 GitHub stars; 3/3 security scanners passed (skills.sh audits).
What problem does it solve?
You need to query Eventhouse but do not know table names, column types, functions, or materialized views available in the workspace.
Who is it for?
Solo builders or agents exploring Fabric Eventhouse metadata before dashboards, alerts, or ad hoc KQL analysis.
Skip if: Greenfield ingestion design, warehouse modeling from scratch, or teams not on Microsoft Fabric/KQL.
When should I use this skill?
Agentic discovery on Fabric Eventhouse when you need table, column, function, or materialized view metadata via KQL.
What do I get? / Deliverables
You run documented .show and profiling KQL to map schema, stats, and views so follow-on analytics or agent steps use correct entities.
- Executable KQL discovery snippets for tables and schema
- Profiling queries for column cardinality and null rates
Recommended Skills
Journey fit
Schema discovery supports measuring and understanding data after you have pipelines—not greenfield app UI work. KQL .show commands and profiling summarize are classic analytics exploration on a consumption cluster.
How it compares
KQL discovery cookbook for Eventhouse—not a generic SQL migration skill or a BI dashboard MCP.
Common Questions / FAQ
Who is eventhouse-consumption-cli for?
Builders and coding agents working in Microsoft Fabric Eventhouse who need fast schema, function, and materialized view discovery via KQL.
When should I use eventhouse-consumption-cli?
Use it during Grow analytics when you must list tables, inspect columns, profile samples, or discover functions and materialized views before writing consumption queries.
Is eventhouse-consumption-cli safe to install?
Check the Security Audits panel on this Prism page; the skill implies running KQL against your cluster—review permissions and data sensitivity before automated .show commands.
SKILL.md
READMESKILL.md - Eventhouse Consumption Cli
# KQL Schema Discovery Queries Reference for schema exploration commands used during agentic discovery workflows. --- ## Table and Column Discovery ### Table Discovery ```kql // List all tables with row counts and sizes .show tables details | project TableName, TotalRowCount, TotalOriginalSize, TotalExtentSize, HotOriginalSize // List tables (names only) .show tables | project TableName // Table schema (column names, types, folder) .show table MyTable schema as json // Table schema as CSL (for scripting) .show table MyTable cslschema // Compact column listing (CSL format) .show table MyTable cslschema | project TableName, Schema ``` ### Column Statistics ```kql // Column cardinality and statistics (sample-based) .show table MyTable column statistics // Quick column profiling via query MyTable | take 10000 | summarize Rows = count(), Nulls = countif(isnull(ColumnName)), Distinct = dcount(ColumnName), MinVal = min(ColumnName), MaxVal = max(ColumnName) ``` --- ## Function and View Discovery ### Function Discovery ```kql // List all stored functions .show functions | project Name, Parameters, Body = substring(Body, 0, 100), DocString, Folder // Full function definition .show function MyFunction // Functions in a folder .show functions | where Folder == "Analytics" ``` ### Materialized View Discovery ```kql // List all materialized views .show materialized-views | project Name, SourceTable, Query = substring(Query, 0, 100), IsEnabled, IsHealthy // View statistics (lag, processed records) .show materialized-view MyView statistics // View extents .show materialized-view MyView extents | summarize ExtentCount = count(), TotalRows = sum(RowCount) ``` --- ## Policy Discovery ```kql // Retention policies .show table MyTable policy retention // Caching policies .show table MyTable policy caching // All major policies for a table (run individually) // retention, caching, streamingingestion, update, merge, sharding // Streaming ingestion policy .show table MyTable policy streamingingestion // Update policies .show table MyTable policy update ``` --- ## External Tables and Ingestion Mappings ### External Table Discovery ```kql // List external tables .show external tables | project TableName, TableType, Folder, ConnectionStrings // External table schema .show external table MyExternalTable schema as json ``` ### Ingestion Mapping Discovery ```kql // CSV mappings for a table .show table MyTable ingestion csv mappings // JSON mappings for a table .show table MyTable ingestion json mappings // All mappings for a table .show table MyTable ingestion mappings ``` --- ## Security Discovery ```kql // Database-level principals .show database MyDatabase principals // Table-level principals .show table MyTable principals // Current identity print CurrentUser = current_principal(), Cluster = current_cluster_endpoint() ``` --- ## Database Overview Script Run this sequence to get a complete picture of a KQL Database: ```kql // 1. Database stats (uses current database context) .show database datastats // 2. All tables with details .show tables details | project TableName, TotalRowCount, TotalOriginalSize, CachingPolicy | order by TotalRowCount desc // 3. All functions .show functions | project Name, Folder, DocString, Parameters // 4. All materialized views .show materialized-views | project Name, SourceTable, IsEnabled, IsHealthy // 5. All external tables .show external tables ``` --- name: eventhouse-consumption-cli description: > Run KQL queries against Fabric Eventhouse for real-time intelligence and time-series analytics using `az rest` against the Kusto REST API. Covers KQL operators (where, summarize, join, render), Eventhouse schema discovery (.show tables), time-series patterns with bin(), and ingestion monitoring. Use when the user wants to: 1. Run read-only KQL queries against an Eventhouse or KQL Database 2. Discover Eventhouse table schema and metadata