Optimizing Query Text · AltimateAI/data-engineering-skills

Optimize a Snowflake SQL query's text

Reviews pasted Snowflake SQL for performance anti-patterns — functions on filter or join columns, unnecessary casts, and similar issues — and returns a rewritten query guaranteed to produce identical results, useful when a query needs to run faster.

Good for

  • Rewrite a WHERE clause for better partition pruning
  • Fix a JOIN condition that blocks hash joins
  • Get a faster query with identical results
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 my slow Snowflake SQL query — optimize it for performance while keeping the exact same results.

Make your next great thing.

Bring a question, a file, or an idea that’s not quite there yet.