Skills
.Work. You
Rest

dbt Development

Community

Build robust dbt models with expert guidance.

Data & Analytics#data quality#ETL#data modeling#macros#Snowflake#dbt#Jinja
Authorsfc-gh-dflippo
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Designing, testing, and optimizing dbt data models can be complex, leading to inconsistent data quality, poor performance, and difficult-to-maintain projects. This skill provides expert guidance to build production-grade dbt projects following industry best practices.

Core Features & Use Cases

  • Medallion Architecture: Implement structured Bronze, Silver, and Gold layers for data transformation.
  • Testing Strategies: Apply dbt_constraints, generic, and singular tests for robust data quality.
  • Performance Optimization: Choose optimal materializations and leverage Snowflake-specific features like clustering.
  • Use Case: Design a new data mart for customer analytics, ensuring models are performant, well-tested, and follow a clear lineage from raw data to business-ready insights.

Quick Start

Install dbt packages

dbt deps

Build and test a specific model

dbt build --select model_name

Generate project documentation

dbt docs generate

Dependency Matrix

Required Modules

dbt-coredbt-snowflakedbt-labs/dbt_utilsSnowflake-Labs/dbt_constraints

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: dbt Development
Download link: https://github.com/sfc-gh-dflippo/snowflake-dbt-demo/archive/main.zip#dbt-development

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.