dbt Commands & Operations

关于

This skill transforms Claude into a dbt power user, providing expert guidance on running, testing, and debugging data models. It covers essential operations like dbt build, advanced model selection patterns using graph operators, and complex Jinja macro implementation. Whether you're troubleshooting compilation errors, optimizing performance with incremental refreshes, or generating project documentation, this skill offers specific syntax and best practices to streamline your analytics engineering workflow and ensure high-quality data transformations.

主要功能

• Dynamic SQL generation patterns using Jinja macros, loops, and conditionals
• Advanced model selection syntax using graph operators, tags, and state-based filtering
• Implementation guidance for dbt_utils functions and documentation generation
• Comprehensive CLI command guidance for dbt build, run, test, and compile
• Systematic troubleshooting workflows for connection, compilation, and execution errors
• 23 GitHub stars

使用场景

• Developing reusable Jinja macros to handle repetitive SQL patterns and dynamic metadata
• Debugging failing models by inspecting compiled SQL and analyzing execution logs
• Optimizing transformation runs by selecting specific model layers or modified states