Skip to content
Skills Library
Data & analytics · Building & coding

developing-with-bigquery

/developing-with-bigquery

A repository of BigQuery-specific logic, knowledge, and specialized standards. Use this skill whenever you are doing anything with BigQuery, including: 1. BigQuery query optimization 2. BigFrames Python code 3. BigQuery ML/AI functions.

Repository
artemis ↗
Licence
MIT
Last repository change
25.10.2026

Assessment and security

80/ 100Class: good
Format20 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content20 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
12
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 25.10.2026, without references to retired models or APIs.

Licence

MIT, open: use and modify while retaining author attribution.

What it does and when to use it

A repository of BigQuery-specific logic, knowledge, and specialized standards. Use this skill whenever you are doing anything with BigQuery, including: 1. BigQuery query optimization 2. BigFrames Python code 3. BigQuery ML/AI functions.

Original author description

A repository of BigQuery-specific logic, knowledge, and specialized standards. Use this skill whenever you are doing anything with BigQuery, including: 1. BigQuery query optimization 2. BigFrames Python code 3. BigQuery ML/AI functions.

How it works

SKILL.md has no level-two headings · 46 lines, 197 words

SKILL.md preview
---
name: developing-with-bigquery
description: |
  A repository of BigQuery-specific logic, knowledge, and specialized standards.
  Use this skill whenever you are doing anything with BigQuery, including:
    1. BigQuery query optimization
    2. BigFrames Python code
    3. BigQuery ML/AI functions.
license: Apache-2.0
metadata:
  version: v1
  publisher: google
---

This skill provides comprehensive guidance for BigQuery services, optimizations,
and data handling. It acts as a routing table for specialized BigQuery topics.

> [!IMPORTANT] For general standards on running BigQuery in notebooks (SQL
> cells, `export` keyword), see `@skill:notebook-guidance`.

> [!IMPORTANT] You MUST check the data size before deciding on which libraries
> to use. Use the data size to justify your decision.

Refer to the following resources for expert guidance on specific BigQuery
features:

### 1. Query Optimization

Performance and efficiency guidelines for BigQuery SQL. Includes rules for
column pruning, pushdown, and materialization strategies. - **Guide**:
[OPTIMIZATION.md](resources/OPTIMIZATION.md)

### 2. BigFrames (BigQuery DataFrames)

Guidelines for generating valid BigFrames code for data manipulation, model
development, and visualization. - **Guide**:
[BIGFRAMES.md](resources/BIGFRAMES.md)

Bigframes should be the default library/tool as it is more efficient than using
the BigQuery Python client library.

### 3. BigQuery ML & AI Functions (BQML SQL)

Usage rules and syntax standards for all BigQuery AI/ML functions via SQL
(Forecasting, Generative AI, Classification, etc.). - **Guide**:
[BQML.md](resources/BQML.md) - **Functions Reference**: -
[AI.FORECAST](resources/ai-forecast.md) -
[AI.EVALUATE](resources/ai-evaluate.md) -
[AI.GENERATE_TABLE](resources/ai-generate-table.md) -
[AI.GENERATE_EMBEDDING](resources/ai-generate-embedding.md) -
[Remote Models](resources/remote-models.md)
[CONTRIBUTION_ANALYSIS](resources/ml-contribution-analysis.md)
[VECTOR_SEARCH](resources/vector-search.md)

### 4. Notebook SQL cells

Refer to `@skill:notebook-guidance` for standards on running BigQuery in
notebooks.
Files in this package (12)
  • SKILL.json 1 KB
  • SKILL.md 2 KB
  • resources/BIGFRAMES.md 3 KB
  • resources/BQML.md 2 KB
  • resources/OPTIMIZATION.md 1 KB
  • resources/ai-evaluate.md 2 KB
  • resources/ai-forecast.md 3 KB
  • resources/ai-generate-embedding.md 2 KB
  • resources/ai-generate-table.md 3 KB
  • resources/ml-contribution-analysis.md 5 KB
  • resources/remote-models.md 1 KB
  • resources/vector-search.md 4 KB

Versions

The database has no other skills named developing-with-bigquery.

Database snapshot: 13.11.2026 · package version fc93703af6bd (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 90bigquery-bigframes
    Generates Python code using BigQuery DataFrames (BigFrames). Use by default for any Python data task involving BigQuery, including data processing, analysis, and machine learning. Don't use for SQL-first workflows or the google-cloud-bigquery client library — use bigquery-basics.
  • 100bigquery-bigframes
    Generates Python code using BigQuery DataFrames (BigFrames). Use by default for any Python data task involving BigQuery, including data processing, analysis, and machine learning. Don't use for SQL-first workflows or the google-cloud-bigquery client library — use bigquery-basics.
  • 100bigquery-bigframes
    Generates Python code using BigQuery DataFrames (BigFrames), the pandas/scikit-learn-style API over BigQuery. Use when writing BigFrames code or doing pandas-style dataframe/ML work against BigQuery (e.g. in a notebook). Don't use for SQL-first workflows or the…
  • 92write-script-bigquery
    MUST use when writing BigQuery queries.
  • 100bigquery-udfs
    Creates, deploys, and troubleshoots BigQuery User-Defined Functions (UDFs) and Remote Functions across SQL, JavaScript, Python, and Cloud Run endpoints. Use when writing custom scalar or aggregate functions in BigQuery, installing PyPI packages or Cloud Storage libraries in a…
  • 100bigquery-scheduled-query
    Manage bigquery scheduled query operations. Auto-activating skill for GCP Skills. Triggers on: bigquery scheduled query, bigquery scheduled query Part of the GCP Skills skill category. Use when working with bigquery scheduled query functionality. Trigger with phrases like…

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.