通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和架构变更操作。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "sqldw-authoring-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-skills/skills/sqldw-authoring-cli/SKILL.md 2. 保存为 ~/.claude/skills/sqldw-authoring-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为 Microsoft Fabric Data Warehouse 生成一组可在 CLI 中执行的 T-SQL:先创建 sales.orders 表,包含订单ID、客户ID、订单日期、金额字段;再新增订单状态列,并为客户ID创建索引。请按可执行顺序输出,并附简短说明。
一组按顺序组织的建表、修改表和索引创建 T-SQL 脚本,适合终端执行。
请生成适用于 Fabric SQL 端点的 T-SQL 脚本:从 ADLS 路径加载 CSV 到临时表,再将数据 MERGE 到 dbo.customers 目标表,实现更新旧记录并插入新记录;包含 COPY INTO 或 OPENROWSET、事务控制和错误处理示例。
包含数据摄取、暂存、MERGE 合并及事务处理的完整 ETL/ELT T-SQL 示例脚本。
我想在 Lakehouse SQL 端点上创建一个存储过程,用于按日期归档历史订单,并提供发生误删后的恢复思路。请生成创建过程的 T-SQL、调用示例,以及基于快照或时间旅行的恢复步骤说明。
包含存储过程定义、执行语句,以及误删后利用快照或时间旅行恢复数据的说明。
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 |
…