BigQuery bq query examples

Use the bq query command to execute a SQL query

Execute SQL

bq query --use_legacy_sql=false "SELECT count(1) from myDataset.myTable;"

bq query --use_legacy_sql=false "CREATE TABLE `project-1`.myDataset.myTable \
as SELECT * from `project-2`.myDataset.myTable where id = 100;"