大网数据广告活动
Linux 与通用命令

bq · 常用命令示例

· 52CE 我爱测

A Python-based tool for BigQuery, Google Cloud's fully managed and completely serverless enterprise data warehouse. > More information: <https://docs.cloud.google.com/bigquery/docs/reference/bq-cli-reference>.

bq

A Python-based tool for BigQuery, Google Cloud's fully managed and completely serverless enterprise data warehouse. More information: https://docs.cloud.google.com/bigquery/docs/reference/bq-cli-reference.

  • Simulate a query against a BigQuery table using standard SQL, to estimate the number of bytes it would read:

bq query --nouse_legacy_sql --dry_run 'SELECT COUNT(*) FROM .'

  • Run a parameterized query:

bq query --use_legacy_sql=false --parameter='ts_value:TIMESTAMP:2016-12-07 08:00:00' 'SELECT TIMESTAMP_ADD(@ts_value, INTERVAL 1 HOUR)'

  • Create a new dataset or table in the US location:

bq mk --location=US .

  • List all datasets in a project:

bq ls --filter labels.: --max_results --format=prettyjson --project_id

  • Batch load data from a specific file in formats such as CSV, JSON, Parquet, and Avro to a table:

bq load --location --source_format .

  • Copy one table to another:

bq cp . .

  • Display help:

bq help

来源:tldr-pages contributors · 作者与贡献记录 · CC BY 4.0。离线整理了版式、链接和媒体显示。

资料来源与适用范围

资料来源
tldr-pages contributors
适用范围
请按文中版本与环境说明核对
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。