bigtable-basics

What problem does it solve?

This Skill eliminates the steep learning curve and common pitfalls of working with Google Bigtable, a high-scale NoSQL database, by providing expert guidance for provisioning infrastructure, designing performant schemas, writing efficient queries, and troubleshooting performance issues like hotspotting.

Core Features & Use Cases

• Infrastructure & Schema Management: Provision Bigtable instances, clusters, and tables, design high-cardinality row keys and column families, and safely evolve schemas using gcloud or cbt CLIs.
• Querying & Development: Write optimized SQL queries and client library code (Java, Go, Python) for Bigtable, avoiding costly full table scans and performance anti-patterns.
• Performance Troubleshooting: Diagnose and resolve hotspotting and slow query issues using tools like Key Visualizer, gcloud hot-tablets, and cbt read with full stats.
• Use Case Example: A data engineer can use this Skill to provision a production Bigtable instance for a real-time user activity tracking workload, design a row key schema that prevents hotspotting, and write optimized queries to retrieve recent user events without full scans.

Quick Start

Use the bigtable-basics skill to provision a new Bigtable instance, design a performant row key schema for your user activity tracking workload, and write an optimized SQL query to retrieve the last 24 hours of events for a specific user tenant.