bigquery-basics
GitHub提供 BigQuery 基础操作指南，涵盖数据集与表管理、SQL 查询执行及数据导入。包含 CLI 使用、客户端库集成、基础设施即代码及 IAM 安全配置等参考文档，支持实时连续查询分析。
Trigger Scenarios
Install
npx skills add google/skills --skill bigquery-basics -g -y
SKILL.md
Frontmatter
{
"name": "bigquery-basics",
"metadata": {
"category": "BigDataAndAnalytics"
},
"description": "Manages datasets, tables, and jobs in BigQuery. Use when you need to interact with BigQuery, run SQL queries, manage BigQuery resources (datasets, tables, views), or perform basic data ingestion and analysis."
}
BigQuery Basics
BigQuery is a serverless, AI-ready data platform that enables high-speed analysis of large datasets using SQL and Python. Its disaggregated architecture separates compute and storage, allowing them to scale independently while providing built-in machine learning, geospatial analysis, and business intelligence capabilities.
Setup and Basic Usage
-
Enable the BigQuery API:
gcloud services enable bigquery.googleapis.com --quiet -
Create a Dataset:
bq mk --dataset --location=US my_dataset -
Create a Table:
Create a file named
schema.jsonwith your table schema:[ { "name": "name", "type": "STRING", "mode": "REQUIRED" }, { "name": "post_abbr", "type": "STRING", "mode": "NULLABLE" } ]Then create the table with the
bqtool:bq mk --table my_dataset.mytable schema.json -
Run a Query:
bq query --use_legacy_sql=false \ 'SELECT name FROM `bigquery-public-data.usa_names.usa_1910_2013` \ WHERE state = "TX" LIMIT 10'
Reference Directory
-
Core Concepts: Storage types, analytics workflows, and BigQuery Studio features.
-
Change History: Tracking and querying incremental table changes using APPENDS and CHANGES.
-
Continuous Queries: Running continuous SQL statements to analyze incoming data in real time.
-
CLI Usage: Essential
bqcommand-line tool operations for managing data and jobs. -
Client Libraries: Using Google Cloud client libraries for Python, Java, Node.js, and Go.
-
MCP Usage: Using the BigQuery remote MCP server and Gemini CLI extension.
-
Infrastructure as Code: Terraform examples for datasets, tables, and reservations.
-
IAM & Security: Roles, permissions, and data governance best practices.
If you need product information not found in these references, use the
Developer Knowledge MCP server search_documents tool.
Related Skills
- BigQuery AI & ML Skill: SKILL.md file for BigQuery AI and ML capabilities (forecast, anomaly detection, text generation).
Version History
-
41f503f
Current 2026-08-03 09:41
新增 BigQuery 连续查询（Continuous Queries）的参考文档，说明其用途、APPENDS 语法及限制，并更新相关引用文件。
-
05679aa
2026-07-31 07:57
新增BigQuery变更历史参考文档，介绍如何使用TVF函数追踪和查询表的增量变更（APPENDS和CHANGES），并更新主文件引用。
- aabe37a 2026-07-05 15:28
