etl-seed

etl-seed is a skill for Claude Code from sfc-gh-dflippo/snowflake-dbt-demo. It costs 53 tokens per session (2,120 once invoked), scanned A, original, Apache-2.0.

A test-file seeder for a deployed ETL unit. It creates YAML instructions describing how to run the source and converted pipelines and which source and target tables to compare.

In plain words
What is it for?
It builds ETL test YAML from the unit registry, lists written tables and their Snowflake counterparts, and prepares the file for live comparison.
Why use it?
It removes the need to discover table comparisons and pipeline settings by hand, while leaving join columns for a developer to confirm.

Skill for Claude Code

Written for Claude Code: installed under .claude/.

Part of the snowflake-migration plugin — 72 skills, 7 agents shipped together

Good fit It builds ETL test YAML from the unit registry, lists written tables and their Snowflake counterparts, and prepares the file for live comparison.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed
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.

Any agent
npx skills add sfc-gh-dflippo/snowflake-dbt-demo --skill etl-seed
Clone the repo
git clone --depth 1 https://github.com/sfc-gh-dflippo/snowflake-dbt-demo

Made for: Claude Code.

Or install snowflake-migration, the plugin that ships this one along with the rest of its 72 skills, 7 agents.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for etl-seed

README.md
[![agentmods](https://agentmods.dev/badge/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed/github.svg)](https://agentmods.dev/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed)
Your own site
<a href="https://agentmods.dev/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed"><img src="https://agentmods.dev/badge/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for etl-seed

Your own site · 80×15
<a href="https://agentmods.dev/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed"><img src="https://agentmods.dev/badge/skills/sfc-gh-dflippo/snowflake-dbt-demo/etl-seed.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
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,120 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
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.1 $0.00053 $0.02120
Opus 5 $0.00026 $0.01060
Sonnet 5 $0.00011 $0.00424
Haiku 4.5 $0.00005 $0.00212

Measured 2d ago against content hash 8eee8ff49aef, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

etl-seed 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 2d ago.

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.

.claude/skills/snowflake-migration/skills/migration/migrate-objects/migrate-etl/etl-seed/SKILL.md · 127 lines

How it starts

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

ETL Seed

Generates the kind: etl test YAML for a single, already-deployed ETL code unit at artifacts/<id>/etl-test/<name>.yml. The YAML declares the pipeline (how to launch the source package and which converted target to run) and a validation.tables list of source→target table pairs to compare.

scai test seed seeds ETL units — you do not hand-author the file. For an ETL unit (kind = 'etl'; SSIS or Informatica natively, any platform once an external_command: section opts in — see Step 2) scai test seed walks the Code Unit Registry, takes the unit's write dependencies (INSERT / UPDATE / MERGE / DELETE), and emits a validation.tables entry per written table — pairing the source table (source.canonicalName) with its Snowflake target (target.canonicalName). It leaves index_columns blank for you to fill. Your job is to run the seeder, fill in the join keys, handle any skipped units, and confirm with the user — not to invent table pairs.

Step 0: Resolve Unit

Read the registry entry (the executor passes object_id; if entered by name, locate via migration_status(mode="my_objects_summary")):

Field Used as
id {ETL_ID} for the --where filter and the artifacts/<id>/etl-test/ path
source.platform source kind (ssis, informatica, …)
files.source.path source definition file (.dtsx, .xml, …); its stem is the YAML file name

The etlSeed task has a taskCompleted precondition on deploy, so the executor only dispatches this skill once the unit is deployed — you do not need to re-check deployment here.

Step 1: Run scai test seed

scai test seed --where "id = '{ETL_ID}'"

Add --append when a YAML already exists for the unit — it re-emits the table pairs from the current CUR while preserving your edited index_columns / test_cases (matched per source→target pair):

scai test seed --where "id = '{ETL_ID}'" --append

Platform is auto-detected per unit from the registry — no --platform flag. On success the file is written to artifacts/{ETL_ID}/etl-test/<name>.yml with the execution block and table pairs filled from the CUR. When an external_command: section is present, the side it names is emitted as {type: external_command, wait_seconds: <n>} — two keys and nothing else, since the command itself lives only in test_config.yaml — and the other side keeps its native block. Tune wait_seconds per unit if one package runs longer than the shared default.

Read the full file on GitHub · 127 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. 2d ago First seen · 127 lines · 53 tokens per session scan A 8eee8ff49aef

Subscribe to this mod's changes

etl-seed is a skill published in the GitHub repository sfc-gh-dflippo/snowflake-dbt-demo (33 stars, last pushed 3d ago), licensed Apache-2.0. It adds 53 tokens to every session and 2,120 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-09-10.