Snowflake Query Optimizer & Performance Tuner
Optimize Snowflake queries and slash compute costs
What You Can Do
You analyze Snowflake query execution plans to identify performance bottlenecks and recommend optimizations that reduce compute costs. This skill provides data-backed strategies for rewriting inefficient queries, right-sizing warehouse configurations, and restructuring data layouts—giving you measurable improvements in query latency and reduced credit consumption.
Features
Parse Snowflake EXPLAIN output to identify scan types, join orders, and spilling issues
Pinpoint expensive table scans, inefficient joins, or missing clustering keys
Suggest optimal clustering strategies based on query patterns and data distribution
Identify aggregations and common subqueries suitable for persistent views
Detect queries that could benefit from partition elimination strategies
Provide specific SQL rewrites to eliminate full-table scans or redundant operations
Calculate projected credit savings and ROI for each optimization
Recommend compute tier and auto-scaling policies based on workload characteristics
Example Output
Query Analysis Result:
Identified Issue: Full table scan on ORDERS (2.3B rows)
- Current execution: 847 seconds, 142 credits
- Root cause: Missing equality predicate on REGION_ID
Optimization:
```sql
ALTER TABLE ORDERS CLUSTER BY (REGION_ID, ORDER_DATE);
CREATE MATERIALIZED VIEW MV_DAILY_SALES AS
SELECT DATE_TRUNC('day', ORDER_DATE) as day, REGION_ID, SUM(amount) as total
FROM ORDERS GROUP BY 1,2;
Expected improvement: 84% latency reduction (847s → 135s), 71% cost savings (142 → 41 credits per run)
What's Included
- SKILL.md: Complete diagnostic and optimization workflows with decision trees
- Query Analysis Template: Structured checklist for evaluating execution plans
- Optimization Playbook: Common patterns (clustering, materialized views, warehouse sizing)
- Cost Calculator Worksheet: Estimate credit savings from proposed changes
- Snowflake Configuration Reference: Best practices for compute pools, result caching, and staged joins
Who It's For
- Data Engineers — Optimize ETL pipelines and reduce infrastructure costs
- Database Administrators — Tune warehouse configurations and monitor resource usage
- Analytics Engineers — Improve dbt model performance and query latency
- Data Analysts — Speed up ad-hoc queries and dashboard refresh cycles
- Cloud Architects — Right-size Snowflake deployments for cost efficiency
Best For
- Query performance tuning — Debug slow-running queries and rewrite for speed
- Cost optimization — Identify high-credit queries and eliminate waste
- Pipeline diagnostics — Analyze Airflow/dbt execution bottlenecks
- Warehouse capacity planning — Match compute tier to workload demands
- Data architecture decisions — Evaluate clustering, partitioning, and caching strategies
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
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
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 develop comprehensive go-to-market strategies by analyzing your target market, creating detailed buyer personas, and mapping buying journeys. You then build multi-channel campaign blueprints with positioning frameworks, messaging matrices, and sales enablement assets tailored to your specific buyers and launch goals. This skill transforms product launches from guesswork into data-informed strategies with clear timelines, channel recommendations, and success metrics.
by lurenyang418
Build complete B2C campaign launch plans from positioning through execution. You'll segment audiences based on behavior and value, architect cohesive messaging for each segment, design optimal channel mixes, and establish measurable success metrics tied to business outcomes. Get a ready-to-execute campaign blueprint that coordinates positioning, creative, channels, and performance tracking.
by lurenyang418
You can analyze your Power BI DAX formulas to identify performance bottlenecks and refactor them for faster execution and lower memory consumption. Claude identifies inefficient patterns, recommends optimized alternatives, and provides step-by-step guidance to improve model scalability and responsiveness in production environments.
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