← BigQuery552 / 640

hardbq

Run a BigQuery query and write the results to a destination table

command

bq query --use_legacy_sql=false --destination_table=DATASET.RESULTS_TABLE 'SELECT * FROM DATASET.TABLE'

also accepted

bq query --destination_tablebq query --use_legacy_sql=false --destination_table

Command breakdown

Part of the BigQuery CLI (bq) — BigQuery category.

bqquery--use_legacy_sql=false--destination_table=DATASET.RESULTS_TABLE'SELECT*FROMDATASET.TABLE'

Flag	Purpose
`--use_legacy_sql`	Set to: false
`--destination_table`	Set to: DATASET.RESULTS_TABLE

More BigQuery commands

List all datasets in the current BigQuery projectbq ls
Create a new BigQuery datasetbq mk DATASET_NAME
Display schema and metadata for a BigQuery tablebq show DATASET.TABLE
Run a BigQuery query using standard SQL (GoogleSQL)bq query --use_legacy_sql=false 'SELECT * FROM DATASET.TABLE'
Load a CSV file from Cloud Storage into a BigQuery table using a schema filebq load DATASET.TABLE gs://BUCKET/FILE.csv SCHEMA.json
Export a BigQuery table to a CSV file in Cloud Storagebq extract DATASET.TABLE gs://BUCKET/export.csv
Delete a BigQuery table without prompting for confirmationbq rm -f DATASET.TABLE
Display the first rows of a BigQuery tablebq head DATASET.TABLE

See all BigQuery commands →

← prev next →

More BigQuery commands →Full cheat sheet →

Test your recall — not just your reading.

Practice with interactive quiz →