dbt Transformation Patterns

dbt-transformation-patterns

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

boisenoise/skills-collections·0installs10starsProductivity & Planning

SKILL.md

Full skill instructions

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.

Limitations

Use this skill only when the task clearly matches the scope described above.
Do not treat the output as a substitute for environment-specific validation, testing, or expert review.
Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/boisenoise/skills-collections --skill antigravity-dbt-transformation-patterns

View on GitHub

skills/antigravity-dbt-transformation-patterns/SKILL.md

More Productivity & Planning skills

View all

Productivity & Planning

brainstorming

Structured design dialogue that validates ideas before implementation begins.

295.4K 385.7K

View

Productivity & Planning

ui-ux-pro-max

Comprehensive design intelligence for web and mobile UI/UX across 10 technology stacks.

133.1K 383.9K

View

Productivity & Planning

writing-plans

Comprehensive implementation plans for multi-step tasks, breaking down specs into bite-sized, testable steps.

295.4K 268K

View

Productivity & Planning

using-superpowers

Introduction to the obra skills system with mandatory skill invocation rules and best practices.

295.4K 259.8K

View

Productivity & Planning

executing-plans

Execute a written implementation plan with critical review and task checkpoints.

295.4K 229.1K

View

Productivity & Planning

dispatching-parallel-agents

Delegate independent tasks to specialized agents working concurrently with isolated context.

295.4K 206.3K

View

Productivity & Planning

using-git-worktrees

Isolated git worktrees with smart directory selection and safety verification.

295.4K 205.2K

View

Productivity & Planning

Toolkit for interacting with and testing local web applications using Playwright. Supports verifying frontend functionality, debugging UI behavior, capturing browser screenshots, and viewing browser logs.

179.7K 170.6K

View