帮助你开发 Microsoft Fabric Spark 与数据工程流程,编写调试 Notebook 代码并管理湖仓资源。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "spark-authoring-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-skills/skills/spark-authoring-cli/SKILL.md 2. 保存为 ~/.claude/skills/spark-authoring-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
请为 Microsoft Fabric Notebook 编写一个 PySpark 单元:读取 Lakehouse 中的 sales 表,按地区汇总销售额,筛选最近 30 天数据,并把结果保存为 Delta 表 sales_summary_30d。同时给出每段代码的说明。
一段可直接用于 Fabric Notebook 的 PySpark 代码,以及分步骤说明。
我想在 Microsoft Fabric 中设计一个数据工程流程:从原始 CSV 落地到 Bronze、Silver、Gold 分层,包含数据清洗、去重、增量处理和调度建议。请给出 Lakehouse 结构、Notebook 拆分方案和 Delta Lake 最佳实践。
一份分层架构方案,包含流程设计、Notebook 组织方式与实现建议。
请帮我规划 Microsoft Fabric 的开发环境:需要创建工作区、绑定 Lakehouse、配置 Notebook 运行环境,并说明如何用基础设施即代码方式管理部署。请列出推荐步骤、配置项和常见错误排查建议。
一套工作区与湖仓配置清单,外加部署步骤和运维排错建议。
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
This skill covers two complementary areas: (1) managing Fabric Spark artifacts via REST APIs (workspaces, lakehouses, notebooks, jobs, pipelines) and (2) writing code inside Fabric Notebook cells (PySpark, Scala, SparkR, SQL with correct lakehouse access, notebookutils, and Spark configuration). For notebook code authoring fundamentals and shared modules, MUST see SPARK-NOTEBOOK-AUTHORING-CORE.md.
| Task |
|---|
| Reference |
|---|
| Notes |
|---|
| RULES — Read these first, follow them always | SKILL.md § RULES | MUST read — 4 rules for this skill |
| 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 | |
| Pagination | COMMON-CORE.md § Pagination | |
| Long-Running Operations (LRO) | COMMON-CORE.md § Long-Running Operations (LRO) | |
| Rate Limiting & Throttling | COMMON-CORE.md § Rate Limiting & Throttling | |
| 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 & Troubleshooting | COMMON-CORE.md § Gotchas & Troubleshooting | |
| Best Practices | COMMON-CORE.md § Best Practices | |
| Tool Selection Rationale | COMMON-CLI.md § Tool Selection Rationale |
…
检查 skills-for-fabric 技能集是否有更新,并展示版本差异与更新日志。
通过 PySpark 与 Livy 会话交互分析 Lakehouse 数据,支持高级计算与跨仓查询。