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

在创建 BigQuery 表、实施分区或集群、管理表架构或优化表结构时使用。涵盖基于时间的分区、范围分区、集群策略、DDL 命令和表配置。 来源：funnelenvy/agents_webinar_demos。

查看原文