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
- 最近更新
- 2026-11-01
- Stars
- ★ 0
- 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 资源文件 20
- 参考文档references/ai-evaluate.md2.2 KB
- 参考文档references/ai-forecast.md3.0 KB
- 参考文档references/ai-generate-embedding.md1.6 KB
- 参考文档references/ai-generate-table.md2.9 KB
- 参考文档references/BIGFRAMES.md2.6 KB
- 参考文档references/BQML.md1.7 KB
- 参考文档references/ml-contribution-analysis.md4.8 KB
- 参考文档references/OPTIMIZATION.md1.4 KB
- 参考文档references/remote-models.md871 B
- 参考文档references/vector-search.md4.0 KB
- 参考文档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
yeet
Use only when the user explicitly asks to stage, commit, push, and open a GitHub pull request in one flow using the GitHub CLI (`gh`).
yayin-seo-geo-yasal-denetim
Bir web uygulaması canlıya çıkmadan veya iş teslimi biterken resmî/kurumsal sayfaları, SEO, GEO, indeksleme ve canlı çıktıyı denetler; eksikleri kodda tamamlar ve üretimde kanıtlar. Uygulama bitti, canlıya hazır mı, yayına al, launch checklist, release readiness, SEO audit, GEO audit, legal pages, privacy policy, terms, cookies, KVKK, robots, sitemap, canonical, hreflang, JSON-LD, llms.txt ifadelerinde kullan. Yeni veya önemli ölçüde değişmiş halka açık web uygulamasının son teslim aşamasında kullanıcı ayrıca istemese de uygula. Güvenlik sızma testi için güvenlik skillini ayrıca kullan.
xurl
X/Twitter via xurl CLI: post, search, DM, media, v2 API.
wrangler
Cloudflare Workers CLI for deploying, developing, and managing Workers, KV, R2, D1, Vectorize, Hyperdrive, Workers AI, Containers, Queues, Workflows, Pipelines, and Secrets Store. Load before running wrangler commands to ensure correct syntax and best practices. Biases towards retrieval from Cloudflare docs over pre-trained knowledge.
winui-app
Bootstrap, develop, and design modern WinUI 3 desktop applications with C# and the Windows App SDK using official Microsoft guidance, WinUI Gallery patterns, Windows App SDK samples, and CommunityToolkit components. Use when creating a brand new app, preparing a machine for WinUI, reviewing, refactoring, planning, troubleshooting, environment-checking, or setting up WinUI 3 XAML, controls, navigation, windowing, theming, accessibility, responsiveness, performance, deployment, or related Windows app design and development work.
whisper
OpenAI's general-purpose speech recognition model. Supports 99 languages, transcription, translation to English, and language identification. Six model sizes from tiny (39M params) to large (1550M params). Use for speech-to-text, podcast transcription, or multilingual audio processing. Best for robust, multilingual ASR.