Bigquery Schema Design

Use when designing BigQuery table schemas, choosing partitioning or clustering strategies, deciding between nested/repeated fields vs flat schemas, selecting table types (native, external, views, materialized views), choosing data types, or planning denormalization. Triggers on: "partition", "cluster", "STRUCT", "ARRAY", "nested fields", "table design", "schema", "materialized view", "external table", "denormalize", "data type", "TIMESTAMP vs DATETIME".

Ocean1346 Updated

File contents

Ocean1346/bigquery-expert commit ef568ccd1a

Frequently asked questions

npx get-skill add ocean1346/bigquery-schema-design