$ loading_
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。
复制安装指令，让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "sqldw-consumption-cli" 技能： 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/sqldw-consumption-cli/SKILL.md 2. 保存为 ~/.claude/skills/sqldw-consumption-cli/SKILL.md 3. 装好后重载技能，告诉我可以用了
请为 Fabric Lakehouse SQL Endpoint 生成只读 T-SQL，统计 sales_orders 表总行数，并按 order_status 分组计数，结果按数量降序排列。
一段可执行的 T-SQL 查询，返回总行数和按状态分组的统计结果。
我想了解 Fabric Data Warehouse 中 customer_profile 表的结构，请生成只读 T-SQL，列出字段名、数据类型、是否可为空，并附上查看前 10 行数据的查询。
用于查看表结构和预览样例数据的两段只读 T-SQL 脚本。
请生成一个只读 T-SQL 查询，从 warehouse 中筛选近30天高于1000元的订单，返回订单号、客户ID、金额和日期，并说明如何将结果导出为 CSV 或 JSON。
一段带筛选条件的 T-SQL 查询，以及导出结果为 CSV/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 |
| 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 |
…