npx claudepluginhub googlecloudplatform/cloud-bigtable-ecosystem --plugin bigtableThis skill uses the workspace's default tool permissions.
This skill provides core workflows and guidance for administering and developing with Google Bigtable.
Guides BigQuery engineering with bq CLI for queries, table ops, data load/export; GoogleSQL syntax, functions, window funcs; partitioning, clustering, optimization.
Creates BigQuery tables using gcloud CLI commands. Provides step-by-step guidance, best practices, and production-ready configurations for GCP BigQuery tasks.
Provides expert guidance for creating, modifying, troubleshooting, and optimizing dbt pipelines targeting BigQuery, including SQL optimization and project setup.
Share bugs, ideas, or general feedback.
This skill provides core workflows and guidance for administering and developing with Google Bigtable.
gcloud for Control Plane operations: Manage Instances, Clusters, App Profiles, Backups and IAM. Create Tables, Logical Views, Materialized Views and Authorized Views.cbt for Data Plane operations: Update Tables, Column Families, and reading/writing data.include-stats=full option under cbt read to diagnose slow queries.[!IMPORTANT] Safety Rule: Always obtain explicit user confirmation before making non-emulator database changes.
Use SQL for complex transforms or aggregations and key-value APIs for simpler query patterns.
Note: Use exact match, prefix (_key LIKE 'myprefix%') or range predicates on _key to avoid expensive unbounded scans.
If expensive scans (either unbounded or prefix or range queries scanning a large range) are unavoidable due to multiple access patterns that can’t all be accommodated in a single schema, consider one of these two options:
Use key-value APIs for insert, update, increment and delete operations. SQL API is read-only.
SQL API doesn't support DDL operations. Table creation, deletion, updates should be made using gcloud CLI. Logical Views and Continuous Materialized Views are defined as SQL queries but they must be created using gcloud CLI.
cbt CLI.cbt changes, verify column family GC policies:
cbt createfamily [TABLE] [FAMILY]
cbt setgcpolicy [TABLE] [FAMILY] "maxversions=5 AND maxage=30d"