dbt Development

Design, test, and optimize dbt data models with medallion architecture.

34|13|Updated Feb 1, 2022

Search Tags:#data quality #ETL #data modeling #macros #Snowflake #dbt #Jinja

Ready to run

npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-development

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dbt Development
Source: https://github.com/sfc-gh-dflippo/snowflake-dbt-demo/tree/main/.claude/skills/dbt-development
Command: npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-development

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dbt-core, dbt-snowflake, dbt-labs/dbt_utils, Snowflake-Labs/dbt_constraints, and includes references (resource) components.

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