BigQuery Deep Skill

Manage and analyze Google BigQuery using bq and gcloud commands.

Discovery-First Rule

ALWAYS discover before acting. Never assume dataset names, table names, job IDs, or reservation names.

# List datasets
bq ls --format=json | jq '[.[] | {datasetId: .datasetReference.datasetId, location: .location}]'

# List tables in a dataset
bq ls --format=json "$DATASET" | jq '[.[] | {tableId: .tableReference.tableId, type: .type, numRows: .numRows, numBytes: .numBytes}]'

Parallel Execution Requirement

ALL independent operations MUST run in parallel using background jobs (&) and wait.