bigquery-expert

What problem does it solve?

This Skill helps users write efficient, cost-effective BigQuery SQL queries and design optimized table schemas, preventing performance bottlenecks and unexpected costs.

Core Features & Use Cases

• Query Optimization: Provides patterns for efficient joins, window functions, and partitioning.
• Schema Design: Guides on creating partitioned and clustered tables for performance.
• Cost Control: Offers strategies for estimating and limiting query costs, and managing storage.
• Use Case: When writing a complex SQL query for a large dataset in BigQuery, use this Skill to ensure it's partitioned correctly and uses cost-safe patterns to avoid high bills.

Quick Start

Use the bigquery-expert skill to write a query that partitions the mart.fact_conversions table by conversion_date and clusters by creator_id, platform.