Skills
.Work. You
Rest

gcp-bq-table-management

Official

BigQuery table design: partitioning & clustering.

Data & Analytics#sql#cloud#partitioning#bigquery#clustering#ddl#schema-management
AuthorFunnelEnvy
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill helps data teams quickly design and optimize BigQuery tables by applying partitioning, clustering, and precise schemas, reducing query costs and improving performance.

Core Features & Use Cases

  • Create and modify BigQuery tables with explicit schemas and column types.
  • Implement time-based or range partitioning and configure clustering to speed up common queries.
  • Use SQL DDL and bq CLI patterns to manage table lifecycles in analytics workloads.
  • Use Case: A marketing analytics warehouse needs a partitioned events table and a clustered user_events table to accelerate cohort analysis.

Quick Start

Run the following to create a simple partitioned table:

bq mk -t
--schema 'timestamp:TIMESTAMP,customer_id:STRING,amount:FLOAT'
--time_partitioning_type DAY
project:dataset.orders

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: gcp-bq-table-management
Download link: https://github.com/FunnelEnvy/agents_webinar_demos/archive/main.zip#gcp-bq-table-management

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.