dbt

name	dbt
type	skill
description	dbt (data build tool) implementation of the analyst transformation layer. Use when a project has a dbt/ directory or you need to build, test, or document SQL transformations as version-controlled, reproducible dbt models. This is the dbt-specific HOW for the tech-agnostic principles in the aops-tools analyst skill.
category	instruction
triggers	["dbt","dbt model","dbt project","staging model","dbt mart"]
modifies_files	true
needs_task	false
mode	execution
domain	["academic","development"]
allowed-tools	Read,Grep,Glob,Edit,Write,Bash,Skill
version	0.1.0
permalink	skills-aops-extras-dbt

dbt — Transformation Layer (academicOps)

This skill is the dbt-specific implementation of the transformation layer described in the tech-agnostic analyst skill (aops-tools). The analyst skill owns the principles (all transformation in a versioned/tested/reproducible layer; presentation displays pre-computed data only); this skill owns the dbt how-to.

dbt is one swappable choice of transformation layer. The analyst principles hold regardless of which engine you use; only the commands and file layout below are dbt-specific.

Contents

• [[dbt-workflow]] — single-step collaborative workflow for creating and modifying dbt models in the staging / intermediate / mart layered architecture.
• [[dbt-patterns]] — comprehensive reference: data-access policy, model organisation, testing strategies (schema / singular / package tests), documentation, incremental models, and performance.

When to use

• The project contains a dbt/ directory (dbt/models/, dbt_project.yml).
• You need to add a metric, join, aggregation, or any business logic — it belongs in a dbt model with tests, never in the presentation layer.
• You need to test or document a transformation so reviewers can re-run and audit it.