Stream Analytics query language (SAQL) comes with many built-in functions to assist with aggregating and transforming data. These functions can help us with simple operations on a single value, as in data type conversions and string concatenations, as well as with more complex operations, like identifying the first event in a period of time or geospatial intersections of event locations. Types of built-in functions include scalar, record, mathematical, input metadata, date and time, aggregate, analytic, geospatial, and array functions.
Built-in functions
Scalar functions
Simple functions that operate on a single value and return a single value are known as scalar functions. SAQL provides many scalar functions for string...