Skip to main content
Agent skill

Bigquery Basics

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.

Get started

Get the complete skill folder, including its scripts and reference files.

When to use this skill

Use Bigquery Basics when an AI agent needs a reusable SKILL.md workflow for this job: 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.

When not to use it

Skip Bigquery Basics when the task is outside the analysis category, or when a more specific skill in this directory already covers the same workflow with clearer triggers.

How to install

Where will you use it?

Install scope
Claude Code folder setup
mkdir -p ~/.claude/skills/bigquery-basics
# Save SKILL.md to ~/.claude/skills/bigquery-basics/SKILL.md
  1. Claude Code personal install: place the skill and its bundled files at ~/.claude/skills/bigquery-basics/SKILL.md. For a shared project, commit the folder at .claude/skills/bigquery-basics/ instead.
  2. Current Claude Code detects SKILL.md changes in watched directories during the session. If you just created a top-level skills directory, run /reload-skills. Check that the skill is listed before testing its trigger.
  3. For Claude chat or Cowork in the Desktop app, manage uploaded skills in Customize > Skills; copying files into a local Claude Code folder is not a Desktop install. Other agents may use different install locations.

Full install guide for Claude, Cursor, and Codex →

Try a starter prompt

After installing the skill, paste this starter prompt into your agent to verify it triggers on a small task.

Starter prompt
Use the Bigquery Basics skill for this task: Use Bigquery Basics when this documented workflow matches the task. Confirm any required inputs or files before making changes.

What supports this recommendation?

71/100 provisional content score. This measures documentation, practical detail and source signals. It is not a measured task success rate or a security certification.

Documentation
77/100
Practical detail
68/100
Source evidence
63/100
Source signals
72/100
Model compatibility evidence
  • claudeuntested

    No model-specific signal or recorded compatibility test was found.

  • chatgptuntested

    No model-specific signal or recorded compatibility test was found.

  • geminiinferred

    The skill text mentions Gemini or a closely associated term. This is keyword-derived compatibility; no hands-on model test is recorded.

  • copilotuntested

    No model-specific signal or recorded compatibility test was found.

  • llamauntested

    No model-specific signal or recorded compatibility test was found.

  • perplexityuntested

    No model-specific signal or recorded compatibility test was found.

  • mistraluntested

    No model-specific signal or recorded compatibility test was found.

  • grokuntested

    No model-specific signal or recorded compatibility test was found.

Inferred compatibility is based on content signals. Check the app, its available tools and setup requirements before running a skill.

What this skill does

# 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.

## Attribution

**MUST READ**: Before executing any `gcloud`, REST API, or MCP command, you MUST read [Usage Attribution](references/attribution.md). For commands executed directly in the terminal (never in generated scripts, Terraform, or user code), prefix `gcloud` with `CLOUDSDK_METRICS_REQUEST_ATTRIBUTION="agent-skills/1.0 (skill:bigquery-basics)"` and append `agent-skills/1.0 (skill:bigquery-basics)` to `User-Agent` headers.

## Setup and Basic Usage

1. **Enable the BigQuery API:**

```bash CLOUDSDK_METRICS_REQUEST_ATTRIBUTION="agent-skills/1.0 (skill:bigquery-basics)" \ gcloud services enable bigquery.googleapis.com --quiet ```

2. **Create a Dataset:**

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

3. **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 ```

4. **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.

- [Change History](references/change-history.md): Tracking and querying incremental table changes using APPENDS and CHANGES.

- [Continuous Queries](references/continuous-queries.md): Running continuous SQL statements to analyze incoming data in real time.

- [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.

- [Usage Attribution](references/attribution.md): Standardized usage attribution tags for `gcloud` CLI, REST API, and MCP requests.

*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).

Intended uses

  • Use Bigquery Basics when this documented workflow matches the task.

Implementation notes

  • Review the source instructions and adapt inputs before running the workflow.

Try it, then tell us how it went

A copied prompt does not tell us whether the task worked. Report your result after checking the output. We collect your tool and outcome, never your files or prompt.