Using the bq CLI utility with BigQuery

Remember that in additional to the Cloud Console GUI or client libraries, you can also perform BigQuery tasks using the bq command-line interface.

It's included with the gcloud SDK and once you have logged in, you can perform a number of operations such as:
- run queries against BQ
- create, copy and delete tables
- load data into tables
- view IAM policies for a BQ asset and much more

How I've used it until now:
- impersonate service accounts
- perform operations that are/were not supported in the SQL interface, such as copying partitions between tables

Any other interesting ways you're using the bq cli tool?

No alt text provided for this image

Found it useful? Subscribe to my Analytics newsletter at