AggGeography
The AggGeography function calls a warehouse aggregate function that returns a Geography data type. This function is the aggregate version of CallGeography.
AggGeography is a passthrough function.
The functions that can be used with a passthrough function depend on your connected data platform’s native SQL functions. For example, on Snowflake connections, browse the Snowflake SQL function reference to find functions that return a value that matches the datatype of the passthrough function.
With AggGeography, you can use a function that returns a geography value.
This function isn’t compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.
Syntax
The function has these arguments:
- function_name
- Required
- The name of the warehouse function that Sigma invokes
- argument1 …
- Optional
- The arguments of the invoked function
- Functions may have
0or more arguments