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.
- License 许可
- Apache-2.0
- 所属仓库
- saski/arnesto
- 最近更新
- 2026-11-12
- Stars
- ★ 6
- Forks
- 0
01 前言 Front Matter
- name
- developing-with-bigquery
- license
- Apache-2.0
- metadata
- { "version": "v1", "publisher": "google" }
- 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.
02 资源文件 10
- 参考文档resources/ai-evaluate.md2.2 KB
- 参考文档resources/ai-forecast.md3.0 KB
- 参考文档resources/ai-generate-embedding.md1.6 KB
- 参考文档resources/ai-generate-table.md2.9 KB
- 参考文档resources/BIGFRAMES.md2.6 KB
- 参考文档resources/BQML.md1.7 KB
- 参考文档resources/ml-contribution-analysis.md4.8 KB
- 参考文档resources/OPTIMIZATION.md1.4 KB
- 参考文档resources/remote-models.md871 B
- 参考文档resources/vector-search.md4.0 KB
03 SKILL.md 正文
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,
exportkeyword), 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
2. BigFrames (BigQuery DataFrames)
Guidelines for generating valid BigFrames code for data manipulation, model development, and visualization. - Guide: 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 - Functions Reference: - AI.FORECAST - AI.EVALUATE - AI.GENERATE_TABLE - AI.GENERATE_EMBEDDING - Remote Models CONTRIBUTION_ANALYSIS VECTOR_SEARCH
4. Notebook SQL cells
Refer to @skill:notebook-guidance for standards on running BigQuery in
notebooks.
04 同仓库更多 Skills
visualize
Use /visualize for creating compact charts, diagrams, or other visuals inline as part of the conversation itself. It chooses among Markdown tables, Mermaid, inline HTML, and other supported in-transcript forms. Use Canvas for durable artifacts outside the transcript that users may revisit, refine, or share.
update-cursor-settings
Modify Cursor/VSCode user settings in settings.json. Use when you want to change editor settings, preferences, configuration, themes, font size, tab size, format on save, auto save, keybindings, or any settings.json values.
update-cli-config
View and modify Cursor CLI configuration settings in ~/.cursor/cli-config.json. Use when the user wants to change CLI settings, configure permissions, switch approval mode, enable vim mode, toggle display options, configure sandbox, or manage any CLI preferences.
statusline
Configure a custom status line in the CLI. Use when the user mentions status line, statusline, statusLine, CLI status bar, prompt footer customization, or wants to add session context above the prompt.
split-to-prs
Split current work into small reviewable PRs. Use when the user asks to split a chat, set of changes, branch, or PR.
shell
Runs the rest of a /shell request as a literal shell command. Use only when the user explicitly invokes /shell and wants the following text executed directly in the terminal.