Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: "You can now start entering an alias for your input connection. Name it something such as airdelaystreaminginput."

A block of code is set as follows:

SELECT
    t1.Cartype,
    SUM(t2.mgNOx/60) as SumNOx
FROM
    Cartraffic as t1 TIMESTAMPED BY ObservedT
JOIN
    CarStats as t2
ON
    t1.Cartype = t2.Cartype
GROUP BY 
    t1.Cartype,
    TUMBLINGWINDOW(minute, 10)

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

SELECT 
    CensusStation,
    COUNT(*) as Amount
FROM
    Cartraffic 
TIMESTAMP BY 
    ObservedT
GROUP BY 
    CensusStation,
    System.Timestamp()

Bold: Indicates a new term, an important word, or words that you see onscreen. For example, words in menus or dialog boxes appear in the text like this. Here is an example: "Please click Create to start the provisioning of your configuration."

Tips or important notes

Appear like this.