dbt-transformation-patterns

Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.

1.20x

Quality

62%

Does it follow best practices?

Impact

95%

1.20x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./tests/ext_conformance/artifacts/agents-wshobson/data-engineering/skills/dbt-transformation-patterns/SKILL.md

Evaluation results

99%

16%

SaaS Analytics Staging Layer Setup

Staging layer structure and source definitions

Criteria

Without context

With context

stg_ naming convention

100%

Staging directory structure

100%

Source YAML file naming

100%

Model YAML file naming

50%

100%

Source freshness config

40%

100%

Source column tests

100%

CTE pattern

100%

source() macro used

100%

Column renaming — id to entity_id

100%

Column renaming — _loaded_at

100%

Lowercase string fields

100%

83%

Cents-to-dollars conversion

100%

Model YAML documentation

100%

90%

E-Commerce Order Processing Pipeline

Incremental model strategies and intermediate layer

Criteria

Without context

With context

int_ prefix naming

100%

fct_ prefix naming

100%

Directory structure

100%

ref() macro used

100%

Incremental materialization

100%

unique_key specified

100%

Merge strategy for updates

100%

merge_update_columns

100%

is_incremental() filter

100%

Filter uses max(updated_at)

100%

Intermediate uses CTE structure

100%

on_schema_change config

40%

97%

12%

Customer Analytics Data Mart

Project configuration, macros, and mart dimension models

Criteria

Without context

With context

Layer materializations

66%

Schema assignments

100%

vars for start date

100%

generate_schema_name macro

100%

limit_data_in_dev macro

100%

DRY utility macro

100%

dim_ prefix naming

100%

Surrogate key

100%

_loaded_at metadata

42%

100%

ref() macro used

100%

dbt_utils tests

100%

packages.yml

100%

Model YAML documentation

100%

Repository: Dicklesworthstone/pi_agent_rust
Commit: 47823e3

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

SaaS Analytics Staging Layer Setup E-Commerce Order Processing Pipeline Customer Analytics Data Mart

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.