nicsuzor/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.