帮助用户对 Fabric Eventhouse 执行 KQL 查询、分析时序数据并查看表结构与摄取状态。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "eventhouse-consumption-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-consumption/skills/eventhouse-consumption-cli/SKILL.md 2. 保存为 ~/.claude/skills/eventhouse-consumption-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为 Fabric Eventhouse 生成只读 KQL 查询,统计最近 1 小时内 error 级别日志的数量,并按 5 分钟分桶,结果按时间升序返回。
一条可执行的 KQL 查询,用于按 5 分钟统计最近一小时错误日志趋势。
请列出 Eventhouse 中所有表,并展示指定表的列名、类型和相关元数据,使用适合 Kusto REST API 的只读命令。
用于发现表清单和表结构的 KQL 或管理命令示例,便于快速了解数据模型。
请生成查询,用于检查 Eventhouse 最近 24 小时的数据摄取状态,包括失败记录、延迟情况和活跃查询信息,并建议以 JSON 导出结果。
一组用于监控摄取与运行状态的 KQL 查询思路或命令,并说明如何导出为 JSON。
Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.
- GitHub Copilot CLI / VS Code: invoke the
check-updatesskill.- Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.
- Skip if the check was already performed earlier in this session.
CRITICAL NOTES
- To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering
- To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering
| Task | Reference | Notes |
|---|---|---|
| Finding Workspaces and Items in Fabric | COMMON-CLI.md § Finding Workspaces and Items in Fabric | Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id] |
| Fabric Topology & Key Concepts | COMMON-CORE.md § Fabric Topology & Key Concepts | |
| Environment URLs | COMMON-CORE.md § Environment URLs | KQL Cluster URI is per-item |
| Authentication & Token Acquisition | COMMON-CORE.md § Authentication & Token Acquisition | Wrong audience = 401; read before any auth issue |
| Core Control-Plane REST APIs | COMMON-CORE.md § Core Control-Plane REST APIs | |
| Pagination | COMMON-CORE.md § Pagination | |
| Long-Running Operations (LRO) | COMMON-CORE.md § Long-Running Operations (LRO) | |
| Rate Limiting & Throttling | COMMON-CORE.md § Rate Limiting & Throttling | |
| OneLake Data Access | COMMON-CORE.md § OneLake Data Access | Requires storage.azure.com token, not Fabric token |
| Job Execution | COMMON-CORE.md § Job Execution | |
| Capacity Management | COMMON-CORE.md § Capacity Management | |
| Gotchas & Troubleshooting | COMMON-CORE.md § Gotchas & Troubleshooting | |
| Best Practices | COMMON-CORE.md § Best Practices | |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale | |
| Authentication Recipes | COMMON-CLI.md § Authentication Recipes | az login flows and token acquisition |
Fabric Control-Plane API via az rest | COMMON-CLI.md § Fabric Control-Plane API via az rest | Always pass --resource https://api.fabric.microsoft.com or az rest fails |
| Pagination Pattern | COMMON-CLI.md § Pagination Pattern | |
| Long-Running Operations (LRO) Pattern | COMMON-CLI.md § Long-Running Operations (LRO) Pattern | |
OneLake Data Access via curl | COMMON-CLI.md § OneLake Data Access via curl | Use curl not az rest (different token audience) |
| Job Execution (CLI) | COMMON-CLI.md § Job Execution | |
| OneLake Shortcuts | COMMON-CLI.md § OneLake Shortcuts |
…
帮助用户查询 Fabric Eventhouse 的 KQL 数据,并进行实时与时序分析监控。
用 PySpark 与 Livy 会话交互分析 Lakehouse 数据并完成高级处理
执行 DAX 查询并检查 Power BI 语义模型元数据,快速获取表、列、度量与关系信息。
帮助你查询、解析并核查 Microsoft Fabric Eventstream 实时管道配置与状态。
帮助将 Databricks 笔记本、作业与数据路径系统迁移到 Microsoft Fabric。
用自然语言查询 Power BI 报表与仪表板,快速获得业务数据答案。
帮助你查询 Fabric Eventhouse 数据、分析时序趋势并监控摄取状态。
通过命令行创建与管理 Eventhouse 的 KQL 架构、导入与策略配置
帮助你列出、解析并检查 Microsoft Fabric Eventstream 的拓扑与配置状态。
帮助你列出、解析并检查 Microsoft Fabric Eventstream 的拓扑与配置健康状态。
通过命令行对 Fabric 仓库与 Lakehouse 执行只读 T-SQL 查询、探查与导出数据。
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。