Learning Google BigQuery

Conventions

In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "If the table already exists then the bq utility will throw the error Already Exists: Table project-id:datasetname.tablename."

A block of code is set as follows:

SELECT year(pickup_datetime) as trip_year, count(1) as trip_countFROM [nyc-tlc:yellow.trips] 

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

{  "rule":
  [
    {