CallGeography

View as Markdown

The CallGeography function calls a warehouse function that returns data with the Geography data type.

You can use the Geography function on Snowflake and BigQuery connections.

CallGeography 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 CallGeography, you can use a function that returns Geography data.

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

CallGeography(function_name, argument1, ...)

The function has these arguments:

function_name
Required
The name of the warehouse function that Sigma invokes
argument1 …
Optional
The arguments of the invoked function
Functions may have 0 or more arguments