BigQuery CLI Skill

This skill provides comprehensive guidance on using the BigQuery CLI (bq) for querying and inspecting data in Monzo's BigQuery projects.

Core Principles

1. Always specify the project explicitly using --project_id=PROJECT_NAME
2. Always use Standard SQL with --use_legacy_sql=false
3. Respect data sensitivity - avoid querying actual content from sensitive tables
4. Use INFORMATION_SCHEMA for metadata queries (schemas, columns, tables)

Common Query Patterns

1. Check Table Schema (INFORMATION_SCHEMA)

Use this to inspect column names, types, and structure without accessing sensitive data: