- TargetColumns
- [Optional] Specifies the names of the input columns for which the simple moving average is to be computed. Default behavior: The function copies all numeric input columns to the output table.
- IncludeFirst
- [Optional] Specifies whether to output window_size rows. Because the simple moving average for the first window_size rows is undefined, the function returns NULL values for those columns. Default: 'false'.
- WindowSize
- [Optional]
The SMAVG function ignores case in schema names, table names, and column names. If such a name contains capital letters, you must surround the name with double quotation marks. For example: TargetColumns ('"City"', 'date')