Semi-Structured and Structured Data Functions
array_append
the resulting array Supported Signatures
function array_append(array, $1) returns array
function array_append(array, $1) returns array
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
function array_cat(array, array) returns array
array_compact
Compact array by removing nulls Supported Signatures
function array_compact(array) returns array
function array_compact(variant) returns array
function array_compact(array) returns array
array_construct
the resulting array Supported Signatures
function array_construct($1, ...) returns array
function array_construct($1, $2) returns array
function array_construct($1, $2, $3) returns array
function array_construct($1, $2, $3, $4) returns array
function array_construct($1, $2, $3, $4, $5) returns array
array_construct_compact
the resulting array Supported Signatures
function array_construct_compact($1, ...) returns array
array_contains
Returns true if array contains value Supported Signatures
function array_contains(variant, array) returns boolean
function array_contains($1, array) returns boolean
array_distinct
the resulting array Supported Signatures
function array_distinct(array) returns array
function array_distinct(array) returns array
array_except
the resulting array Supported Signatures
function array_except(array, array) returns array
function array_except(array, array) returns array
array_flatten
the resulting array Supported Signatures
function array_flatten(array) returns array
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
array_insert
the resulting array Supported Signatures
function array_insert(array, decimal(38, 0), $1) returns array
function array_insert(array, decimal(38, 0), $1) returns array
array_intersection
the resulting array Supported Signatures
function array_intersection(array, array) returns array
function array_intersection(array, array) returns array
array_max
the maximum defined element in the array, or NULL Supported Signatures
function array_max(array) returns variant
function array_max(array) returns $1
array_min
the minimum defined element in the array, or NULL Supported Signatures
function array_min(array) returns variant
function array_min(array) returns $1
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)
array_prepend
the resulting array Supported Signatures
function array_prepend(array, $1) returns array
function array_prepend(array, $1) returns array
array_remove
the resulting array Supported Signatures
function array_remove(array, variant) returns array
function array_remove(array, $1) returns array
array_remove_at
the resulting array Supported Signatures
function array_remove_at(array, decimal(38, 0)) returns array
function array_remove_at(array, decimal(38, 0)) returns array
array_size
Returns array size Supported Signatures
function array_size(array) returns decimal(38, 0)
function array_size(array) returns decimal(38, 0)
function array_size(variant) returns decimal(38, 0)
array_slice
the resulting array Supported Signatures
function array_slice(array, decimal(38, 0), decimal(38, 0)) returns array
function array_slice(array, decimal(38, 0), decimal(38, 0)) returns array
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
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
arrays_overlap
Returns true if two arrays have elements in common Supported Signatures
function arrays_overlap(array, array) returns boolean
function arrays_overlap(array, array) returns boolean
arrays_to_object
the resulting object Supported Signatures
function arrays_to_object(array, array) returns object
as_array
Use VARIANT value as ARRAY Supported Signatures
function as_array(variant) returns array
as_binary
Use VARIANT value as binary string Supported Signatures
function as_binary(variant) returns binary
as_boolean
Use VARIANT value as Boolean Supported Signatures
function as_boolean(variant) returns boolean
as_char
Use VARIANT value as text string Supported Signatures
function as_char(variant) returns varchar
as_date
Use VARIANT value as DATE Supported Signatures
function as_date(variant) returns date
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)
as_double
Use VARIANT value as real Supported Signatures
function as_double(variant) returns double
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)
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)
as_object
Use VARIANT value as OBJECT Supported Signatures
function as_object(variant) returns object
as_real
Use VARIANT value as real Supported Signatures
function as_real(variant) returns double
as_time
Use VARIANT value as TIME Supported Signatures
function as_time(variant) returns time
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
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
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
as_varchar
Use VARIANT value as text sting Supported Signatures
function as_varchar(variant) returns varchar
check_json
Checks JSON for errors Supported Signatures
function check_json(varchar) returns varchar
check_xml
Checks XML for errors Supported Signatures
function check_xml(varchar) returns varchar
function check_xml(varchar, boolean) returns varchar
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
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(variant, varchar) returns object
function get_ignore_case(object, varchar) returns $1
function get_ignore_case(object, $1) returns $1
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
function get_path(array, varchar) returns $1
function get_path(object, varchar) returns $1
function get_path(object, varchar) returns $1
is_array
Returns true if VARIANT value is an array Supported Signatures
function is_array(variant) returns boolean
is_binary
Returns true if VARIANT value is a binary string Supported Signatures
function is_binary(variant) returns boolean
is_boolean
Returns true if VARIANT value is Boolean Supported Signatures
function is_boolean(variant) returns boolean
is_char
Returns true if VARIANT value is a text string Supported Signatures
function is_char(variant) returns boolean
is_date
Returns true if VARIANT value is a DATE Supported Signatures
function is_date(variant) returns boolean
is_date_value
Returns true if VARIANT value is a DATE Supported Signatures
function is_date_value(variant) returns boolean
is_decimal
Returns true if VARIANT value is a decimal fixed-point number Supported Signatures
function is_decimal(variant) returns boolean
is_double
Returns true if VARIANT value is a real number Supported Signatures
function is_double(variant) returns boolean
is_integer
Returns true if VARIANT value is integer Supported Signatures
function is_integer(variant) returns boolean
is_object
Returns true if VARIANT value is an object Supported Signatures
function is_object(variant) returns boolean
is_real
Returns true if VARIANT value is a real number Supported Signatures
function is_real(variant) returns boolean
is_time
Returns true if VARIANT value is a TIME Supported Signatures
function is_time(variant) returns boolean
is_timestamp_ltz
Returns true if VARIANT value is a TIMESTAMP_LTZ Supported Signatures
function is_timestamp_ltz(variant) returns boolean
is_timestamp_ntz
Returns true if VARIANT value is a TIMESTAMP_NTZ Supported Signatures
function is_timestamp_ntz(variant) returns boolean
is_timestamp_tz
Returns true if VARIANT value is a TIMESTAMP_TZ Supported Signatures
function is_timestamp_tz(variant) returns boolean
is_varchar
Returns true if VARIANT value is a text string Supported Signatures
function is_varchar(variant) returns boolean
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
map_cat
Supported Signatures
function map_cat(object, object) returns object
map_contains_key
Supported Signatures
function map_contains_key(varchar, object) returns boolean
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
map_insert
Supported Signatures
function map_insert(object, $1, $2) returns object
function map_insert(object, $1, $2, boolean) returns object
map_keys
Supported Signatures
function map_keys(object) returns array
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
map_size
Supported Signatures
function map_size(object) returns bigint
object_construct
Supported Signatures
function object_construct(...) returns object
object_construct_keep_null
the resulting object with null value Supported Signatures
function object_construct_keep_null($1, ...) returns object
object_delete
the resulting OBJECT Supported Signatures
function object_delete(object, varchar, ...) returns object
function object_delete(object, varchar, ...) returns object
object_insert
the resulting OBJECT Supported Signatures
function object_insert(object, varchar, $1) returns object
function object_insert(object, varchar, $1, boolean) returns object
function object_insert(object, varchar, $1) returns object
function object_insert(object, varchar, $1, boolean) returns object
object_keys
the resulting ARRAY Supported Signatures
function object_keys(object) returns array
function object_keys(object) returns array
object_pick
the resulting OBJECT Supported Signatures
function object_pick(object, varchar, ...) returns object
function object_pick(object, array, ...) returns object
function object_pick(object, varchar, ...) returns object
parse_json
Parses string as a JSON document Supported Signatures
function parse_json(varchar) returns variant
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
strip_null_value
Converts null values to SQL NULLs Supported Signatures
function strip_null_value(variant) returns variant
try_parse_json
Parses string as a JSON document Supported Signatures
function try_parse_json(varchar) returns variant
typeof
Returns SQL type word of a variant value Supported Signatures
function typeof(variant) returns varchar
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