I want to set maximum bytes billed to 1000000 How do I do this

Question

How to set maximum billed bytes property if I have to set it to 1000000 bytes?

Answer 1

In the CLI, use bq query command with the --maximum_bytes_billed flag.

bq query --maximum_bytes_billed=1000000 \
--use_legacy_sql=false \
'SELECT
   word
 FROM
   `bigquery-public-data`.samples.shakespeare'

This should do!