BigQuery Optimization Expert

Optimize BigQuery deployments for maximum performance and minimum cost through partitioning, clustering, query tuning, and systematic cost control strategies.

Gold

v1.0.00 activationsData & AnalyticsTechnologyadvanced

SupaScore

83.9

Research Quality (15%)

8.3

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.6

Completeness (10%)

8.3

User Satisfaction (20%)

8.2

Decision Usefulness (15%)

8.4

Best for

▸Reducing BigQuery scan costs by implementing time-based partitioning and clustering strategies
▸Optimizing slow analytical queries that process multi-terabyte datasets
▸Converting on-demand BigQuery workloads to flat-rate pricing with slot optimization
▸Designing materialized views for frequently-executed dashboard aggregations
▸Implementing partition pruning and column selection to minimize bytes processed

What you'll get

●Detailed partitioning strategy with specific DATE columns and partition expiration settings, plus clustering recommendations ordered by filter frequency
●Query rewrite examples showing before/after SQL with estimated cost savings and performance improvements
●Slot allocation recommendations with peak usage analysis and flat-rate vs on-demand cost comparison

Not designed for ↓

×General SQL query writing or basic database design principles
×Other Google Cloud services optimization beyond BigQuery
×Data modeling for transactional systems or OLTP workloads
×BigQuery administration like user management or project setup

Expects

Current BigQuery usage patterns, slow query examples, cost breakdowns, and table schemas that need optimization.

Returns

Specific optimization recommendations with partitioning strategies, query rewrites, cost projections, and implementation priorities.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

bigquerygoogle-cloudquery-optimizationcost-optimizationpartitioningclusteringdata-warehousesql-performancematerialized-viewsslot-managementbi-enginedata-analytics

Research Foundation: 8 sources (4 official docs, 2 books, 1 industry frameworks, 1 web)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.

Version History

v1.0.02/16/2026

Initial release

Prerequisites

Use these skills first for best results.

SQL Query OptimizerPlatinum

Works well with

Cloud Cost OptimizerGold Data Warehouse ArchitectGold dbt Analytics EngineerGold Real-Time Analytics ArchitectGold SQL Performance Tuning ExpertPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

GCP Solutions SpecialistGold Streaming Analytics SpecialistGold Data Lakehouse DesignerGold

Common Workflows

BigQuery Cost Optimization Pipeline

Optimize BigQuery performance and costs, implement efficient transformation layers, then design dashboards that leverage optimized queries

bigquery-optimization-expert→dbt Analytics Engineer→dashboard-design-strategist

Activate this skill in Claude Code

Start Free to Activate This Skill