CmdID

CmdID / Commands

bq

A Python-based tool for BigQuery, Google Cloud's fully managed and completely serverless enterprise data warehouse. tldr-pages

On several platforms

Opens CmdID with your command. It is read in your browser and sent nowhere.

Several platforms

from tldr-pages, CC BY 4.0

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 DATASET_NAME.TABLE_NAME'Identify

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)'Identify

Create a new dataset or table in the US location

bq mk --location=US dataset_name.table_nameIdentify

List all datasets in a project

bq ls --filter labels.key:value --max_results integer --format=prettyjson --project_id project_idIdentify

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

bq load --location location --source_format CSV dataset.table path/to/sourceIdentify

Copy one table to another

bq cp dataset.OLD_TABLE dataset.new_tableIdentify

Display help

bq helpIdentify