sickn33 avatar

Dbt Transformation Patterns

If you're working with dbt and want to move past the getting-started phase into production-ready patterns, this gives you structured guidance on the layering conventions (staging, intermediate, marts), testing strategies, and incremental model handling that separate hobby projects from maintainable pipelines. It covers the organizational decisions that tend to cause friction on teams: naming conventions, materialization choices, CI workflows, and when to actually document things. The implementation playbook is where the detailed patterns live. Honestly, this is most useful when you're setting up a new dbt project or inheriting one that needs structure, not when you're just writing a quick transformation.

skills.sh installs
195
GitHub stars
39.4K
last updated
Jun 3, 2026

Install

$ npx -y skills add sickn33/antigravity-awesome-skills --skill dbt-transformation-patterns --agent claude-code

Installs into .claude/skills of the current project.

Files

dbt Transformation Patterns

Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.

Use this skill when

  • Building data transformation pipelines with dbt
  • Organizing models into staging, intermediate, and marts layers
  • Implementing data quality tests and documentation
  • Creating incremental models for large datasets
  • Setting up dbt project structure and conventions

Do not use this skill when

  • The project is not using dbt or a warehouse-backed workflow
  • You only need ad-hoc SQL queries
  • There is no access to source data or schemas

Instructions

  • Define model layers, naming, and ownership.
  • Implement tests, documentation, and freshness checks.
  • Choose materializations and incremental strategies.
  • Optimize runs with selectors and CI workflows.
  • If detailed patterns are required, open resources/implementation-playbook.md.

Resources

  • resources/implementation-playbook.md for detailed dbt patterns and examples.

Sponsors

Details

Repository
github.com/sickn33/antigravity-awesome-skills
First seen
Jun 3, 2026

More from sickn33/antigravity-awesome-skills

All 708

Recommended

1juliusbrussee avatarcavemanjuliusbrussee/cavemanUltra-compressed communication mode. Cuts output tokens 65% (measured) by speaking like caveman while keeping full technical accuracy. Supports intensity levels618.3Kskills.sh installs
2mattpocock avatargrill-memattpocock/skillsA relentless interview to sharpen a plan or design.1.5Mskills.sh installs
3shadcn avatarimproveshadcn/improveSurvey any codebase as a senior advisor and produce prioritized, self-contained implementation plans for OTHER models/agents to execute. Strictly read-only on s40Kskills.sh installs
4obra avatarsystematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixes326.7Kskills.sh installs
5forrestchang avatarkarpathy-guidelinesforrestchang/andrej-karpathy-skillsBehavioral guidelines to reduce common LLM coding mistakes through explicit assumptions, simplicity, and verifiable success criteria.17.9Kskills.sh installs
6vercel-labs avatarfind-skillsvercel-labs/skillsHelps users discover and install agent skills when they ask questions like "how do I do X", "find a skill for X", "is there a skill that can...", or express int4.3Mskills.sh installs