$ loading_
通过命令行对 Fabric 仓库与 Lakehouse 执行只读 T-SQL 查询、探查与导出数据。
复制安装指令，让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "sqldw-consumption-cli" 技能： 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-consumption/skills/sqldw-consumption-cli/SKILL.md 2. 保存为 ~/.claude/skills/sqldw-consumption-cli/SKILL.md 3. 装好后重载技能，告诉我可以用了
请对 Lakehouse 中的 sales_orders 表执行只读 T-SQL 查询，统计总行数，并返回可直接运行的 SQL 语句与查询结果说明。
返回 COUNT(*) 查询语句，以及表总行数的简要说明。
请帮我查看 Fabric Data Warehouse 里 customers 表的字段名、数据类型和是否可为空，并用 T-SQL 展示查询方式。
返回用于查看表结构的 T-SQL，以及字段与类型的结构化结果说明。
请查询 SQL Endpoint 中最近30天状态为 completed 的订单，按地区汇总数量与金额，并导出为 CSV。
返回筛选与聚合的 T-SQL、按地区汇总结果，并说明 CSV 导出方式或导出结果。
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 | |
| 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 | Includes pagination, LRO polling, and rate-limiting patterns |
| 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, Best Practices & Troubleshooting | COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting | |
| 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; includes pagination and LRO helpers |
OneLake Data Access via curl | COMMON-CLI.md § OneLake Data Access via curl | Use curl not az rest (different token audience) |
| SQL / TDS Data-Plane Access | COMMON-CLI.md § SQL / TDS Data-Plane Access | sqlcmd (Go) connect, query, CSV export |
| Job Execution (CLI) | COMMON-CLI.md § Job Execution | |
| OneLake Shortcuts | COMMON-CLI.md § OneLake Shortcuts | |
| Capacity Management (CLI) | COMMON-CLI.md § Capacity Management | |
| Composite Recipes | COMMON-CLI.md § Composite Recipes | |
| Gotchas & Troubleshooting (CLI-Specific) | COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific) | az rest audience, shell escaping, token expiry |
…
帮助你开发 Microsoft Fabric Spark 与数据工程流程，编写调试 Notebook 代码并管理湖仓资源。
通过命令行分析 Fabric 数据仓库性能，定位慢查询与资源压力并给出优化建议。
通过只读 API 检查 Fabric 中现有告警、通知与自动化动作配置
检查 skills-for-fabric 技能集是否有更新，并展示版本差异与更新日志。
帮助你查询 Fabric Eventhouse 数据、分析时序趋势并监控摄取状态。
用自然语言查询 Power BI 报表与仪表板，快速获得业务数据答案。
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和架构变更操作。
通过命令行分析 Fabric 数据仓库性能瓶颈并给出优化建议。
通过 PySpark 与 Livy 会话交互分析 Lakehouse 数据，支持高级计算与跨仓查询。