BigQuery can also be accessed and operated using the bq command. Here are some of the operations using the bq command in Cloud Shell:

• To view a table in your database:

bq show projectId:datasetId.tableId

• To run a certain query:

bq query "<<<query text>>>"  

• To create a new table:

bq mk <<<dataset name>>>

• To list the tables:

bq ls  

• To load the dataset along with the schema:

bq load <<<dataset_name.filename schema_text>>> 

• For example, to load the same babynames dataset as the GUI example:

bq load babynames.names2010 yob2010.txt name:string,gender:string,count:integer

• Finally, to remove a dataset, use:

 bq rm -r <<<datasetID>>>