byaltimateai· 45 skills
Optimizes Snowflake query performance using query ID from history. Use when optimizing Snowflake queries for: (1) User provides a Snowflake query_id (UUID format) to analyze or optimize (2) Task mentions "slow query", "optimize", "query history", or "query profile" with a query ID (3) Analyzing query performance metrics - bytes scanned, spillage, partition pruning (4) User references a previously run query that needs optimization Fetches query profile, identifies bottlenecks, returns optimized SQL with expected improvements.
$npx -y skills add altimateai/data-engineering-skills --skill optimizing-query-by-idInstalls into the current project.
Run `npx skills use "https://github.com/altimateai/data-engineering-skills" --skill "altimateai/data-engineering-skills/optimizing-query-by-id"` and follow the generated skill instructions now. Read its complete output, redirecting it to a temporary file first if necessary. Resolve relative paths from the supporting-files directory it provides.
Use the skills in "https://github.com/altimateai/data-engineering-skills" that are relevant to the current task. Run `npx skills add "https://github.com/altimateai/data-engineering-skills"` and select the relevant skills, then follow their instructions.