‹ 首页

bigquery-basics

@google · 收录于 1 周前 · 上游提交 昨天★ 社区精选

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 做数据分析和表管理

/ 下载安装
https://github.com/google/skills/tree/main/skills/cloud/bigquery-basics ↗
/ 通过 npx 安装 校验哈希
npx oh-my-skill add google/skills/bigquery-basics
/ 通过 bash 安装
curl -fsSL https://oh-my-skill.com/install.sh | bash -s -- google/skills/bigquery-basics
/ 已经装过?验证本机副本,不用重装
npx oh-my-skill verify google/skills/bigquery-basics
安装目标可用 --agent / --scope 或 --to 明确指定;省略时只会在唯一已存在的 agent 目录上自动选择,零命中或多命中会停止并提示。content_hash 缺失或不一致均拒装。
–GitHub stars
~486最小装载
~3.3K含声明引用
~3.3K文本包总量
索引托管

怎么用

技能原文 SKILL.md作者撰写 · Apache-2.0 · 927b745

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
  1. Enable the BigQuery API:

``bash gcloud services enable bigquery.googleapis.com --quiet ``

  1. Create a Dataset:

``bash bq mk --dataset --location=US my_dataset ``

  1. Create a Table:

Create a file named schema.json with your table schema:

``json [ { "name": "name", "type": "STRING", "mode": "REQUIRED" }, { "name": "post_abbr", "type": "STRING", "mode": "NULLABLE" } ] ``

Then create the table with the bq tool:

``bash bq mk --table my_dataset.mytable schema.json ``

  1. Run a Query:

``bash 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](references/core-concepts.md): Storage types, analytics workflows, and BigQuery Studio features.
  • [CLI Usage](references/cli-usage.md): Essential bq command-line tool operations for managing data and jobs.
  • [Client Libraries](references/client-library-usage.md): Using Google Cloud client libraries for Python, Java, Node.js, and Go.
  • [MCP Usage](references/mcp-usage.md): Using the BigQuery remote MCP server and Gemini CLI extension.
  • [Infrastructure as Code](references/iac-usage.md): Terraform examples for datasets, tables, and reservations.
  • [IAM & Security](references/iam-security.md): 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](../bigquery-ai-ml): SKILL.md file for BigQuery AI and ML capabilities (forecast, anomaly detection, text generation).
按 Apache-2.0 许可原样转载,未经改动 · 在 GitHub 查看 →

评论

登录即可评论;带「已验证安装」的,是发布者名下有本店的安装或持有记录。
…