← BigQuery557 / 640
hardbq

Run a BigQuery query that fails if it would process more than 1 GB of data

command

bq query --use_legacy_sql=false --maximum_bytes_billed=1000000000 'SELECT * FROM DATASET.TABLE'

also accepted

bq query --maximum_bytes_billedbq query --use_legacy_sql=false --maximum_bytes_billed

Command breakdown

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

bqquery--use_legacy_sql=false--maximum_bytes_billed=1000000000'SELECT*FROMDATASET.TABLE'
FlagPurpose
--use_legacy_sqlSet to: false
--maximum_bytes_billedSet to: 1000000000

More BigQuery commands

See all BigQuery commands →
← prevnext →
More BigQuery commands →Full cheat sheet →

Test your recall — not just your reading.

Practice with interactive quiz →