Optimus BigQuery Anti-pattern Detector

Rank top-spend queries, classify each with Gemini, emit cost-saving fixes

Optimus BigQuery Anti-pattern Detector Rank top-spend queries, classify each with Gemini, emit cost-saving fixes 01 / Source 02 / Parse 03 / Classify 04 / Recommend 05 / Report INFO_SCHEMA · BigQuery query history · 01 / Source · cost + bytes INFO_SCHEMA BigQuery query history cost + bytes Optimus Parser · top-spend queries · 02 / Parse Optimus Parser top-spend queries Anti-pattern Catalog · known issues · 03 / Classify Anti-pattern Catalog known issues Gemini · classify each query · 03 / Classify · LLM Gemini classify each query LLM Recommendations · cost-saving fixes · 04 / Recommend Recommendations cost-saving fixes Report · ranked savings · 05 / Report Report ranked savings query history top queries pattern rules classifications ranked fixes Legend primary data policy / PII async batch data store

Find the Money

  • • Optimus parses INFORMATION_SCHEMA for real cost and bytes
  • • Queries are ranked by spend so effort targets the top tail
  • • Only the expensive queries reach the model

Classify and Recommend

  • • Gemini classifies each query against an anti-pattern catalog
  • • Matches map to concrete cost-saving rewrites
  • • Recommendations are reported ranked by projected savings

Data-flow diagram • Built with Archify • Create yours ↗ • Hover to trace • R route • Click to focus • +/− zoom • M radar • T theme • E export