skills.rest
brunoldqueiroz
brunoldqueirozCOMMUNITY
Explore all skills by this author →
GitHub

dbt-expert

Advise on dbt modeling, incremental strategies, testing, and project configuration.

Updated Aug 23, 2026
Search Tags:#data modeling#dbt#sql#data transformation#analytics engineering#jinja
One-click install
npx skills add https://github.com/brunoldqueiroz/marvin --skill dbt-expert-brunoldqueiroz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-expert
Source: https://github.com/brunoldqueiroz/marvin/tree/main/.claude/skills/dbt-expert
Command: npx skills add https://github.com/brunoldqueiroz/marvin --skill dbt-expert-brunoldqueiroz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides expert guidance and best practices for dbt data modeling, ensuring efficient, maintainable, and robust data transformation pipelines.

Core Features & Use Cases

  • dbt Best Practices: Enforces core principles like three-layer architecture, proper source/ref usage, and testing strategies.
  • Incremental Modeling: Guides on optimizing incremental models for performance and correctness.
  • Testing & Documentation: Advises on comprehensive testing and documentation conventions.
  • Use Case: When working on dbt models, Jinja macros, or configuring dbt projects, this Skill offers opinionated advice to align with industry standards and prevent common pitfalls.

Quick Start

Use the dbt expert skill to help me design an incremental model for my daily orders table.

Frequently Asked Questions about dbt-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a dbt incremental model for daily data transformations?▼

To design a dbt incremental model, define a unique key and incremental filter condition to process only new or updated rows. This strategy optimizes data transformation pipelines by reducing compute costs and runtime.

What is the proper dbt project structure for staging, intermediate, and mart layers?▼

The proper dbt project structure enforces a three-layer architecture separating staging, intermediate, and mart models. This convention ensures clean data flow from raw sources to refined business reporting layers.

How do I write Jinja macros in dbt for data transformation?▼

Writing Jinja macros in dbt involves creating reusable SQL logic using control structures and variables. This allows you to dynamically generate SQL queries and reduce code duplication across your data models.

What are common dbt anti-patterns and how do I avoid them?▼

Common dbt anti-patterns include improper source referencing, skipping model tests, and ignoring incremental model correctness. Avoiding these pitfalls ensures robust analytics engineering and maintainable data transformation pipelines.

How do I configure dbt tests and documentation for my data models?▼

Configuring dbt tests and documentation involves defining schema tests in YAML and adding descriptive markdown files. This ensures data quality validation and provides clear lineage context for analytics engineering teams.

Related Skills

Explore More Software Engineering Skills→
AltimateAIAltimateAI

altimate-code

Delegate data engineering tasks to the Altimate-code CLI agent.

Official
Advanced
p-o-ke-naep-o-ke-nae

dbt-transformation-patterns

Design maintainable dbt transformation workflows with staged models, testing, and incremental strategies.

Community
Advanced
nrakownrakow
1

warehouse-udf-strategy

Automate UDF versus dbt macro decisions for SQL transformations.

Community
Advanced
davekim917davekim917
1

analytics-engineering

Standardize dbt project structure, naming, tests, and documentation.

Community
Advanced