gcp-bq-table-management

SKILL.md

Use this skill when creating, modifying, or optimizing BigQuery table structures with partitioning and clustering.

❌ Too many partitions Problem: Creating 100,000+ partitions Limit: 10,000 partitions per table Solution: Use larger partition granularity (MONTH vs DAY)

❌ Wrong partition column Problem: Partitioning on column not used in queries Solution: Partition on columns used in WHERE clauses

Use when creating BigQuery tables, implementing partitioning or clustering, managing table schemas, or optimizing table structure. Covers time-based partitioning, range partitioning, clustering strategies, DDL commands, and table configuration. Source: funnelenvy/agents_webinar_demos.

View raw