finding-expensive-queries
CommunityRank costly Snowflake queries and fix them.
Data & Analytics#query optimization#cost analysis#snowflake#query history#spillage#bytes scanned#warehouse credits
Authormiptah21
Version1.0.0
Installs0
System Documentation
What problem does it solve?
It identifies which Snowflake queries are driving the most cost, latency, and resource waste so you can prioritize optimization work instead of guessing.
Core Features & Use Cases
- Cost-based query ranking using SNOWFLAKE.ACCOUNT_USAGE.QUERY_ATTRIBUTION_HISTORY to surface the most expensive queries in a time window.
- Performance and scan/spill enrichment using SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY to quantify elapsed time, bytes scanned, and spillage.
- Actionable optimization guidance by detecting patterns like poor partition pruning, repeated query hashes (potential caching), and high spillage severity.
Quick Start
Ask an AI assistant to find the top expensive Snowflake queries from the last 7 days for a given warehouse and return a ranked list with severity classification and optimization recommendations.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: finding-expensive-queries Download link: https://github.com/miptah21/skills/archive/main.zip#finding-expensive-queries Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.