Optimizing Query By Id · AltimateAI/data-engineering-skills
Optimize a Snowflake query from its query ID
Fetches a Snowflake query's execution profile from its query ID, identifies bottlenecks like poor partition pruning or spillage, and returns an optimized version of the SQL with the expected performance improvement.
Good for
- Diagnose a slow Snowflake query from its ID
- Check partition pruning and spillage for a query
- Get an optimized rewrite with expected improvement
- Source repository
- AltimateAI/data-engineering-skills
- Category
- General
Open-source skills are maintained by their authors and listed as published, with attribution. Results depend on how well the skill fits your task and material.
A good place to start
Here's a Snowflake query_id: analyze its query profile and give me an optimized version with expected performance gains.
Make your next great thing.
Bring a question, a file, or an idea that’s not quite there yet.