end-to-end-snowflake-pipeline SKILL.md skillA

end-to-end-snowflake-pipeline from altimateai/data-engineering-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add altimateai/data-engineering-skills/end-to-end-snowflake-pipeline@git:20261027.d6a2faa

Pins git:20261027.d6a2faa in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
altimateai/data-engineering-skills
Path
skills/snowflake/end-to-end-snowflake-pipeline/SKILL.md
Versions recorded
1
Latest version
git:20261027.d6a2faa, committed Oct 27, 2026
Size
23,908 bytes
Repository stars
135
License
MIT

Build an end-to-end Snowflake pipeline — ticket → dbt models + orchestration DAG → PR → self-review → ticket comment. Use when: (1) User says "build a pipeline for X **end-to-end**", "create an end-to-end flow", "set up the <X> pipeline per JIRA-123" (2) Scope spans dbt models AND orchestration AND a PR — not just one of them (3) Target warehouse is Snowflake and the dbt project already exists (4) An orchestrator (Airflow / Prefect / Dagster) is already in the repo, OR the user is OK operating…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# end-to-end-snowflake-pipeline

**Requirements → environment detect → build → orchestrate → validate → self-review → PR → ticket → summary.**

## When NOT to use this skill

- Change is a single-model enhancement → `dbt-model-enhancement`.
- No orchestration or PR involved → `creating-dbt-models` or similar.
- Just need to tune an existing slow query → `snowflake-query-optimization`.
- Migrating from MS SQL → `mssql-to-snowflake-dbt-migration`.

## Prerequisites

```bash
command -v dbt           # required
command -v git           # required
command -v gh            # required if PR creation is in scope
command -v python3       # required for DAG parse validation
command -v altimate-code # optional — nicer lineage + validation
```

Must have:
- A dbt project configured for Snowflake with a working `profiles.yml`
  or env-var profile.
- **A non-prod dbt target** (`dev`, `ci`, or any target whose profile
  does NOT write into the production schema). Phase 6 refuses to run
  without one — branch code must never build into prod.
- `git` + `gh` authenticated against the project's remote
  (`gh auth status`) for the PR phase.
…

Read the whole file at its exact version.

How to install

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_zwthoyfrylq25pzw/9983f1b1964daa01ce2dcefe0089dfd781a5196ba8fb199185cf58a6c854501f.json

Then /plugin install end-to-end-snowflake-pipeline@markdownregistry-zwthoyfrylq25pzw in Claude Code. It installs git:20261027.d6a2faa, the one graded A here, pinned to the commit it was graded at, and leaves it there.

The exact contents, by fingerprint
mdr add altimateai/data-engineering-skills/end-to-end-snowflake-pipeline@sha256:9983f1b1964daa01

The line at the top of this page pins the label git:20261027.d6a2faa, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_zwthoyfrylq25pzw.svg)](https://markdownregistry.com/a/art_zwthoyfrylq25pzw)

2 badge image fetches in 30 days. What the badge shows.

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in altimateai/data-engineering-skills/end-to-end-snowflake-pipeline since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of end-to-end-snowflake-pipeline from somewhere else? Ask it: where did my end-to-end-snowflake-pipeline come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 1 version of this file, committed on Oct 27, 2026.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
git:20261027.d6a2faa latest2026-10-27 d6a2faa 23,908 BA view
Keep it current by itself, install once

Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

Install on GitHub

It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.

Keep it current by itself

Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml

It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.

Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (23908 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

altimateai/data-engineering-skills · 135 stars · license MIT · pushed 2026-10-27 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_zwthoyfrylq25pzw
GET https://markdownregistry.com/api/v1/resolve?ref=altimateai/data-engineering-skills/end-to-end-snowflake-pipeline
GET https://markdownregistry.com/api/v1/blob/9983f1b1964daa01ce2dcefe0089dfd781a5196ba8fb199185cf58a6c854501f

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from altimateai/data-engineering-skills

data-engineering-skills Plugin marketplace
altimateai/data-engineering-skills · .claude-plugin/marketplace.json · Skills for data engineering workflows (4 plugins: dbt-skills, snowflake-skills, databricks-skills and more)
v1.0.0 · audit A · 135 stars
altimate-code SKILL.md skill
altimateai/data-engineering-skills · skills/altimate-code/SKILL.md · Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools. USE THIS…
git:20260615.a13847e · audit A · 135 stars
optimizing-databricks-sql SKILL.md skill
altimateai/data-engineering-skills · skills/databricks/optimizing-databricks-sql/SKILL.md · Analyze DBSQL queries, including SQL embedded in notebooks (`spark.sql(...)`, `%sql` cells), for anti-patterns, lint…
git:20260925.705c68b · audit A · 135 stars
creating-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/creating-dbt-models/SKILL.md · Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any…
git:20260121.476f750 · audit A · 135 stars
dbt-model-enhancement SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/dbt-model-enhancement/SKILL.md · Scoped enhancement of ONE existing dbt model from a ticket, with a validated PR as the deliverable. Use when: (1) User…
git:20261027.d6a2faa · audit A · 135 stars
debugging-dbt-errors SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/debugging-dbt-errors/SKILL.md · Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error"…
git:20260121.476f750 · audit A · 135 stars
developing-incremental-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/developing-incremental-models/SKILL.md · Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating…
git:20260206.c45120a · audit A · 135 stars
documenting-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/documenting-dbt-models/SKILL.md · Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model…
git:20260121.476f750 · audit A · 135 stars
migrating-sql-to-dbt SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/migrating-sql-to-dbt/SKILL.md · Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views…
git:20260121.476f750 · audit A · 135 stars
mssql-to-snowflake-dbt-migration SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/mssql-to-snowflake-dbt-migration/SKILL.md · Convert MS SQL Server source code (stored procs, views, T-SQL scripts) into dbt models targeting Snowflake, with…
git:20261027.d6a2faa · audit A · 135 stars
refactoring-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/refactoring-dbt-models/SKILL.md · Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions…
git:20260121.476f750 · audit A · 135 stars
testing-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/testing-dbt-models/SKILL.md · Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or…
git:20260121.476f750 · audit A · 135 stars

Every file in altimateai/data-engineering-skills

Browse by kind, by grade A, or by owner.