22 Sep 21 ·  mCollins in Bigquery ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

BigQuery bq query examples

Use the bq query command to execute a SQL query

Execute SQL

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


posted on 22 Sep 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds