$ loading_
通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。
复制安装指令，让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "sqldw-authoring-cli" 技能： 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/skills/sqldw-authoring-cli/SKILL.md 2. 保存为 ~/.claude/skills/sqldw-authoring-cli/SKILL.md 3. 装好后重载技能，告诉我可以用了
请为 Microsoft Fabric Data Warehouse 生成一组可在 CLI 中执行的 T-SQL：先创建 sales.orders 表，包含 order_id、customer_id、order_date、amount 字段；然后新增 status 字段并为 order_id 创建主键。请按执行顺序输出，并补充简短注释。
一套可直接执行的建表与改表 T-SQL 脚本，包含必要注释与顺序。
请生成用于 Fabric Warehouse 的 T-SQL 装载脚本：从 ADLS 路径加载 Parquet 文件到 dbo.fact_sales，使用 COPY INTO，并加入基础错误处理与装载前后的行数检查。
一份包含 COPY INTO、校验步骤和基础容错逻辑的数据装载脚本。
请编写适用于 Fabric SQL 端点的 T-SQL：把 staging.customer_updates 中的数据合并到 dbo.customers，使用 MERGE 实现插入和更新；同时加上显式事务、异常回滚，以及对并发冲突的处理建议。
一份包含 MERGE、事务控制、回滚处理和并发建议的完整脚本。
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 |
| Definition Envelope | ITEM-DEFINITIONS-CORE.md § Definition Envelope | Definition payload structure |
| Per-Item-Type Definitions | ITEM-DEFINITIONS-CORE.md § Per-Item-Type Definitions | Support matrix, decoded content, part paths — REST specs, CLI recipes |
| Job Execution | COMMON-CORE.md § Job Execution | |
| Capacity Management | COMMON-CORE.md § Capacity Management | |
| Gotchas, Best Practices & Troubleshooting (Platform) | 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 |
…
帮助你查询 Fabric Eventhouse 数据、分析时序趋势并监控摄取状态。
帮助你列出、解析并检查 Microsoft Fabric Eventstream 的拓扑与配置状态。
用自然语言查询 Power BI 报表与仪表板，快速获得业务数据答案。
通过命令行对 Fabric 仓库与湖仓数据执行只读 T-SQL 查询、探查与导出。
帮助将 Azure Synapse Spark 工作负载迁移到 Microsoft Fabric 并完成代码替换。
帮助你在 Fabric 中创建告警、通知与事件自动化处置流程。
通过命令行分析 Fabric 数据仓库性能瓶颈并给出优化建议。
通过 CLI 与 MCP 统一管理 Microsoft Fabric 数据仓库和 SQL 分析终结点。
通过命令行创作与管理 Fabric Dataflows Gen2，并预览查询和触发刷新。
连接 Microsoft Fabric 数据仓库与 SQL 分析端点的 MCP 服务。
帮助你开发 Microsoft Fabric Spark 工作流、编写调试 Notebook 代码并管理湖仓与资源。
用于执行 DAX 查询并检查 Fabric Power BI 语义模型元数据。