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。

查看原文