9951 explained code solutions for 126 technologies

google-big-queryHow do I use Google BigQuery language to query data?

Google BigQuery is a serverless, highly scalable, and cost-effective cloud data warehouse. It enables you to query large datasets using a SQL-like language called BigQuery SQL. Here is an example of a query in BigQuery SQL to count the number of records in a table:

FROM `bigquery-public-data.samples.shakespeare`

Output example


Code explanation

  • SELECT - specifies which columns of the table you want to query. In this case, the asterisk (*) is used to select all columns.
  • FROM - specifies the source table you want to query. In this case, the table is bigquery-public-data.samples.shakespeare.
  • COUNT(*) - returns the number of records that meet the criteria of the SELECT statement.

For more information on using BigQuery SQL to query data, please refer to the Google Cloud BigQuery Documentation.

Edit this code on GitHub