Bigquery detail billing information

On web UI, BigQuery only provide billing info of limited historical queries. If we need billing info of more queries, Google Cloud SDK can help:

# historical query jobs list, 200 rows
bq --project_id project-xxxx ls -j -a -n 200

# detail of one query
bq --project_id project-xxxx show --format=prettyjson -j job_iMXpa7M7PRv3ZvUMdaxxxxxxx

in the output json document, the key: “totalBytesBilled” indicates the billing info of this query.