メニュー
Use when analyzing upstream and downstream impact for table changes, metric changes, field deprecation, pipeline migration, dashboard breakage, data governance review, or data asset dependency communication.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Use when writing a concise daily report, daily worklog, standup update, shift handoff, or end-of-day summary for data analysis, data development, BI, governance, or operations work.
Use when writing or improving data documentation for warehouse tables, metrics, dashboards, SQL jobs, data products, or handover materials so other people and agents can understand data purpose, grain, fields, logic, ownership, and usage constraints.
Use when planning integration with databases, BI tools, data platforms, APIs, workflow systems, storage services, or third-party tools, including connection requirements, API availability, auth strategy, configuration questions, and validation steps.
Use when planning or writing market research for a specific industry, product category, competitor set, business opportunity, user segment, or go-to-market question with structured evidence and clear assumptions.
Use when diagnosing business metric changes or anomalies such as GMV decline, conversion drop, retention loss, churn increase, revenue change, lead decline, or active user fluctuation with a structured root cause analysis plan.
Use when reviewing whether a BI dashboard, management dashboard, metric board, or data product page can support business decisions with clear metrics, trustworthy definitions, and actionable drill-down paths.
| name | data-lineage-impact-analyzer |
| description | Use when analyzing upstream and downstream impact for table changes, metric changes, field deprecation, pipeline migration, dashboard breakage, data governance review, or data asset dependency communication. |
分析数据表、字段、指标、任务或口径变更会影响哪些下游，并输出可执行的影响评估和沟通方案。
这个 Skill 关注变更影响，而不是完整血缘系统建设。
使用这个 Skill，当用户需要：
不要使用这个 Skill 处理：
sql-reviewertable-design-advisordata-incident-postmortem-writer最少输入：
推荐输入：
优先使用这些模板准备上下文：
上下文不足时，只能输出影响评估框架和待补充血缘信息，不要假设不存在的下游。
## 影响评估结论
## 变更说明
## 已知血缘
## 影响清单
| 对象 | 类型 | 影响等级 | 影响说明 | 处理建议 |
| --- | --- | --- | --- | --- |
## 风险与缓解措施
## 上线 / 下线计划
## 通知与协作清单
## 待确认信息
输出必须：
请用 data-lineage-impact-analyzer 评估下面这个字段下线变更。
变更对象：dwd_order_detail_d.old_channel_id
变更类型：字段下线。
原因：渠道归因统一切换到 channel_id_v2。
计划时间：2026-06-10 起停止写入 old_channel_id，2026-06-30 删除字段。
已知下游：
- ads_channel_gmv_1d 使用 old_channel_id 聚合渠道 GMV
- 经营日报渠道模块读取 ads_channel_gmv_1d
- 渠道投放复盘 SQL 中有历史查询使用 old_channel_id
希望输出：影响等级、兼容方案、通知对象、上线前检查和回滚条件。