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

# CallNumber

The **CallNumber** function calls a warehouse function that returns a Number datatype. This function can be used in the case of generating random samples of data for analysis. 

This function isn't compatible with all data platform connections. To check if your connection supports it, see [Supported data platforms and feature compatibility](/docs/region-warehouse-and-feature-support#supported-data-platforms-and-feature-compatibility).

## Syntax

`CallNumber(function name, argument1, argument2, ...)`

Function arguments:

* **function name** (required): The name of the warehouse function to call.
* **argument** (required): The argument(s) to pass into the warehouse function. Multiple arguments are supported.

## Example

A table contains a Cust Key column that serves as the unique identifier for each customer. You can pass Snowflake's [UNIFORM](https://docs.snowflake.com/en/sql-reference/functions/uniform) function to the **CallNumber** function to generate a uniformly distributed set of random numbers when creating a filter column *Flag* to randomly select *n* number of customers.

`CallNumber("uniform", 1, 10, CallNumber("random"))`

* Return a list of random generated numbers between 1-10 to map to each customer. 

Snowflake's [RANDOM](https://docs.snowflake.com/en/sql-reference/functions/random) function is used as the **`<gen>`** argument of the UNIFORM function to generate a list of pseudo-random 64-bit integers within the specified range.

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/19df3c1a06ef7b399d97b6c9c80be8c13f97e97ecfd25ead07e12d71d6c93bcf/assets/docs-images/ed7f32d-6.png)

## Related resources

* [CallLogical](/docs/calllogical)
* [CallVariant](/docs/callvariant)
* [CallText](/docs/calltext)
* [CallDatetime](/docs/calldatetime)