Skip to content
Kitbay
Skill

dbt-transformation-patterns

MITUpdated on Nov 10, 202649,466GitHub stars

A short skill in the agentic-awesome-skills collection with patterns for projects built on dbt, the data build tool that turns warehouse data into models with SQL.

What the skill teaches

A short skill in the agentic-awesome-skills collection with patterns for projects built on dbt, the data build tool that turns warehouse data into models with SQL. It applies to building dbt pipelines, arranging models into staging, intermediate and mart layers with naming rules and owners, adding data tests, documentation and freshness checks, choosing materialisations and incremental strategies for large tables, and speeding up runs with selectors and CI. It should not be used without dbt or a warehouse, for one-off SQL or without access to source schemas, and tells the agent to ask when inputs or permissions are missing. The detailed patterns and examples sit in a playbook file.

Capabilities

  • Arrange dbt models into staging, intermediate and mart layers
  • Add data tests and freshness checks
  • Choose incremental strategies for large tables