dbt-transformation-patterns
Build Reliable dbt Transformations
dbt projects can become inconsistent as models, tests, and documentation grow. This skill gives Claude, Codex, and Claude Code clear patterns for model layers, naming, tests, docs, and incremental builds.
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "dbt-transformation-patterns" from https://skillstore.io/skills/wshobson-dbt-transformation-patterns.md and its manifest at https://skillstore.io/api/skills/wshobson-dbt-transformation-patterns/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "dbt-transformation-patterns". Organize a new dbt project for Stripe payments and Shopify orders.
Expected outcome:
A layered plan with sources, staging, intermediate, and marts folders, plus naming rules for each model group.
Using "dbt-transformation-patterns". Improve tests for customer and order marts.
Expected outcome:
A test coverage checklist covering unique keys, not-null checks, relationships, accepted values, recency, and value bounds.
Using "dbt-transformation-patterns". Choose an incremental strategy for a large events table.
Expected outcome:
A recommendation comparing merge, delete-and-insert, and partition overwrite based on late data, table size, and warehouse support.
Security Audit
SafeI reviewed SKILL.md and found no evidence of malicious intent, prompt injection, data exfiltration, or executable payloads. All static findings are false positives caused by Markdown fences, inline code, dbt SQL/YAML examples, standard dbt CLI examples, and documentation URLs. No semantic security findings were identified.
Risk Factors
⚙️ External commands (29)
🌐 Network access (4)
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/wshobson-dbt-transformation-patterns/audits/8?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/wshobson-dbt-transformation-patterns?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/wshobson-dbt-transformation-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/wshobson-dbt-transformation-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/wshobson-dbt-transformation-patterns.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
wshobson. (2026). dbt-transformation-patterns security audit report (audit version 8) [Author version unspecified]. Skillstore. https://skillstore.io/skills/wshobson-dbt-transformation-patterns/audits/8BibTeX citation
@techreport{wshobson-wshobson-dbt-transformation-patterns-2026,
author = {wshobson},
title = {dbt-transformation-patterns security audit report (audit version 8)},
institution = {Skillstore},
year = {2026},
number = {8},
url = {https://skillstore.io/skills/wshobson-dbt-transformation-patterns/audits/8},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "dbt-transformation-patterns security audit report (audit version 8)"
version: "unspecified"
type: report
authors:
- name: "wshobson"
date-released: "2026-07-07"
url: "https://skillstore.io/skills/wshobson-dbt-transformation-patterns/audits/8"
identifiers:
- type: other
value: "skillstore:wshobson-dbt-transformation-patterns:audit:8"
description: "Skillstore immutable audit report identifier"
Compare variants
2 installable variantsEach author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
sickn33-dbt-transformation-patterns
2026-08-21
wshobson-dbt-transformation-patterns
2026-08-21
Skillstore Score
Why this score Evidence Confidence: HighWhat You Can Build
Structure a New dbt Project
Create a clear folder layout, model layer plan, and naming approach before transformation work starts.
Improve Analytics Models
Refactor staging, intermediate, dimension, and fact models using consistent transformation patterns.
Standardize Quality Practices
Define documentation, freshness checks, relationship tests, and accepted values across shared dbt models.
Try These Prompts
Help me design a dbt project structure for these sources and analytics goals. Include model layers, folders, naming rules, and first tests.
Turn these raw source tables into dbt staging model guidance. Include source definitions, renamed fields, freshness checks, and column tests.
Design dbt dimension and fact models for this business process. Include upstream dependencies, metrics, grain, tests, and documentation notes.
Review this dbt incremental model plan. Recommend the best incremental strategy, unique keys, late-arriving data handling, and validation tests.
Best Practices
- Start with source definitions, freshness checks, and staging models before building marts.
- Document model grain, important columns, and business logic near the models.
- Pair each critical transformation with unique, not-null, relationship, or accepted-value tests.
Avoid
- Do not build marts directly from raw source tables without a staging layer.
- Do not hardcode project dates, schemas, or business logic that should be variables or macros.
- Do not choose incremental materialization before defining unique keys and late-data behavior.