Snowflake Query Performance Analysis & Optimization
Analyze and optimize Snowflake queries for peak warehouse performance
What You Can Do
You can analyze Snowflake query execution plans to identify performance bottlenecks and recommend targeted optimizations. This skill provides data-driven recommendations for warehouse configuration, data clustering, and SQL rewrites that reduce both execution time and credit costs.
Features
breaks down query stages, identifies full table scans and shuffle operations
recommends compute tier based on query complexity and concurrent workload
suggests clustering keys and micro-partition strategies to reduce scan cost
identifies inefficient predicates, joins, and subqueries with optimized alternatives
estimates credit savings (per query, daily, monthly) from each optimization
identifies candidates for views to replace expensive subqueries
detects resource contention and queueing delays
documents baseline metrics, optimization gains, and validation checksums
Example Output
Execution Plan Analysis:
- Current: Full table scan on 1.2B rows (45s, 120 credits)
- Root cause: No predicate pushdown on date column
- Optimization: Add clustering key on (customer_id, created_date)
- Result: Partition pruning to 48M rows (8s, 18 credits) — 82% speedup, 85% cost reduction
Warehouse Configuration Report:
- Current: X-Large (8 cr/hr) with 10 concurrent queries
- Issue: Queue wait time avg 12s, total throughput 2 queries/min
- Recommendation: Medium (2 cr/hr) with query queueing → 98% cost reduction, acceptable SLA
SQL Rewrite:
-- BEFORE: Full outer join causing redistribute
SELECT * FROM orders o FULL OUTER JOIN users u ON o.user_id = u.id WHERE o.created_date > CURRENT_DATE - 30
-- AFTER: Inner join with filtered subquery (80% faster)
SELECT o.*, u.name FROM orders o INNER JOIN users u ON o.user_id = u.id WHERE o.created_date > CURRENT_DATE - 30
What's Included
- SKILL.md: Complete Snowflake optimization framework with decision trees and analysis workflows
- Query audit checklist: Systematic execution plan review process and issue prioritization
- Warehouse sizing worksheet: Credit calculator and tier recommendation matrix
- Clustering strategy guide: Key selection patterns and partition micro-optimization
- SQL optimization patterns: 15+ common rewrites (correlated subqueries, window functions, etc.)
- Cost estimation template: Monthly credit projection and savings validation checklist
- Performance testing workbook: Benchmark capture, validation, and regression detection procedures
Who It's For
- Data engineers — Optimize ETL pipelines, warehouse loads, and merge operations
- Database administrators — Manage compute costs and enforce performance standards
- Analytics engineers — Improve dashboard query performance and reduce refresh times
- Data analysts — Debug slow exploratory queries and optimize report generation
- Cloud architects — Design cost-efficient Snowflake infrastructure and governance policies
Best For
- Analyzing slow queries using execution plans and identifying root causes
- Right-sizing Snowflake warehouse compute for workload, SLA, and budget constraints
- Optimizing table clustering and partition strategies to reduce data scans
- Generating SQL rewrites that eliminate sorts, shuffles, and redistributes
- Quantifying credit cost savings from each optimization recommendation
You might also like
Create compelling positioning statements, analyze competitive landscapes, and generate strategic brand recommendations backed by structured frameworks. You'll synthesize market data to identify differentiation opportunities, develop go-to-market strategies, and articulate your unique value proposition with confidence and clarity.
by lurenyang418
You generate production-ready LookML code, debug model validation errors, and optimize explore performance. This skill accelerates your development cycle by handling syntax generation, relationship definition, and complex calculations—letting you focus on business logic rather than language mechanics.
by lurenyang418
This skill transforms raw competitive data—customer reviews, pricing structures, feature lists, and market reports—into structured, actionable intelligence reports. It creates competitive positioning matrices that reveal market gaps, pricing strategies, and feature differentiation at a glance. Get the strategic insights you need to inform product roadmaps, refine positioning, and make confident go-to-market decisions.
by lurenyang418
Transform raw qualitative data—interviews, surveys, focus groups, open-ended feedback—into structured themes and actionable insights. Claude systematically codes your data using established frameworks (Braun & Clarke, grounded theory, phenomenology), identifies patterns across respondents, and synthesizes findings into clear, evidence-based recommendations. You'll go from hundreds of transcript pages to organized themes with illustrative quotes in minutes.
by lurenyang418
Analyze your current brand perception, competitive position, and market gaps to develop a comprehensive repositioning strategy. You'll receive a differentiated positioning statement, messaging architecture, competitive analysis, and a tactical 90-day implementation roadmap that your team can execute immediately.
by lurenyang418
You can create comprehensive, data-driven go-to-market strategies that align your enterprise product with market realities, competitive landscapes, and internal capabilities. This skill guides you through market analysis, positioning, timeline creation, pricing strategy, and launch readiness assessments—delivering actionable roadmaps that reduce launch risk and accelerate time-to-market for complex B2B initiatives.
by lurenyang418
You can extract, structure, and synthesize consumer insights from multiple research sources including interviews, surveys, and social listening data. This skill transforms raw qualitative and quantitative data into clear, actionable findings and detailed consumer personas that inform product, marketing, and business strategy decisions.
by lurenyang418
You upload interview transcripts, survey responses, or focus group data, and this skill systematically extracts themes, patterns, and relationships using proven thematic coding frameworks. It moves beyond raw data to deliver actionable strategic insights, complete with prioritization and visualization recommendations. The result is a structured, evidence-based foundation for decision-making.
by lurenyang418