Skills dbt-transformation-patterns
📦

dbt-transformation-patterns

Content revision r2 Safe ⚙️ External commands

Build Reliable dbt Transformation Projects

dbt projects can become inconsistent as models, tests, and incremental logic grow. This skill provides practical patterns for organized, documented, and efficient transformations.

Supports: Claude Codex Code(CC)
🥉 78 Bronze

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "dbt-transformation-patterns" from https://skillstore.io/skills/sickn33-dbt-transformation-patterns.md and its manifest at https://skillstore.io/api/skills/sickn33-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.

Markdown detail GET /skills/sickn33-dbt-transformation-patterns.md Signed manifest GET /api/skills/sickn33-dbt-transformation-patterns/manifest Signed lockfile GET /api/skills/sickn33-dbt-transformation-patterns/lockfile

Test it

Using "dbt-transformation-patterns". Plan model layers for Stripe payments and Shopify orders.

Expected outcome:

  • Sources: Define Stripe customers and payments, plus Shopify orders, with freshness checks.
  • Staging: Standardize identifiers, amounts, statuses, and timestamps in source-specific models.
  • Intermediate: Aggregate successful payments and order activity by customer.
  • Marts: Publish a customer dimension and an order fact table with tested keys.

Using "dbt-transformation-patterns". Recommend tests for a customer dimension.

Expected outcome:

  • Test the surrogate key and natural customer identifier for uniqueness and null values.
  • Require email when the business process guarantees it.
  • Restrict customer tier to approved values.
  • Validate nonnegative lifetime value and relationships from dependent fact models.

Using "dbt-transformation-patterns". Select an incremental strategy for late-arriving order updates.

Expected outcome:

Use a merge strategy with a stable order key and an updated timestamp watermark. Include a lookback window and schedule periodic full-refresh validation.

Security Audit

Safe
v5 • 7/23/2026 Open versioned report

All 14 static findings are false positives. Twelve matches are ordinary SQL or YAML identifiers, while two matches are Markdown path formatting, not shell execution. No prompt injection, exfiltration intent, or unsafe command behavior was found.

2
Files scanned
591
Lines analyzed
0
Review items
0
False positives ignored

Risk Factors

⚙️ External commands (2)
SKILL.md:33 SKILL.md:37
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
Audited by: codex View Audit History →
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.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-dbt-transformation-patterns/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-dbt-transformation-patterns/security.svg)](https://skillstore.io/skills/sickn33-dbt-transformation-patterns?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-dbt-transformation-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-dbt-transformation-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-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

sickn33. (2026). dbt-transformation-patterns security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-dbt-transformation-patterns/audits/5

BibTeX citation

@techreport{sickn33-sickn33-dbt-transformation-patterns-2026, author = {sickn33}, title = {dbt-transformation-patterns security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/sickn33-dbt-transformation-patterns/audits/5}, 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 5)" version: "unspecified" type: report authors: - name: "sickn33" date-released: "2026-07-23" url: "https://skillstore.io/skills/sickn33-dbt-transformation-patterns/audits/5" identifiers: - type: other value: "skillstore:sickn33-dbt-transformation-patterns:audit:5" description: "Skillstore immutable audit report identifier"

Compare variants

2 installable variants

Each author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.

Why this variant is first

Highest Skillstore Score
sickn33 Recommended Current

sickn33-dbt-transformation-patterns

Skillstore Score 78
Evidence Confidence High
Skillstore usage 11
Updated

2026-08-21

wshobson

wshobson-dbt-transformation-patterns

Skillstore Score 77
Evidence Confidence High
Skillstore usage 12
Updated

2026-08-21

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
69
Community
83
Spec Compliance

What You Can Build

Structure a New Analytics Project

Create clear model layers, naming rules, source definitions, and materialization defaults for a new dbt repository.

Improve Data Quality Coverage

Add model documentation, source freshness checks, key constraints, relationship tests, and accepted-value tests.

Scale Large Warehouse Models

Select incremental strategies, define reliable keys, handle late data, and limit development scans.

Try These Prompts

Plan a dbt Project 
Design a dbt project structure for [business domain] using sources, staging, intermediate, and marts layers. Explain naming and materialization choices.
Add Tests and Documentation 
Review these dbt model and source definitions: [details]. Propose descriptions, freshness rules, and suitable uniqueness, null, relationship, and accepted-value tests.
Choose an Incremental Strategy 
Recommend an incremental design for [model] on [warehouse]. Consider volume, unique keys, late records, updates, partitions, schema changes, and full refreshes.
Review a Production dbt Architecture 
Audit this dbt project structure and model flow: [details]. Identify layering, duplication, testing, freshness, documentation, performance, and deployment risks. Prioritize improvements.

Best Practices

  • Adapt every example to the warehouse adapter and validate compiled SQL before deployment.
  • Define model grain, ownership, keys, tests, and documentation together.
  • Test incremental models against full-refresh results and late-arriving records.

Avoid

  • Do not copy sample schemas or business rules without checking source semantics.
  • Do not use incremental materialization without a stable key and recovery plan.
  • Do not bypass staging by embedding repeated source cleanup in marts.

Frequently Asked Questions

Which dbt layers does this skill cover?
It covers source definitions, staging models, intermediate logic, dimensions, facts, tests, documentation, and macros.
Can it choose a materialization strategy?
Yes. It can compare views, tables, ephemeral models, and incremental strategies using your workload details.
Does it run dbt commands?
No. It provides command guidance, but you must run and validate commands in your environment.
Does it support every data warehouse?
The patterns are general, but SQL functions and incremental features differ by adapter.
Does it require dbt-utils?
Some examples use dbt-utils tests and surrogate keys. Replace them or install the package as appropriate.
Can it review an existing dbt project?
Yes. Provide project structure, model definitions, warehouse adapter, data grain, and current problems for a focused review.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Repository

https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/dbt-transformation-patterns

Ref

f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526

Maintenance freshness

7/26/2026

Usage

9 downloads · 100 views

File structure

📁 resources/

📄 implementation-playbook.md

📄 SKILL.md