Learning Google BigQuery

BigQuery SQL functions

BigQuery, much like other database management systems, allows users to use functions on their data. Functions are objects that perform actions on input data and output result data. While there are a number of different types of functions, this section will focus on the basic string (which acts on string or character values) and Aggregate functions (which act on a set of values to return a single value). In most cases, functions can be used by typing the function name and wrapping the value that will be acted upon in parentheses. In some cases, a function parameter (or parameters) will also have to be added, which is usually delimited by a comma. Here is an example:

FUNCTION_NAME(value,<parameter>)

Function

Function ...