developing-with-bigquery

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

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:

本技能为BigQuery服务、优化及数据处理提供全面指导，可作为BigQuery专项主题的路由索引。

[!IMPORTANT] 关于在笔记本中运行BigQuery的通用标准（SQL单元格、
export
关键字），请参考
@skill:notebook-guidance
。

[!IMPORTANT] 在决定使用哪些库之前，你必须检查数据大小，并以此为依据证明你的决策合理性。

如需了解BigQuery特定功能的专业指导，请参考以下资源：

1. Query Optimization

1. 查询优化

Performance and efficiency guidelines for BigQuery SQL. Includes rules for column pruning, pushdown, and materialization strategies. - Guide: OPTIMIZATION.md

BigQuery SQL的性能与效率指南，包含列裁剪、下推和物化策略的规则。- 指南: OPTIMIZATION.md

2. BigFrames (BigQuery DataFrames)

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.

生成用于数据操作、模型开发和可视化的有效BigFrames代码的指南。- 指南: BIGFRAMES.md

BigFrames应作为默认库/工具，因为它比BigQuery Python客户端库更高效。

3. BigQuery ML & AI Functions (BQML SQL)

3. BigQuery ML & AI函数（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

所有通过SQL调用的BigQuery AI/ML函数（预测、生成式AI、分类等）的使用规则和语法标准。- 指南: BQML.md - 函数参考: - AI.FORECAST - AI.EVALUATE - AI.GENERATE_TABLE - AI.GENERATE_EMBEDDING - Remote Models CONTRIBUTION_ANALYSIS VECTOR_SEARCH

4. Notebook SQL cells

4. 笔记本SQL单元格

Refer to

@skill:notebook-guidance

for standards on running BigQuery in notebooks.

关于在笔记本中运行BigQuery的标准，请参考

@skill:notebook-guidance

。