data-engineering

A guide to data engineering, the work of collecting, moving, processing, and checking data. It covers workflow tools such as Airflow, Dagster, and Prefect, plus streaming and data-quality tools.

In plain words
What is it for?
Planning scheduled data workflows, streaming systems, data checks, retries, alerts, and integrations with databases or storage services.
Why use it?
It provides comparisons and usage patterns for choosing and working with data pipelines, which are automated steps that process data.

Skill for Claude CodeCodex

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

agentmods
npx agentmods add skills/fengshao1227/ccg-workflow/data-engineering
Any agent
npx skills add fengshao1227/ccg-workflow --skill data-engineering
Clone the repo
git clone --depth 1 https://github.com/fengshao1227/ccg-workflow

Made for: Claude Code, Codex.

Per session 53 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,391 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. Scan, not verified.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5 $0.00053 $0.02391
Opus 5 $0.00026 $0.01196
Sonnet 5 $0.00011 $0.00478
Haiku 4.5 $0.00005 $0.00239

Measured yesterday against content hash 50ee1cac4a62, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

data-engineering scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured yesterday.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

Origin

Copies of this mod

2 near-identical copies found in the catalogue:

templates/skills/domains/data-engineering/SKILL.md · 208 lines

How it starts

The opening of the file, as written. The whole thing — 208 lines — stays where its author put it; the contents beside it link to each section on GitHub.

数据工程域 · Data Engineering

域概览

数据工程域涵盖数据管道编排、流式处理、数据质量保障三大核心领域。

数据管道层                流处理层              质量保障层
├── Airflow (调度编排)    ├── Kafka Streams     ├── Great Expectations
├── Dagster (资产管理)    ├── Flink             ├── dbt
└── Prefect (现代工作流)  └── Spark Streaming   └── Soda Core

数据管道编排

框架对比

特性 Airflow Dagster Prefect
核心模型 DAG + Task Asset + Op Flow + Task
学习曲线 陡峭 中等 平缓
资产管理 原生支持
动态任务 支持 支持 支持
本地开发 复杂 简单 简单
社区生态 最大 成长中 成长中

Airflow 核心模式

  • DAG 定义:with DAG(dag_id, schedule, default_args) as dag
  • TaskFlow API:@task 装饰器,自动 XCom 传递
  • 动态任务:@task + .expand() 实现 dynamic task mapping
  • Operators:PythonOperator / BashOperator / SQL / HTTP / S3
  • Sensors:FileSensor / HttpSensor / ExternalTaskSensor
  • 重试策略:retries=3, retry_delay=timedelta(minutes=5), retry_exponential_backoff=True
  • 失败回调:on_failure_callback 发送告警
  • SLA 监控:sla=timedelta(hours=2) + sla_miss_callback

Dagster 核心模式

  • Asset 定义:@asset(group_name, deps) 声明数据资产
  • MaterializeResult:返回元数据(行数、预览等)
  • Resources:ConfigurableResource 管理外部连接
  • Jobs:define_asset_job(selection=AssetSelection.groups(...))
  • Schedules:ScheduleDefinition(job, cron_schedule)
  • Sensors:@sensor(job) 监听外部事件触发
  • Partitions:DailyPartitionsDefinition 按日分区
  • Asset Checks:@asset_check 验证数据新鲜度/质量

Prefect 核心模式

  • Flow/Task:@flow + @task(retries=3, cache_key_fn=task_input_hash)
  • 并发:ConcurrentTaskRunner + task.map(items)
  • Deployments:Deployment.build_from_flow(schedule=CronSchedule(...))
  • Blocks:Secret / JSON 管理配置和密钥

调度策略 Checklist

  • Cron 表达式正确(0 2 * * * 日批 / */15 * * * * 实时)
  • 事件驱动:文件到达 / S3 / API 触发
  • 跨 DAG 依赖:ExternalTaskSensor / Asset deps
  • 幂等性:UPSERT / 分区覆盖写入
  • 增量处理:WHERE updated_at > last_run
  • 数据血缘:Dagster 原生 / Airflow Lineage / dbt ref()

Read the full file on GitHub · 208 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. yesterday First seen · 208 lines · 53 tokens per session scan A 50ee1cac4a62

Subscribe to this mod's changes

data-engineering is a skill published in the GitHub repository fengshao1227/ccg-workflow (5,865 stars, last pushed 2d ago), licensed MIT. It adds 53 tokens to every session and 2,391 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

absolute-simplify

Use when the user wants to simplify, clean up, refactor, tidy, or refine code — their staged/unstaged git changes or a target file/path. Reduces complexity, flattens nesting, removes redundancy and dead code, scores each change by value (holding low-value churn), then runs tests to prove nothing broke. Invoke on…

maddhruv/absolute · 178 tokens

absolute-ui

Build polished, intentional UIs with concrete CSS/Tailwind values — typography, color, layout, spacing, dark mode, accessibility, animations, components. Encodes specific, opinionated rules with exact values, not vague advice. Covers buttons, cards, forms, tables, navigation, dashboards, landing pages, onboarding, and…

maddhruv/absolute · 121 tokens

absolute-work

End-to-end, phase-gated SDLC for AI coding agents: relentless design interview → reviewed spec → dependency-graphed task board → safe-wave TDD execution → verification → converge. Handles features, bugs, refactors, greenfield projects, planning breakdowns, and migrations. Triggers on "absolute work", "build this…

maddhruv/absolute · 104 tokens

absolute-init

One-time setup for absolute: interview how you want it to behave (output style, autonomy, TDD strictness, spec dir, families) + detect the stack once, then write .absolute.config.json (project, committed) and /.absolute/config.json (user defaults + per-project overrides). Every other absolute- command reads it instead…

maddhruv/absolute · 127 tokens

absolute-spec

Lightweight standalone design spec for AI coding agents: codebase scan → bounded clarify pass (3–5 questions, not a grill) → reviewed design doc written to docs/plans/ → independent scored review → stop. No task board, no build. Use when you want a spec to discuss, hand off, or review before committing to…

maddhruv/absolute · 122 tokens

absolute-docs

Diátaxis-driven documentation for AI coding agents: write, improve, or audit tutorials, how-tos, reference, explanation, and developer docs (README, CONTRIBUTING, ADRs). Detects the docs stack; gates on the outline before writing prose; verifies every claim against the code before it ships. Triggers on "absolute…

maddhruv/absolute · 102 tokens