Skills
.Work. You
Rest

dbt-snowflake-optimization-pattern

Community

Cross-tool optimization for dbt and Snowflake.

Data & Analytics#testing#optimization#dbt#incremental#clustering#snowflake#query-performance
Authordylpickledev
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Addresses slow-running dbt models that bottleneck downstream dashboards and reports by coordinating dbt-mcp and snowflake-mcp to diagnose performance bottlenecks, implement robust optimizations, and validate results without impacting data correctness.

Core Features & Use Cases

  • Cross-tool orchestration for dbt-Snowflake optimization
  • Convert slow views to incremental tables and add clustering to improve pruning
  • End-to-end validation of performance with profiling and tests in Snowflake and dbt

Quick Start

Run the pattern on a slow dbt model to transform it into an incremental, clustered model and validate performance with Snowflake.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 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-snowflake-optimization-pattern
Download link: https://github.com/dylpickledev/claude-analytics-framework/archive/main.zip#dbt-snowflake-optimization-pattern

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 223,000+ vetted skills library on demand.