bq

> The bq command-line tool is a Python-based command-line tool for BigQuery.

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}'

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 {dataset_name}.{table_name}

List all datasets in a project:

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

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|JSON|PARQUET|AVRO} {dataset}.{table} {path_to_source}

Copy one table to another:

bq cp {dataset}.{OLD_TABLE} {dataset}.{new_table}

Print help:

bq help

> This work is licensed under the Creative Commons Attribution 4.0 International License (CC-BY).

-- Response ended

-- Page fetched on Tue May 21 01:42:22 2024