bq
List of commands for bq:
-
bq:tldr:192e6 bq: 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=${select} ${dataset}.${table} ${path_to_source}try on your machineexplain this command
-
bq:tldr:1feb7 bq: Create a new dataset or table in the US location.$ bq mk --location=US ${dataset_name}.${table_name}try on your machineexplain this command
-
bq:tldr:433c6 bq: Copy one table to another.$ bq cp ${dataset}.${OLD_TABLE} ${dataset}.${new_table}try on your machineexplain this command
-
bq:tldr:6ee1c bq: List all datasets in a project.$ bq ls --filter labels.${key}:${value} --max_results ${integer} --format=prettyjson --project_id ${project_id}try on your machineexplain this command
-
bq:tldr:ddf5a bq: 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)'try on your machineexplain this command
-
bq:tldr:ea5a3 bq: Run query against a BigQuery table using standard SQL, add `--dry_run` flag to estimate the number of bytes read by the query.$ bq query --nouse_legacy_sql 'SELECT COUNT(*) FROM ${DATASET_NAME}.${TABLE_NAME}'try on your machineexplain this command