Semi-Structured and Structured Data Functions

array_append

the resulting array Supported Signatures

function array_append(array, $1) returns array

🔗 Official Documentation

array_cat

Concatenate two arrays Supported Signatures

function array_cat(array, array) returns array
function array_cat(variant, variant) returns array
function array_cat(array, variant) returns array
function array_cat(variant, array) returns array

🔗 Official Documentation

array_compact

Compact array by removing nulls Supported Signatures

function array_compact(array) returns array
function array_compact(variant) returns array

🔗 Official Documentation

array_construct

the resulting array Supported Signatures

function array_construct(...) returns array

🔗 Official Documentation

array_construct_compact

the resulting array Supported Signatures

function array_construct_compact(...) returns array

🔗 Official Documentation

array_contains

Returns true if array contains value Supported Signatures

function array_contains(variant, array) returns boolean
function array_contains($1, array) returns boolean

🔗 Official Documentation

array_distinct

the resulting array Supported Signatures

function array_distinct(array) returns array

🔗 Official Documentation

array_except

the resulting array Supported Signatures

function array_except(array, array) returns array

🔗 Official Documentation

array_flatten

the resulting array Supported Signatures

function array_flatten(array) returns array

🔗 Official Documentation

array_generate_range

the resulting array Supported Signatures

