AggVariant
The AggVariant function calls a warehouse aggregate function that returns a Variant data type. This function is the aggregate version of CallVariant and can be applied to identify distinct values from a lower grouped level in the parent/higher level grouping of a table.
Syntax
AggVariant(function name, arguments...)
Function arguments:
- function name (required): The name of an aggregate function supported by your data warehouse.
-
arguments (required): One or more arguments to be passed to the warehouse function. All arguments must meet the warehouse function’s input requirements.
Example
A table contains an ARRAY_UNIQUE_AGG column that returns an array containing all the distinct customers who purchased at least one or more items per Product Type. You can pass Snowflake's ARRAY_UNION_AGG function to the AggVariant function to identify all distinct customers who made at least one purchase that week.
The ARRAY_UNION_AGG function takes in one column containing the arrays with distinct values as produced by Snowflake's ARRAY_UNIQUE_AGG function.
AggVariant("ARRAY_UNION_AGG", [ARRAY_UNIQUE_AGG])
- Return an array that contains the union of distinct customers from the input arrays in the ARRAY_UNIQUE_AGG column.