📦
content-creator
88Create Brand-Consistent Marketing Content
Marketing teams need content that stays consistent across channels. This skill helps plan, write, analyze, and optimize content for brand voice and SEO.
Writing & Content View
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)
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.
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
Safev5 • 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)
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.
Copy report link
https://skillstore.io/skills/sickn33-dbt-transformation-patterns/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](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/5BibTeX 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 variantsEach author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
Highest Skillstore Score
Author / source Skillstore Score Evidence Confidence Skillstore usage Updated
sickn33-dbt-transformation-patterns
Skillstore Score 78
Evidence Confidence High
Skillstore usage 13
Updated
2026-09-09
wshobson-dbt-transformation-patterns
Skillstore Score 77
Evidence Confidence High
Skillstore usage 13
Updated
2026-09-09
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
sickn33License
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-patternsRef
f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526
Maintenance freshness
7/26/2026
Usage
9 downloads · 100 views
File structure
More from sickn33
View all📦
prompt-engineering-patterns
85Improve LLM Prompts With Proven Patterns
Inconsistent prompts waste time and make AI outputs hard to trust. This skill guides prompt design with reusable patterns, examples, evaluation steps, and optimization workflows.
Productivity View
📦
senior-architect
81Review Architecture Workflows and Project Paths
Architecture reviews need a consistent starting point and clear project boundaries. This skill provides workspace-scoped tool templates, command examples, and generic design references.
Coding & Development View
📦
senior-fullstack
81Review Fullstack Project Foundations
Fullstack project setup can require many tools and checks. This skill provides basic local wrappers, common commands, and general engineering guidance.
Coding & Development View
📦
prompt-engineer
81Optimize AI Prompts With Prompt Engineer
Writing clear prompts is hard when goals are vague or complex. This skill turns rough requests into structured prompts using proven prompt frameworks.
Productivity View
📦
product-manager-toolkit
80Prioritize Product Work With Research Insights
Product teams need faster ways to rank features, synthesize interviews, and document decisions. This skill provides RICE scoring, interview analysis, and PRD templates for structured planning.
Productivity View
Related Skills
View all📦
data-quality-frameworks
77Build Data Quality Checks
by wshobson
Unreliable tables can break analytics, reporting, and downstream products. This skill helps define Great Expectations suites, dbt tests, data contracts, and automated validation pipelines.
Data & Analytics View
📦
data-processing
84Process JSON, YAML, and TOML Data
by 0xDarkMatter
Structured configuration data can be hard to inspect across JSON, YAML, and TOML files. This skill guides jq and yq queries for extraction, filtering, conversion, and updates.
Data & Analytics View
📦
senior-data-engineer
81Design Reliable Data Engineering Systems
by davila7
Data teams need clear decisions for reliable pipelines, models, and operations. This skill provides architecture guidance, production checklists, and starter CLI scaffolds.
Data & Analytics View
📦
data-orchestrator
79Coordinate Data Pipelines and Quality Checks
by Brownbull
Data pipeline work can become inconsistent when ingestion, features, quality, and reporting are planned separately. This skill organizes data tasks around pipeline context, quality gates, lineage, and handoffs.
Data & Analytics View
📦
data-cleaning-pipeline
79Clean Data for Reliable Analysis
by zhangchenlai-dev
Messy datasets slow analysis and create unreliable results. This skill guides Claude, Codex, and Claude Code through practical cleaning steps.
Data & Analytics View
📦
dedupe
79Inspect Collections for Safe Deduplication
by srinitude
Duplicate cleanup can remove unique information when identity rules are unclear. This skill creates evidence-rich reports and gates every mutation behind explicit review.
Data & Analytics View