Dbt Expert

What it does

The Dbt Expert skill provides in-depth knowledge and guidance on using dbt (data build tool) for data transformation. It enables AI agents to assist with designing maintainable, tested, and documented data pipelines, covering areas like data modeling, testing, documentation, incremental models, macros, Jinja templating, and analytics engineering best practices. The skill understands dbt_project.yml configurations and profiles.yml settings for connecting to databases.

When to use it

• You need help designing the structure of a dbt project, including defining model paths, tests, seeds, and macros.
• You're troubleshooting issues with your dbt configuration files (dbt_project.yml, profiles.yml).
• You want assistance in understanding how to define staging, intermediate, and mart models within your dbt project.
• You need help writing Jinja templates or creating macros for data transformation logic.

Key capabilities

• Deep knowledge of dbt concepts including: data modeling, testing, documentation, incremental models, macros, and Jinja templating.
• Understanding of dbt_project.yml configuration options (e.g., model paths, materializations, tags).
• Knowledge of profiles.yml configurations for database connections (e.g., host, user, password, schema).
• Ability to design maintainable and tested data transformation pipelines.

Example prompts

• "How should I structure my dbt project with staging, intermediate, and mart models?"
• "Can you explain the purpose of the dbt_project.yml file and its key sections?"
• "I'm getting an error in my Jinja template; can you help me debug it?"

Tips & gotchas

• The skill assumes familiarity with basic data warehousing concepts.
• To get the most accurate responses, provide relevant snippets from your dbt_project.yml and profiles.yml files when asking questions.
• This skill focuses on dbt usage and does not cover broader database administration or data engineering topics beyond transformation pipelines.