dbt-expert

What problem does it solve?

This Skill streamlines the process of building, testing, and optimizing data transformation pipelines using dbt, ensuring data quality and performance.

Core Features & Use Cases

• Model Development: Guides through creating staging, intermediate, and mart models with best practices.
• Testing & Documentation: Provides patterns for robust testing strategies and comprehensive documentation.
• Incremental Loads: Implements efficient incremental model patterns for large datasets.
• Performance Tuning: Offers optimization techniques for dbt projects.
• Use Case: You need to build a new mart table for daily creator performance metrics. This Skill will guide you through creating the necessary staging and intermediate models, implementing incremental logic, defining tests, and documenting the final mart table.

Quick Start

Use the dbt-expert skill to create a new staging model for raw YouTube video data.