Supported Snowflake Built-in Functions

A complete list of supported built-in functions for Snowflake is available in the SYSADMIN.SourceSupportedSystemFunctions system table.

To view this list, execute the following SQL query:

SQL

SELECT * FROM SYSADMIN.SourceSupportedSystemFunctions WHERE translator = 'snowflake';;

If a built-in function is not listed, it can be registered manually as a foreign function.
For instructions, see the “Built-in Functions” section on the Foreign Functions page.

List of Supported Functions

Function name	Description
`ARRAY_APPEND`	Returns an array containing all elements from the source array as well as the new element. The new element is located at end of the array
`ARRAY_COMPACT`	Returns a compacted array with missing and null values removed, effectively converting sparse arrays into dense arrays
`ARRAY_CONSTRUCT`	Returns an array constructed from zero, one, or more inputs
`ARRAY_SLICE`	Returns an array constructed from a specified subset of elements of the input array
`ARRAY_TO_STRING`	Returns an input array converted to a string by casting all values to strings (using `TO_VARCHAR`) and concatenating them (using the string from the second argument to separate the elements)
`OBJECT_DELETE`	Returns an object containing the contents of the input (i.e.source) object with one or more keys removed
`OBJECT_INSERT`	Returns an object consisting of the input object with a new key-value pair inserted (or an existing key updated with a new value)
`OBJECT_KEYS`	Returns an array containing the list of keys in the top-most level of the input object
`PARSE_JSON`	Interprets an input string as a JSON document, producing a `VARIANT`value
`TO_OBJECT`	Converts the input value to an `OBJECT`
`TO_VARIANT`	Converts any value to a `VARIANT` value or `NULL` (if input is `NULL`)
`ZEROIFNULL`	Returns `0` if its argument is null; otherwise, returns its argument.