bigquery-basics
Manages BigQuery datasets, tables, views and jobs, runs SQL queries and handles basic ingestion and analysis.
- Kind
- Skill
- Works with
- Any agent
- Languages
- SQL
- Source
- Google skills (Google Cloud and more) @ 92776fbf3875
- Path
- skills/cloud/bigquery-basics/SKILL.md
- Jobs
- Implementation
- Topics
- Data pipelines
Credit
- Made by
- Original
- github.com/google/skills/blob/92776fbf3875a5ee7424124e398956a…
- License
- Apache-2.0
Listed by Skill Manifest; not made by us.
InstallInstall it with npx.
npx skills add google/skills
Install factsScanned 2 Nov 2026
- Adds
- .claude/skills/bigquery-basics/ (the skill folder)
- 10 file(s) the skill refers to
- Runs scripts
- Yes
- shell block in the text
- Uses the network
- None found
- Needs secrets
- None found
- Source revision
- 92776fbf3875
- Licence
- Apache-2.0
- Last activity
- 1 Nov 2026
- Review
- Reviewed
Found by a static scan of the stored text; nothing is run. “None found” is not a guarantee, so read what you install before you run it.
- Only the main file is read; other files in the folder are not scanned
# 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
…