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。离线整理了版式、链接和媒体显示。
