Passthrough functions

AggText

View as Markdown

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.

AggText 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 AggText, you can use a function that returns a text 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

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.