function array_generate_range(decimal(38, 0), decimal(38, 0)) returns array
function array_generate_range(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns array

🔗 Official Documentation

array_insert

the resulting array Supported Signatures

function array_insert(array, decimal(38, 0), $1) returns array

🔗 Official Documentation

array_intersection

the resulting array Supported Signatures

function array_intersection(array, array) returns array

🔗 Official Documentation

array_max

the maximum defined element in the array, or NULL Supported Signatures

function array_max(array) returns variant

🔗 Official Documentation

array_min

the minimum defined element in the array, or NULL Supported Signatures

function array_min(array) returns variant

🔗 Official Documentation

array_position

Returns the first index position of the element in the array Supported Signatures

function array_position(variant, array) returns decimal(38, 0)
function array_position($1, array) returns decimal(38, 0)

🔗 Official Documentation

array_prepend

the resulting array Supported Signatures

function array_prepend(array, $1) returns array

🔗 Official Documentation

array_remove

the resulting array Supported Signatures

function array_remove(array, variant) returns array
function array_remove(array, $1) returns array

🔗 Official Documentation

array_remove_at

the resulting array Supported Signatures

function array_remove_at(array, decimal(38, 0)) returns array

🔗 Official Documentation

array_size

Returns array size Supported Signatures

function array_size(array) returns decimal(38, 0)
function array_size(variant) returns decimal(38, 0)

🔗 Official Documentation

array_slice

the resulting array Supported Signatures

function array_slice(array, decimal(38, 0), decimal(38, 0)) returns array

🔗 Official Documentation

array_sort

the sorted array Supported Signatures

function array_sort(array) returns array
function array_sort(array, boolean) returns array
function array_sort(array, boolean, boolean) returns array

🔗 Official Documentation

array_to_string

Convert array to a string Supported Signatures

function array_to_string(array, varchar) returns varchar
function array_to_string(variant, varchar) returns varchar

🔗 Official Documentation

arrays_overlap

Returns true if two arrays have elements in common Supported Signatures

function arrays_overlap(array, array) returns boolean

🔗 Official Documentation

arrays_to_object

the resulting object Supported Signatures

function arrays_to_object(array, array) returns object

🔗 Official Documentation

as_array

Use VARIANT value as ARRAY Supported Signatures

function as_array(variant) returns array

🔗 Official Documentation

as_binary

Use VARIANT value as binary string Supported Signatures

function as_binary(variant) returns binary

🔗 Official Documentation

as_boolean

Use VARIANT value as Boolean Supported Signatures

function as_boolean(variant) returns boolean

🔗 Official Documentation

as_char

Use VARIANT value as text string Supported Signatures

function as_char(variant) returns varchar

🔗 Official Documentation

as_date

Use VARIANT value as DATE Supported Signatures

function as_date(variant) returns date

🔗 Official Documentation

as_decimal

Use VARIANT value as decimal fixed-point Supported Signatures

function as_decimal(variant) returns decimal(38, 0)
function as_decimal(variant, decimal(38, 0)) returns decimal(38, 0)
function as_decimal(variant, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

as_double

Use VARIANT value as real Supported Signatures

function as_double(variant) returns double

🔗 Official Documentation

as_integer

Use VARIANT value as integer Supported Signatures

function as_integer(variant) returns decimal(38, 0)
function as_integer(variant, decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

as_number

Use VARIANT value as as decimal fixed-point Supported Signatures

function as_number(variant) returns decimal(38, 0)
function as_number(variant, decimal(38, 0)) returns decimal(38, 0)
function as_number(variant, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)

🔗 Official Documentation

as_object

Use VARIANT value as OBJECT Supported Signatures

function as_object(variant) returns object

🔗 Official Documentation

as_real

Use VARIANT value as real Supported Signatures

function as_real(variant) returns double

🔗 Official Documentation

as_time

Use VARIANT value as TIME Supported Signatures

function as_time(variant) returns time

🔗 Official Documentation

as_timestamp_ltz

Use VARIANT value as TIMESTAMP_LTZ Supported Signatures

function as_timestamp_ltz(variant) returns timestamp
function as_timestamp_ltz(variant, decimal(38, 0)) returns timestamp

🔗 Official Documentation

as_timestamp_ntz

Use VARIANT value as TIMESTAMP_NTZ Supported Signatures

function as_timestamp_ntz(variant) returns timestamp
function as_timestamp_ntz(variant, decimal(38, 0)) returns timestamp

🔗 Official Documentation

as_timestamp_tz

Use VARIANT value as TIMESTAMP_TZ Supported Signatures

function as_timestamp_tz(variant) returns timestamp
function as_timestamp_tz(variant, decimal(38, 0)) returns timestamp

🔗 Official Documentation

as_varchar

Use VARIANT value as text sting Supported Signatures

function as_varchar(variant) returns varchar

🔗 Official Documentation

check_json

Checks JSON for errors Supported Signatures

function check_json(varchar) returns varchar

🔗 Official Documentation

check_xml

Checks XML for errors Supported Signatures

function check_xml(varchar) returns varchar
function check_xml(varchar, boolean) returns varchar

🔗 Official Documentation

filter

Supported Signatures

function filter(array, function(variant, boolean)) returns array

🔗 Official Documentation

get

Get VARIANT element value from an array or object Supported Signatures

function get(variant, varchar) returns variant
function get(variant, decimal(38, 0)) returns variant
function get(object, varchar) returns variant
function get(array, decimal(38, 0)) returns variant
function get(object, $1) returns variant

🔗 Official Documentation

get_ignore_case

Get VARIANT element value from an array or object with path name Supported Signatures

function get_ignore_case(variant, varchar) returns variant
function get_ignore_case(object, varchar) returns $1
function get_ignore_case(object, $1) returns $1

🔗 Official Documentation

get_path

Get VARIANT element value from an array or object with path name Supported Signatures

function get_path(variant, varchar) returns variant
function get_path(object, varchar) returns variant
function get_path(array, varchar) returns variant

🔗 Official Documentation

is_array

Returns true if VARIANT value is an array Supported Signatures

function is_array(variant) returns boolean

🔗 Official Documentation

is_binary

Returns true if VARIANT value is a binary string Supported Signatures

function is_binary(variant) returns boolean

🔗 Official Documentation

is_boolean

Returns true if VARIANT value is Boolean Supported Signatures

function is_boolean(variant) returns boolean

🔗 Official Documentation

is_char

Returns true if VARIANT value is a text string Supported Signatures

function is_char(variant) returns boolean

🔗 Official Documentation

is_date

Returns true if VARIANT value is a DATE Supported Signatures

function is_date(variant) returns boolean

🔗 Official Documentation

is_date_value

Returns true if VARIANT value is a DATE Supported Signatures

function is_date_value(variant) returns boolean

🔗 Official Documentation

is_decimal

Returns true if VARIANT value is a decimal fixed-point number Supported Signatures

function is_decimal(variant) returns boolean

🔗 Official Documentation

is_double

Returns true if VARIANT value is a real number Supported Signatures

function is_double(variant) returns boolean

🔗 Official Documentation

is_integer

Returns true if VARIANT value is integer Supported Signatures

function is_integer(variant) returns boolean

🔗 Official Documentation

is_object

Returns true if VARIANT value is an object Supported Signatures

function is_object(variant) returns boolean

🔗 Official Documentation

is_real

Returns true if VARIANT value is a real number Supported Signatures

function is_real(variant) returns boolean

🔗 Official Documentation

is_time

Returns true if VARIANT value is a TIME Supported Signatures

function is_time(variant) returns boolean

🔗 Official Documentation

is_timestamp_ltz

Returns true if VARIANT value is a TIMESTAMP_LTZ Supported Signatures

function is_timestamp_ltz(variant) returns boolean

🔗 Official Documentation

is_timestamp_ntz

Returns true if VARIANT value is a TIMESTAMP_NTZ Supported Signatures

function is_timestamp_ntz(variant) returns boolean

🔗 Official Documentation

is_timestamp_tz

Returns true if VARIANT value is a TIMESTAMP_TZ Supported Signatures

function is_timestamp_tz(variant) returns boolean

🔗 Official Documentation

is_varchar

Returns true if VARIANT value is a text string Supported Signatures

function is_varchar(variant) returns boolean

🔗 Official Documentation

json_extract_path_text

Parses the first argument as a JSON and returns the value of the element pointed to by the second argument Supported Signatures

function json_extract_path_text(varchar, varchar) returns varchar

🔗 Official Documentation

map_cat

Supported Signatures

function map_cat(object, object) returns object

🔗 Official Documentation

map_contains_key

Supported Signatures

function map_contains_key(varchar, object) returns boolean

🔗 Official Documentation

map_delete

Supported Signatures

function map_delete(object, varchar) returns object
function map_delete(object, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar, varchar, varchar) returns object

🔗 Official Documentation

map_insert

Supported Signatures

function map_insert(object, $1, $2) returns object
function map_insert(object, $1, $2, boolean) returns object

🔗 Official Documentation

map_keys

Supported Signatures

function map_keys(object) returns array

🔗 Official Documentation

map_pick

Supported Signatures

function map_pick(object, string) returns object
function map_pick(object, string, string) returns object
function map_pick(object, string, string, string) returns object
function map_pick(object, string, string, string, string) returns object
function map_pick(object, string, string, string, string, string) returns object
function map_pick(object, array) returns object

🔗 Official Documentation

map_size

Supported Signatures

function map_size(object) returns bigint

🔗 Official Documentation

object_construct

Supported Signatures

function object_construct(...) returns object

🔗 Official Documentation

object_construct_keep_null

the resulting object with null value Supported Signatures

function object_construct_keep_null(...) returns object

🔗 Official Documentation

object_delete

the resulting OBJECT Supported Signatures

function object_delete(object, varchar, ...) returns object

🔗 Official Documentation

object_insert

the resulting OBJECT Supported Signatures

function object_insert(object, varchar, $1) returns object
function object_insert(object, varchar, $1, boolean) returns object

🔗 Official Documentation

object_keys

the resulting ARRAY Supported Signatures

function object_keys(object) returns array

🔗 Official Documentation

object_pick

the resulting OBJECT Supported Signatures

function object_pick(object, varchar, ...) returns object
function object_pick(object, array, ...) returns object

🔗 Official Documentation

parse_json

Parses string as a JSON document Supported Signatures

function parse_json(varchar) returns variant

🔗 Official Documentation

parse_xml

Parses string as an XML document Supported Signatures

function parse_xml(varchar) returns object
function parse_xml(varchar, boolean) returns object
function parse_xml() returns variant

🔗 Official Documentation

strip_null_value

Converts null values to SQL NULLs Supported Signatures

function strip_null_value(variant) returns variant

🔗 Official Documentation

transform

Supported Signatures

function transform(array, function(variant, variant)) returns array

🔗 Official Documentation

try_parse_json

Parses string as a JSON document Supported Signatures

function try_parse_json(varchar) returns variant

🔗 Official Documentation

typeof

Returns SQL type word of a variant value Supported Signatures

function typeof(variant) returns varchar

🔗 Official Documentation

xmlget

Get XML element object by XML tag name Supported Signatures

function xmlget(variant, varchar, decimal(38, 0)) returns object
function xmlget(object, varchar, decimal(38, 0)) returns object
function xmlget(variant, varchar) returns object
function xmlget(object, varchar) returns object

🔗 Official Documentation