sqldw-authoring-cli

通过命令行执行 Fabric 数仓与 SQL 端点的 T-SQL 编写、装载和变更操作。

星标

★ 420

来源

GitHub

更新于

2026-06-07

// 安全评估低风险

仅提示词，不执行代码
开源可审计
社区验证· 420

正在进行安全审计…

凭证密钥
网络外发
代码执行
数据访问
来源供应链

// 安装

复制安装指令，让 AI 自动完成配置 · 推荐新手

请帮我安装 askskill 上的 "sqldw-authoring-cli" 技能：
1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-authoring/skills/sqldw-authoring-cli/SKILL.md
2. 保存为 ~/.claude/skills/sqldw-authoring-cli/SKILL.md
3. 装好后重载技能，告诉我可以用了

// 下载

下载 SKILL.md机读安装清单 ↗

// 用法示例

创建并修改数仓表

输入

请为 Microsoft Fabric Data Warehouse 生成一组可在 CLI 中执行的 T-SQL：先创建 sales.orders 表，包含 order_id、customer_id、order_date、amount 字段；再新增 status 字段并为 order_id 建主键。请按执行顺序输出，并附上简短说明。

预期产出

一组按顺序组织的建表与改表 T-SQL 语句，适合直接在命令行环境执行。

用 COPY INTO 导入数据

输入

请生成在 Fabric Warehouse 中通过 T-SQL 执行的数据导入脚本：从 ADLS 路径加载 parquet 文件到 dbo.fact_sales，使用 COPY INTO，并包含基本错误处理与事务控制建议。

预期产出

可执行的 COPY INTO 导入脚本，包含目标表、来源路径及必要的执行注意事项。

编写合并更新脚本

输入

我需要一个适用于 Microsoft Fabric SQL 端点的 T-SQL 脚本：将 staging.customer_updates 的数据合并到 dbo.customers，根据 customer_id 匹配后更新 name 和 email，不存在时插入新记录。请生成 MERGE 语句，并说明如何在 CLI 的 ETL 脚本中调用。

预期产出

一段用于增量同步的 MERGE T-SQL，以及在命令行 ETL 流程中集成调用的简要示例。

// 文档

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-updates skill.

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

SQL Endpoint Authoring — CLI Skill

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