Can I use the output directly in Snowflake?

Yes, the skill is designed to return pure, executable Snowflake SQL without any markdown formatting or unnecessary explanations.

What kind of Snowflake optimizations does it perform?

It focuses on high-impact areas like fixing functions in WHERE clauses, converting implicit joins, optimizing NOT IN subqueries, and deduplicating repeated subqueries.

When should I avoid using this skill for optimization?

You should avoid it if the query logic requires specific non-standard behavior or if the transformation cannot be guaranteed as semantically identical, such as when comparing nullable columns in a NOT IN clause.

Will this skill change the results of my query?

No. The skill follows strict semantic preservation rules to ensure the optimized query returns the exact same columns, rows, and ordering as your original SQL.

Snowflake SQL Optimizer

Name: Snowflake SQL Optimizer
Author: AltimateAI

byAltimateAI

•

Database Management

Optimizes Snowflake SQL queries for peak performance by identifying anti-patterns and rewriting logic while preserving exact results.

The Snowflake SQL Optimizer skill is designed for data engineers and analysts who need to tune slow-running Snowflake queries without risking data integrity. It automatically identifies and fixes common performance bottlenecks, such as functions on filter columns that prevent partition pruning, inefficient implicit joins, and problematic subquery logic. By applying industry-standard Snowflake best practices, it refactors SQL into a more efficient form while ensuring that columns, row counts, and sort orders remain identical to the original input.

Key Features

01Converts legacy implicit comma joins to modern, optimized explicit JOIN syntax

02Extracts repeated subqueries into Common Table Expressions (CTEs) for better execution plans

03Eliminates redundant functions on JOIN columns to prevent slow nested loop joins

0455 GitHub stars

05Identifies and transforms inefficient NOT IN subqueries into performant NOT EXISTS logic

06Refactors date and time functions on filter columns to enable partition pruning

Use Cases

01Refactoring complex queries during a database migration or optimization sprint

02Speeding up slow-running dashboard queries or scheduled data transformation jobs

03Auditing legacy SQL scripts for modern Snowflake performance anti-patterns

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add altimateai/data-engineering-skills snowflake

For use in Claude.ai and ChatGPT

Download Skill