The AggText function sends a request to execute an aggregate warehouse function that returns a text data type. This function is the aggregation version of CallText.

Syntax

AggText(function name, arguments...)

Function arguments:

  • function name (required) - an aggregate warehouse function to execute
  • arguments (required) - one or more arguments to pass to the warehouse function

📘

All arguments must meet the warehouse function’s input requirements. Unsupported arguments result in an invalid formula.

Example

A table contains a Customer Name column that generates each region's top five customers based on purchase activity. Using the AggText function, you can execute Snowflake's MIN function in a higher grouped level of the table to return the first customer according to alphabetical order.

AggText("MIN", [Customer Name])

Returns the first Customer Name value (based on alphabetical order) for each region in the Store Region column.


Related resources