Semi-Structured and Structured Data Functions

function array_append(array, $1) returns array

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_compact(array) returns array
function array_compact(variant) returns array

function array_construct(...) returns array

function array_construct_compact(...) returns array

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

function array_distinct(array) returns array

function array_except(array, array) returns array

function array_flatten(array) returns array

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

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

function array_intersection(array, array) returns array

function array_max(array) returns variant

function array_min(array) returns variant

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

function array_prepend(array, $1) returns array

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

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

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

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

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

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

function arrays_overlap(array, array) returns boolean

function arrays_to_object(array, array) returns object

function as_array(variant) returns array

function as_binary(variant) returns binary

function as_boolean(variant) returns boolean

function as_char(variant) returns varchar

function as_date(variant) returns date

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)

function as_double(variant) returns double

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

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)

function as_object(variant) returns object

function as_real(variant) returns double

function as_time(variant) returns time

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

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

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

function as_varchar(variant) returns varchar

function check_json(varchar) returns varchar

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

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

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

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

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

function is_array(variant) returns boolean

function is_binary(variant) returns boolean

function is_boolean(variant) returns boolean

function is_char(variant) returns boolean

function is_date(variant) returns boolean

function is_date_value(variant) returns boolean

function is_decimal(variant) returns boolean

function is_double(variant) returns boolean

function is_integer(variant) returns boolean

function is_object(variant) returns boolean

function is_real(variant) returns boolean

function is_time(variant) returns boolean

function is_timestamp_ltz(variant) returns boolean

function is_timestamp_ntz(variant) returns boolean

function is_timestamp_tz(variant) returns boolean

function is_varchar(variant) returns boolean

function json_extract_path_text(varchar, varchar) returns varchar

function map_cat(object, object) returns object

function map_contains_key(varchar, object) returns boolean

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

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

function map_keys(object) returns array

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

function map_size(object) returns bigint

function object_construct(...) returns object

function object_construct_keep_null(...) returns object

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

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

function object_keys(object) returns array

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

function parse_json(varchar) returns variant

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

function strip_null_value(variant) returns variant

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

function try_parse_json(varchar) returns variant

function typeof(variant) returns varchar

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