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
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'll analyze competitor positioning, market strategies, and business models to generate actionable competitive intelligence reports. This skill synthesizes public data, customer research, and market trends into structured competitive analysis that informs product strategy, pricing, and go-to-market decisions. Get clear competitive advantages, threat assessments, and market opportunity summaries without hours of manual research.
by lurenyang418
Transform raw research data from surveys, interviews, focus groups, and social listening into validated consumer insights grounded in evidence. You'll automatically identify customer segments, map their pain points, detect emerging trends, and generate strategic recommendations that connect research to business decisions. This skill helps you move from scattered findings to a unified market intelligence strategy that stakeholders can act on.
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
This skill analyzes consumer data, behavior patterns, and feedback to extract actionable insights. You can synthesize raw data into coherent market trends, identify consumer segments, and generate strategic recommendations. Perfect for understanding your audience at scale and uncovering hidden opportunities in consumer preferences and market dynamics.
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
Claude helps you design statistically sound market research studies from hypothesis formation through analysis. You'll calculate sample sizes, statistical power, and interpret confidence intervals and hypothesis tests with professional rigor. Transform raw survey and experiment data into actionable business insights backed by solid statistics.
by lurenyang418
Develop comprehensive go-to-market strategies that align sales, marketing, and product teams. This skill helps you analyze your target market, design multi-channel campaigns, define success metrics, and create detailed launch roadmaps. You'll get strategic frameworks, competitive analysis, and actionable campaign plans tailored to your B2B business.
by lurenyang418