bigquery
/bigquery
Query and manage data in Google BigQuery. Covers dataset and table management, IAM, cost-safe querying (dry-run first), partitioning, clustering, and bq CLI patterns. Always estimates cost before executing queries — BigQuery bills by bytes processed. Use when the user mentions: bigquery query, analytics on GCP, BigQuery IAM, BigQuery cost, bigquery partition, bigquery schema, sql on GCP.
- Author
- jpantsjoha ↗
- Repository
- googlecloud-plugin ↗
- Licence
- MIT
- Last repository change
- 07.08.2026
Assessment and security
- Files in this package
- 2
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 4
No signals detected. Repository changed on 07.08.2026, without references to retired models or APIs.
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Query and manage data in Google BigQuery. Covers dataset and table management, IAM, cost-safe querying (dry-run first), partitioning, clustering, and bq CLI patterns. Always estimates cost before executing queries — BigQuery bills by bytes processed. Use when the user mentions: bigquery query, analytics on GCP, BigQuery IAM, BigQuery cost, bigquery partition, bigquery schema, sql on GCP.
Original author description
Query and manage data in Google BigQuery. Covers dataset and table management, IAM, cost-safe querying (dry-run first), partitioning, clustering, and bq CLI patterns. Always estimates cost before executing queries — BigQuery bills by bytes processed. Use when the user mentions: bigquery query, analytics on GCP, BigQuery IAM, BigQuery cost, bigquery partition, bigquery schema, sql on GCP.
How it works
- Safety Rule — Dry-Run First
- Core Patterns
- Cost Controls
- References
SKILL.md preview
--- name: bigquery description: "Query and manage data in Google BigQuery. Covers dataset and table management, IAM, cost-safe querying (dry-run first), partitioning, clustering, and bq CLI patterns. Always estimates cost before executing queries — BigQuery bills by bytes processed. Use when the user mentions: bigquery query, analytics on GCP, BigQuery IAM, BigQuery cost, bigquery partition, bigquery schema, sql on GCP." license: MIT metadata: "googlecloud-plugin/version": "0.1" "googlecloud-plugin/triggers": "BigQuery, bigquery query, bq, dataset, analytics on GCP, BigQuery IAM, BigQuery cost, bigquery partition, bigquery schema, sql on GCP" "googlecloud-plugin/required-scopes": "bigquery.datasets.create, bigquery.datasets.get, bigquery.jobs.create, bigquery.jobs.get, bigquery.tables.create, bigquery.tables.getData, bigquery.tables.get" "googlecloud-plugin/mcp-servers": "google-bigquery" --- # BigQuery Serverless, highly scalable data warehouse. Bills per bytes processed — always dry-run before executing queries on large datasets. ## Safety Rule — Dry-Run First ```bash # Estimate bytes before executing — always do this on unknown datasets bq query --dry_run --use_legacy_sql=false 'SELECT * FROM dataset.table' # Output: "Query successfully validated. Assuming the tables are not modified, # running this query will process X bytes." ``` ## Core Patterns ### Create a dataset ```bash bq mk --dataset \ --location=REGION \ --description="Description" \ PROJECT_ID:DATASET_NAME ``` ### Run a query (with cost confirmation) ```bash # 1. Dry-run first (see above) # 2. Execute only after confirming cost bq query --use_legacy_sql=false --location=REGION \ 'SELECT field FROM `project.dataset.table` LIMIT 100' ``` ### Grant dataset access (least-privilege) ```bash bq show --format=prettyjson PROJECT_ID:DATASET > /tmp/ds.json # Edit roles in /tmp/ds.json, then: bq update --source /tmp/ds.json PROJECT_ID:DATASET ``` ### Create partitioned table (cost control) ```sql CREATE TABLE dataset.table ( event_date DATE, user_id STRING ) PARTITION BY event_date OPTIONS (partition_expiration_days = 365); ``` ## Cost Controls - Partition tables by date — queries on a partition scan only that partition - Cluster tables by high-cardinality filter columns - Set per-project quotas: IAM → Quotas → BigQuery — Query usage per day - Use `LIMIT` in development; avoid `SELECT *` on multi-TB tables ## References - [BigQuery Introduction](https://cloud.google.com/bigquery/docs/introduction) - [BigQuery Access Control](https://cloud.google.com/bigquery/docs/access-control) - [BigQuery Pricing](https://cloud.google.com/bigquery/pricing) - [Performance Best Practices](https://cloud.google.com/bigquery/docs/best-practices-performance-overview)
Files in this package (2)
- SKILL.md 3 KB
- references/README.md 1 KB
Versions
| Repository | Score | Licence |
|---|---|---|
| This page · jpantsjoha/googlecloud-plugin | 100 | MIT |
| costory-io/costory-finops-mcp-skills | 100 | Apache-2.0 |
| builderio/agent-native | 100 | MIT |
| builderio/agent-native | 100 | MIT |
| wraith-proxy/wraith-skills | 100 | MIT |
| costory-io/costory-finops-mcp-skills | 100 | Apache-2.0 |
| henkisdabro/wookstar-claude-plugins | 100 | MIT |
| G1Joshi/Agent-Skills | 100 | MIT |
Database snapshot: 13.11.2026 · package version 77a4dfd2195b (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100bigquery-table-creator
Create bigquery table creator operations. Auto-activating skill for GCP Skills. Triggers on: bigquery table creator, bigquery table creator Part of the GCP Skills skill category. Use when working with bigquery table creator functionality. Trigger with phrases like "bigquery… - 100optimizing-bigquery-queries
Reduce Google BigQuery cost and runtime — partitioning and clustering, minimizing bytes processed, avoiding SELECT * and full scans, slot usage and reservations, approximate functions, and materialized views. Use when BigQuery queries are expensive or slow, bytes billed are… - 100bigquery-scheduled-query
Manage bigquery scheduled query operations. Auto-activating skill for GCP Skills. Triggers on: bigquery scheduled query, bigquery scheduled query Part of the GCP Skills skill category. Use when working with bigquery scheduled query functionality. Trigger with phrases like… - 95cloud-native-gcp-bigquery
Use this skill when the user says 'bigquery', 'bigquery cost', 'bigquery partitioning', 'bigquery clustering', 'dremel', 'capacitor', 'bigquery slots', 'bigquery editions', 'bigquery slow query', 'bytes scanned'. Explains BigQuery's architecture (Dremel execution, Capacitor… - 90bigquery-sql
Provides BigQuery SQL query optimization techniques, execution best practices, and performance tuning rules for high-efficiency querying. Use when optimizing BigQuery SQL queries, reducing query costs, or designing performant SQL transformations. - 100bigquery-api
Run SQL against Google BigQuery and browse its catalog — submit queries (sync or async), poll job status, page through results, list datasets/tables, and read table schemas. Use this whenever the user wants to query a BigQuery table, ask "what's in this dataset", check a…