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.
- Author
- 420company ↗
- Repository
- artemis ↗
- Licence
- MIT
- Last repository change
- 25.10.2026
Assessment and security
- Files in this package
- 12
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
No signals detected. Repository changed on 25.10.2026, without references to retired models or APIs.
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…