Bq Optimize

Optimize BigQuery SQL by fixing all detected anti-patterns. Pass a file path or paste SQL directly.

BigQuery SQL Optimize

Rewrite the provided BigQuery SQL with all detected anti-patterns fixed, using the bigquery-optimization skill.

Instructions

  1. Determine the SQL to optimize:

    • If a file path argument is provided, read that file.
    • If no argument is provided, look for the most recent BigQuery SQL in the current conversation.
    • If no SQL is found, ask the user to provide a query or file path.

  2. Detect all anti-patterns by running the full 11-pattern check.

  3. Apply all fixes to produce an optimized version of the query:

    • Preserve the original query semantics exactly -- the optimized query must return the same data.
    • Apply fixes in this order: SimpleSelectStar, SemiJoinWithoutAgg, DynamicPredicate, OrderByWithoutLimit, StringComparison, CTEsEvalMultipleTimes, LatestRecordWithAnalyticFun, JoinOrder, WhereOrder, MissingDropStatement, ConvertTableToTemp.

  4. Output the result:

## Optimized Query

(fully rewritten SQL)

## Changes Applied

1. **PatternName**: What was changed and why.
2. **PatternName**: What was changed and why.

## Summary
X anti-pattern(s) fixed. The optimized query preserves the original semantics.
  1. If no anti-patterns are found, return the original query and confirm it already follows best practices.