When developing a window aggregate function, be aware of the following:
- When specifying the return type of the function, you should consider the allowable window sizes and select an appropriate return data type to avoid overflows.
- Vantage does not validate if a window aggregate UDF is used in a specific window type, so you may want to include window type checking code into your function.