> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/docs/passthrough-functions/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# Passthrough functions

> Browse Sigma passthrough functions available in formulas and calculations.

Passthrough functions send requests to execute operations within your connected data platform, then return the response generated by your data platform's native functions.

| Function                             | Description                                                                                                                                                                       |
| ------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [AggDatetime](/docs/aggdatetime)     | Calls a data platform aggregate function that returns a [date data type](/docs/data-types-and-formats#date). Aggregate version of [CallDatetime](/docs/calldatetime).             |
| [AggGeography](/docs/agggeography)   | Calls a data platform aggregate function that returns a [geography data type](/docs/data-types-and-formats#geography). Aggregate version of [CallGeography](/docs/callgeography). |
| [AggLogical](/docs/agglogical)       | Calls a data platform aggregate function that returns a [logical data type](/docs/data-types-and-formats#logical). Aggregate version of [CallLogical](/docs/calllogical).         |
| [AggNumber](/docs/aggnumber)         | Calls a data platform aggregate function that returns a [number data type](/docs/data-types-and-formats#number). Aggregate version of [CallNumber](/docs/callnumber).             |
| [AggText](/docs/aggtext)             | Calls a data platform aggregate function that returns a [text data type](/docs/data-types-and-formats#text). Aggregate version of [CallText](/docs/calltext).                     |
| [AggVariant](/docs/aggvariant)       | Calls a data platform aggregate function that returns a [variant data type](/docs/data-types-and-formats#variant). Aggregate version of [CallVariant](/docs/callvariant).         |
| [CallDatetime](/docs/calldatetime)   | Calls a data platform function that returns a [date data type](/docs/data-types-and-formats#date).                                                                                |
| [CallGeography](/docs/callgeography) | Calls a data platform function that returns a [geography data type](/docs/data-types-and-formats#geography).                                                                      |
| [CallLogical](/docs/calllogical)     | Calls a data platform function that returns a [logical data type](/docs/data-types-and-formats#logical).                                                                          |
| [CallNumber](/docs/callnumber)       | Calls a data platform function that returns a [number data type](/docs/data-types-and-formats#number).                                                                            |
| [CallText](/docs/calltext)           | Calls a data platform function that returns a [text data type](/docs/data-types-and-formats#text).                                                                                |
| [CallVariant](/docs/callvariant)     | Calls a data platform function that returns a [variant data type](/docs/data-types-and-formats#variant).                                                                          |

> Official documentation and guidance for using Sigma to build AI apps, dashboards, and agents on governed warehouse data.

## Docs

- [AggDatetime](https://help.sigmacomputing.com/docs/aggdatetime.md): Use the Sigma AggDatetime function to send a request to run an aggregate warehouse function that returns a date data type.
- [AggGeography](https://help.sigmacomputing.com/docs/agggeography.md): Use the Sigma AggGeography function to call a warehouse aggregate function that returns a Geography data type.
- [AggLogical](https://help.sigmacomputing.com/docs/agglogical.md): Use the Sigma AggLogical function to call a warehouse aggregate function that returns a Logical data type.
- [AggNumber](https://help.sigmacomputing.com/docs/aggnumber.md): Use the Sigma AggNumber function to call a warehouse aggregate function that returns a Number data type.
- [AggText](https://help.sigmacomputing.com/docs/aggtext.md): Use the Sigma AggText function to send a request to run an aggregate warehouse function that returns a text data type.
- [AggVariant](https://help.sigmacomputing.com/docs/aggvariant.md): Use the Sigma AggVariant function to call a warehouse aggregate function that returns a Variant data type.
- [CallDatetime](https://help.sigmacomputing.com/docs/calldatetime.md): Use the Sigma CallDatetime function to call a warehouse function that returns a datetime data value.
- [CallGeography](https://help.sigmacomputing.com/docs/callgeography.md): Use the Sigma CallGeography function to call a warehouse function that returns a Geography data type.
- [CallLogical](https://help.sigmacomputing.com/docs/calllogical.md): Use the Sigma CallLogical function to call a warehouse function that returns a Logical datatype.
- [CallNumber](https://help.sigmacomputing.com/docs/callnumber.md): Use the Sigma CallNumber function to call a warehouse function that returns a Number datatype.
- [CallText](https://help.sigmacomputing.com/docs/calltext.md): Use the Sigma CallText function to send a request to run a warehouse function that returns a text value.
- [CallVariant](https://help.sigmacomputing.com/docs/callvariant.md): Use the Sigma CallVariant function to call a warehouse function that returns a Variant datatype.