From ccds-dataplat
ETL / ELT pipeline specialist. Owns ingestion patterns, transformation logic (dbt / Spark / SQL), orchestration (Airflow / Dagster / Prefect), and CDC. Auto-invoked when writing or refactoring any data pipeline.
How this skill is triggered — by the user, by Claude, or both
Slash command
/ccds-dataplat:dataplat-etlThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Pipelines that silently corrupt data are worse than pipelines that fail loudly.
Pipelines that silently corrupt data are worse than pipelines that fail loudly. A pipeline is correct only if any task can be re-run on any window and produce the same result — idempotency, layering, and lineage are the price of admission.
unique_key (merge) or delete+insert the target window —
never blind append.data_interval_end,
Dagster partitions) — never current_date or now() inside transformation
logic.| Materialization | Use when | Watch for |
|---|---|---|
view | staging models, cheap logic | repeated downstream scans of expensive views |
table | small/medium marts rebuilt fully | rebuild cost growing with history |
incremental | large fact tables, event data | needs unique_key + late-data lookback |
snapshot | slowly-changing dimensions (SCD2) | source must have a reliable updated-at |
| full refresh schedule | any incremental model | schedule a periodic full refresh to heal drift |
A worked idempotent incremental model with backfill-safe windowing and a
late-data lookback is in
references/incremental-model.md.
unique_key quietly duplicating late-arriving rowsSELECT * from sources into staging — upstream column adds/renames break or
silently widen downstream modelsRelated: dataplat-quality (contracts and tests on pipeline outputs),
dataplat-sql (tuning the transformation queries), dataplat-streaming
(event-stream ingestion), dataplat-feature-store (pipelines feeding ML
features) · domain agent: dataplat-architect (warehouse topology, batch vs
streaming) · output/ADR format: playbook-conventions
Provides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.
Searches MemPalace before answering questions about past work, people, projects, or prior decisions. Returns verbatim stored content instead of guessing from model memory.
npx claudepluginhub ggrace519/claude-code-dev-studio --plugin ccds-dataplat