Passthrough functions

CallText

View as Markdown

The CallText function sends a request to execute a warehouse function that returns a text value. This is often used to extract and display numbers in a more readable format or to join digits with text or symbols.

CallText 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 CallText, 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

CallText(function_name, argument)

Function arguments:

function nameThe warehouse function to call.
argumentOne 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 Revenue column that provides restaurant revenue data as a number value. Using the CallText function, you can execute Snowflake’s TO_CHAR function to extract digits and preserve the number format when combining Revenue and Currency values into a single text string.

Concat("$", CallText("TO_CHAR", [Revenue], "999,999,999,999.00"), " ", [Currency])

Returns the Revenue value as a text string and preserves the number format (999,999.999.00) upon text conversion.

Screenshot_2023-04-21_at_10.34.01_AM.png