Skill · em Construir backend e dados

bigquery-basics

Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. Use for SQL queries, resource management, data ingestion, or AI applications on BigQuery.

Procedência

Antes de instalar

7 arquivos · 18,1 KB · só texto, nenhum script

Instalar na sua CLI

O comando baixa a versão fixada (commit 57f899e) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.

Claude Code

Neste projeto: instala em .claude/skills/bigquery-basics/.

d=".claude/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.claude/skills/bigquery-basics/.

d="$HOME/.claude/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Codex

Neste projeto: instala em .agents/skills/bigquery-basics/.

d=".agents/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.agents/skills/bigquery-basics/.

d="$HOME/.agents/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Antigravity

Neste projeto: instala em .agents/skills/bigquery-basics/.

d=".agents/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.gemini/antigravity-cli/skills/bigquery-basics/.

d="$HOME/.gemini/antigravity-cli/skills/bigquery-basics"
u="https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/skills/database/bigquery-basics"
curl -fsSL --create-dirs \
  -o "$d/SKILL.md" "$u/SKILL.md" \
  -o "$d/references/cli-usage.md" "$u/references/cli-usage.md" \
  -o "$d/references/client-library-usage.md" "$u/references/client-library-usage.md" \
  -o "$d/references/core-concepts.md" "$u/references/core-concepts.md" \
  -o "$d/references/iac-usage.md" "$u/references/iac-usage.md" \
  -o "$d/references/iam-security.md" "$u/references/iam-security.md" \
  -o "$d/references/mcp-usage.md" "$u/references/mcp-usage.md" \
  -o "$d/LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Peça ao Rook

Já usa o Rook Labs? Cole no chat do Rook: instale a skill https://rooklabs.sh/marketplace/cct.bigquery-basics

Prévia do SKILL.md

---
name: bigquery-basics
description: Manages datasets, tables, and jobs in BigQuery, and integrates with BigQuery ML and Gemini for advanced data analytics and AI-driven insights. Use for SQL queries, resource management, data ingestion, or AI applications on BigQuery.
source: google/skills (Apache 2.0)
---

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

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",
…

Ver todo o marketplace