sql-functions 0.1.3

---
function:
  name: abs
  description: returns absolute value of x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: abs
  description: returns absolute value of x
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: acos
  description: Compute the arccosine of the input expression (returned as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: acosh
  description: Compute the inverse hyperbolic cosine of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: any_value
  description: Returns the first non-null value of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: approximate_count_distinct
  description: approximate distinct row count
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: approximate_jaccard_index
  description: Similarity approximation of inputs
  kind: aggregate
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: approximate_similarity
  description: Similarity approximation of inputs
  kind: aggregate
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: approx_count_distinct
  description: approximate distinct row count
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: approx_percentile
  description: percentile approximation of inputs
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: approx_percentile_accumulate
  description: tdigest state in JSON format
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: approx_percentile_combine
  description: A tdigest state in JSON format
  kind: aggregate
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: approx_percentile_estimate
  description: ESTIMATED PERCENTILE VALUE
  parameters:
  - datatype: object
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: approx_top_k
  description: Array containing top k items and their frequencies
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: approx_top_k
  description: Array containing top k items and their frequencies
  kind: aggregate
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: approx_top_k
  description: Array containing top k items and their frequencies
  kind: aggregate
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: approx_top_k_accumulate
  description: An internal state
  kind: aggregate
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: approx_top_k_combine
  description: A state created by combining information from combining  all input
  kind: aggregate
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: approx_top_k_combine
  description: A state created by combining information from combining  all input
  kind: aggregate
  parameters:
  - datatype: object
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: approx_top_k_estimate
  description: Array containing most common k items and their frequencies
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: approx_top_k_estimate
  description: Array containing most common k items and their frequencies
  parameters:
  - datatype: object
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: arrayagg
  description: output array
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: arrays_overlap
  description: Returns true if two arrays have elements in common
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: arrays_overlap
  description: Returns true if two arrays have elements in common
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: arrays_to_object
  description: the resulting object
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: array_agg
  description: output array
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_append
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_append
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_cat
  description: Concatenate two arrays
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_cat
  description: Concatenate two arrays
  parameters:
  - datatype: variant
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_cat
  description: Concatenate two arrays
  parameters:
  - datatype: array
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_cat
  description: Concatenate two arrays
  parameters:
  - datatype: variant
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_cat
  description: Concatenate two arrays
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_compact
  description: Compact array by removing nulls
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_compact
  description: Compact array by removing nulls
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_compact
  description: Compact array by removing nulls
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_construct
  description: the resulting array
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_construct_compact
  description: the resulting array
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_contains
  description: Returns true if array contains value
  parameters:
  - datatype: variant
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: array_contains
  description: Returns true if array contains value
  parameters:
  - datatype: $1
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: array_distinct
  description: the resulting array
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_distinct
  description: the resulting array
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_except
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_except
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_flatten
  description: the resulting array
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_generate_range
  description: the resulting array
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_generate_range
  description: the resulting array
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_insert
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_insert
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_intersection
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_intersection
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_max
  description: the maximum defined element in the array, or NULL
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: array_max
  description: the maximum defined element in the array, or NULL
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: array_min
  description: the minimum defined element in the array, or NULL
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: array_min
  description: the minimum defined element in the array, or NULL
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: array_position
  description: Returns the first index position of the element in the array
  parameters:
  - datatype: variant
  - datatype: array
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: array_position
  description: Returns the first index position of the element in the array
  parameters:
  - datatype: $1
  - datatype: array
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: array_prepend
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_prepend
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_remove
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_remove
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_remove_at
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_remove_at
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_size
  description: Returns array size
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: array_size
  description: Returns array size
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: array_size
  description: Returns array size
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: array_slice
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_slice
  description: the resulting array
  parameters:
  - datatype: array
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_sort
  description: the sorted array
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_sort
  description: the sorted array
  parameters:
  - datatype: array
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_sort
  description: the sorted array
  parameters:
  - datatype: array
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_to_string
  description: Convert array to a string
  parameters:
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: array_to_string
  description: Convert array to a string
  parameters:
  - datatype: variant
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: array_union_agg
  description: output array
  kind: aggregate
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_union_agg
  description: output array
  kind: aggregate
  parameters:
  - datatype: array
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: array_unique_agg
  description: output array
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: ascii
  description: Returns the ascii code of the first character of the string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: asin
  description: Compute the arcsine of the input expression (returned as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: asinh
  description: Compute the inverse hyperbolic sine of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: as_array
  description: Use VARIANT value as ARRAY
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: as_binary
  description: Use VARIANT value as binary string
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: as_boolean
  description: Use VARIANT value as Boolean
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: as_char
  description: Use VARIANT value as text string
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: as_date
  description: Use VARIANT value as DATE
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: as_decimal
  description: Use VARIANT value as decimal fixed-point
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_decimal
  description: Use VARIANT value as decimal fixed-point
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_decimal
  description: Use VARIANT value as decimal fixed-point
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_double
  description: Use VARIANT value as real
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: as_integer
  description: Use VARIANT value as integer
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_integer
  description: Use VARIANT value as integer
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_number
  description: Use VARIANT value as as decimal fixed-point
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_number
  description: Use VARIANT value as as decimal fixed-point
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_number
  description: Use VARIANT value as as decimal fixed-point
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: as_object
  description: Use VARIANT value as OBJECT
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: as_real
  description: Use VARIANT value as real
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: as_time
  description: Use VARIANT value as TIME
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: as_timestamp_ltz
  description: Use VARIANT value as TIMESTAMP_LTZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_timestamp_ltz
  description: Use VARIANT value as TIMESTAMP_LTZ
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_timestamp_ntz
  description: Use VARIANT value as TIMESTAMP_NTZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_timestamp_ntz
  description: Use VARIANT value as TIMESTAMP_NTZ
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_timestamp_tz
  description: Use VARIANT value as TIMESTAMP_TZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_timestamp_tz
  description: Use VARIANT value as TIMESTAMP_TZ
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: as_varchar
  description: Use VARIANT value as text sting
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: atan
  description: Compute the arctangent of the input expression (returned as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: atan2
  description: Compute the angle (in radians) between the x-axis and point (x, y).
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: atanh
  description: Compute the inverse hyperbolic tangent of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: avg
  description: Returns the average of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: avg
  description: Returns the average of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: base64_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: base64_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: base64_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: base64_encode
  description: return encoded string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: binary_as_string
  description: Returns the input interpreted as a string.
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: bitand
  description: returns result of bitwise AND of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitandagg
  description: Returns the bitwise AND of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitand_agg
  description: Returns the bitwise AND of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitcount
  description: returns the number of bits set in integer x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitmap_bit_position
  description: relative position in bitmap
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitmap_bucket_number
  description: bucket index of the destination bitmap
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitmap_construct_agg
  description: bitmap
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: bitmap_count
  description: number of set bits in the bitmap
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitmap_or_agg
  description: destination bitmap
  kind: aggregate
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: bitnot
  description: returns result of bitwise negation of integer x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitor
  description: returns result of bitwise OR of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitoragg
  description: Returns the bitwise OR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitor_agg
  description: Returns the bitwise OR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitshiftleft
  description: returns result of arg1 bit-shifted left by arg2 bits
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitshiftright
  description: returns result of arg1 bit-shifted right by arg2 bits
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitxor
  description: returns result of bitwise XOR of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitxoragg
  description: Returns the bitwise XOR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bitxor_agg
  description: Returns the bitwise XOR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_and
  description: returns result of bitwise AND of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_andagg
  description: Returns the bitwise AND of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_and_agg
  description: Returns the bitwise AND of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_length
  description: Returns the length of the object in bits
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_length
  description: Returns the length of the object in bits
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_not
  description: returns result of bitwise negation of integer x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_or
  description: returns result of bitwise OR of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_oragg
  description: Returns the bitwise OR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_or_agg
  description: Returns the bitwise OR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_shiftleft
  description: returns result of arg1 bit-shifted left by arg2 bits
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_shiftright
  description: returns result of arg1 bit-shifted right by arg2 bits
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_xor
  description: returns result of bitwise XOR of integers x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_xoragg
  description: Returns the bitwise XOR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: bit_xor_agg
  description: Returns the bitwise XOR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: booland
  description: returns result of logical (Boolean) AND of x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: booland_agg
  description: Returns the logical (boolean) AND of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: boolnot
  description: returns result of logical (Boolean) NOT of x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: boolor
  description: returns result of logical (Boolean) OR of x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: boolor_agg
  description: Returns the logical (boolean) OR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: boolxor
  description: returns result of logical (Boolean) XOR of x and y
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: boolxor_agg
  description: Returns the logical (boolean) XOR of a column. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: cbrt
  description: Compute the cubic root of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: ceil
  description: round to the nearest integer not smaller than input
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: ceil
  description: round to the nearest integer not smaller than input
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: ceil
  description: round to the nearest integer not smaller than input
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: ceil
  description: round to the nearest integer not smaller than input
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: char
  description: Convert an ASCII or Unicode code into a single character
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: charindex
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: charindex
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: charindex
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: charindex
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: check_json
  description: Checks JSON for errors
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: check_xml
  description: Checks XML for errors
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: check_xml
  description: Checks XML for errors
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: chr
  description: Convert an ASCII or Unicode code into a single character
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: coalesce
  description: returns the first non-null expression among its arguments
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: compress
  description: compressed data (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: compress
  description: compressed data (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: concat
  description: Returns concatenation of the input strings, or null if any one of them is null.
  variadic: uniform
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: concat
  description: Returns concatenation of the input strings, or null if any one of them is null.
  variadic: uniform
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: concat_ws
  description: Returns concatenation of the input strings with separator, or null if any one of them is null.
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: concat_ws
  description: Returns concatenation of the input strings with separator, or null if any one of them is null.
  variadic: uniform
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: conditional_change_event
  description: 'Returns the event window number of this row in the window based on whether the argument expression on the current row differs from that on the previous row '
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: conditional_true_event
  description: 'Returns the event window number of this row in the window based on the result of the boolean argument expression '
  parameters:
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: contains
  description: returns TRUE if arg1 constains arg2
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: contains
  description: returns TRUE if arg1 constains arg2
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: corr
  description: Returns the correlation coefficient for non-null pairs in a group.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: cos
  description: Compute the cosine of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: cosh
  description: Compute the hyperbolic cosine of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: cot
  description: Compute the cotangent of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: count
  description: Return number of non-null values of a given expression
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: count_if
  description: Returns a conditional count
  kind: aggregate
  parameters:
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: count_if
  description: Returns a conditional count
  kind: aggregate
  parameters:
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: count_internal
  description: Return number of non-null values of a given expression
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: covar_pop
  description: Returns the population covariance for non-null pairs in a group.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: covar_samp
  description: Returns the sample covariance for non-null pairs in a group.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: cume_dist
  description: Returns the cumulative distribution of a row in the window
  parameters: []
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: current_client
  description: Returns the current client version.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_database
  description: Returns the current database.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_date
  description: Returns the current date.
  parameters: []
  optional-parameters: []
  returns:
    datatype: date
  special: true
---
function:
  name: current_ip_address
  description: Returns the Client Internet Protocol address (IP address) of the current request.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_organization_name
  description: Returns the name of the organization the current account belongs to.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_region
  description: Returns the current region name.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_role
  description: Returns the currently active role name.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_role_type
  description: Returns if the current role is of type account or database
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_schema
  description: Returns the current schema.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_schemas
  description: Returns active search path schemas
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_secondary_roles
  description: Returns the currently active secondary roles' names.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_session
  description: Returns the current session.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_statement
  description: Returns the text of the currently executing statement.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_time
  description: Returns the current time.
  parameters: []
  optional-parameters: []
  returns:
    datatype: time
  special: true
---
function:
  name: current_time
  description: Returns the current time.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
  special: true
---
function:
  name: current_timestamp
  description: Returns the current timestamp.
  parameters: []
  optional-parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: current_timestamp
  description: Returns the current timestamp.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: current_transaction
  description: Returns the transaction id of an open transaction in the current session or scope.
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: current_user
  description: Returns the current user name.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
  special: true
---
function:
  name: current_version
  description: Returns the current software version (major.minor.patch).
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: current_warehouse
  description: Returns the warehouse currently in use.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: date
  description: Converts the timestamp argument to a date
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: date
  description: Converts the timestamp argument to a date
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: date
  description: Converts the timestamp argument to a date
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: date
  description: Converts the string argument to a date
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: date
  description: Converts the string argument to a date according to a format argument
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: datefromparts
  description: Construct a date from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: date_from_parts
  description: Construct a date from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: decode
  description: compare an expression to search values and returns the matching one
  variadic: uniform
  parameters:
  - datatype: $1
  - datatype: $1
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: decompress_binary
  description: decompressed binary (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decompress_string
  description: decompressed string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: degrees
  description: convert r (radians) to degrees.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: dense_rank
  description: Returns the dense rank of a row in the window
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: div
  description: Divides two numbers
  variadic: uniform
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: div
  description: Divides two numbers
  variadic: uniform
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: div0
  description: Divides two numbers; returns 0 if divisor is 0
  variadic: uniform
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: div0
  description: Divides two numbers; returns 0 if divisor is 0
  variadic: uniform
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: div0null
  description: Divides two numbers; returns 0 if divisor is 0 or null
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: div0null
  description: Divides two numbers; returns 0 if divisor is 0 or null
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: editdistance
  description: Returns the Levenshtein edit distance between two strings.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: editdistance
  description: Returns the Levenshtein edit distance between two strings.
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt
  description: encrypted binary string including IV/nonce and AEAD tag (return)
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: encrypt_raw
  description: variant containing the encrypted binary string and additional data (return)
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: encrypt_raw
  description: variant containing the encrypted binary string and additional data (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: encrypt_raw
  description: variant containing the encrypted binary string and additional data (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: encrypt_raw
  description: variant containing the encrypted binary string and additional data (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: endswith
  description: returns TRUE if arg1 ends with arg2
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: endswith
  description: returns TRUE if arg1 ends with arg2
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: equal_null
  description: Checks if two values are equal, with NULL=NULL semantic
  parameters:
  - datatype: $1
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: equal_null
  description: Checks if two values are equal, with NULL=NULL semantic
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: exp
  description: returns e raised to the x'th power
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: factorial
  description: Factorial of f
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: first_value
  description: Returns the first value of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: floor
  description: round to the nearest integer not greater than input
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: floor
  description: round to the nearest integer not greater than input
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: floor
  description: round to the nearest integer not greater than input
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: floor
  description: round to the nearest integer not greater than input
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: generate_column_description
  description: parse the result from INFER_SCHEMA and generate a copy-able column description
  parameters:
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: getbit
  description: returns result of the bit of base in specific bit index
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: getdate
  description: Returns the current timestamp
  parameters: []
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: get_ddl
  description: DDL used to create the object
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: get_ddl
  description: DDL used to create the object
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: get_ddl
  description: DDL used to create the object
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: get_ddl
  description: DDL used to create the object
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: get_ignore_case
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: variant
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: get_ignore_case
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: variant
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: get_ignore_case
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: get_ignore_case
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: object
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: variant
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: get_path
  description: Get VARIANT element value from an array or object with path name
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: get_query_stats
  description: Returns query stats
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: get_query_stats
  description: Returns query stats
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: greatest
  description: returns the largest value from a list of expressions
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: greatest_ignore_nulls
  description: returns the largest value from a list of expressions
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: grouping_id
  description: Returns grouping bit-vector
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_cell_to_boundary
  description: Returns a polygon containing the h3 integer cell boundaries
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: h3_cell_to_boundary
  description: Returns a polygon containing the h3 string cell boundaries
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: h3_cell_to_children
  description: Returns the H3 children cells as integers for a given H3 index
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_cell_to_children_string
  description: Returns the H3 children cells as strings for a given H3 index
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_cell_to_parent
  description: Returns the H3 parent cell as an integer for a given H3 index
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_cell_to_parent
  description: Returns the H3 parent cell as a string for a given H3 index
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: h3_cell_to_point
  description: Returns a point (geography) corresponding to the center of the h3 integer cell passed
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: h3_cell_to_point
  description: Returns a point (geography) corresponding to the center of the h3 string cell passed
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: h3_coverage
  description: Returns the full spherical based covering of H3 cells as integers for any geography type
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_coverage_strings
  description: Returns the full spherical based covering of H3 cells as strings for any geography type
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_get_resolution
  description: Returns the cell resolution for a given H3 integer cell
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_get_resolution
  description: Returns the cell resolution for a given H3 string cell
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_grid_disk
  description: Returns all H3 cells that are at most k steps away from the input cell
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_grid_disk
  description: Returns all H3 cells that are at most k steps away from the input cell
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_grid_distance
  description: Returns the number of H3 cells that are betweem two input cells
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_grid_distance
  description: Returns the number of H3 cells that are betweem two input cells
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_grid_path
  description: Returns all H3 cells that are along the straight line connecting both cells
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_grid_path
  description: Returns all H3 cells that are along the straight line connecting both cells
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_int_to_string
  description: Returns the H3 cell formatted as a string given its integer representation
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: h3_latlng_to_cell
  description: Returns an H3 index as an integer that corresponds to a given point (lat/lng) and resolution
  parameters:
  - datatype: double
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_latlng_to_cell_string
  description: Returns an H3 index as a string that corresponds to a given point (lat/lng) and resolution
  parameters:
  - datatype: double
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: h3_point_to_cell
  description: Returns an H3 integer cell that corresponds to a given point (geography) and resolution
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: h3_point_to_cell_string
  description: Returns an H3 string cell that corresponds to a given point (geography) and resolution
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: h3_polygon_to_cells
  description: Returns the planar centroid based covering of H3 cells as integers for a polygon/multipolygon
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_polygon_to_cells_strings
  description: Returns the planar centroid based covering of H3 cells as strings for a polygon/multipolygon
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: h3_string_to_int
  description: Returns the H3 cell formatted as an integer given its string representation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: hash
  description: hash value
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: hash_agg
  description: aggregate hash value
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: haversine
  description: Calculate great circle distance (in km) from two (lat, lon) locations (degrees).
  parameters:
  - datatype: double
  - datatype: double
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: hex_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: hex_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: hex_encode
  description: return encoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: hex_encode
  description: return encoded string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: hex_encode
  description: return encoded string
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: hex_encode
  description: return encoded string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: hll
  description: approximate distinct row count
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: hll_accumulate
  description: HyperLogLog state
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: hll_combine
  description: combined HyperLogLog state
  kind: aggregate
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: hll_estimate
  description: approximate distinct row count
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: hll_export
  description: HyperLogLog state as a compound OBJECT
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: hll_import
  description: HyperLogLog state in binary format
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: ilike
  description: returns TRUE if subject ILIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: ilike
  description: returns TRUE if subject ILIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: ilike_any
  description: returns TRUE if subject ILIKE any of the patterns
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: initcap
  description: return string with all the initial letter of each word is LOWERcase.
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: initcap
  description: return string with all the initial letter of each word is LOWERcase.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: insert
  description: Returns the first string with a substring at the given position and length replaced with the second string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: invoker_role
  description: Returns the invoker role
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: invoker_share
  description: Returns the invoker role
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: is_application_role_in_session
  description: Returns true if the specified application role is in the current role hierarchy
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_array
  description: Returns true if VARIANT value is an array
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_binary
  description: Returns true if VARIANT value is a binary string
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_boolean
  description: Returns true if VARIANT value is Boolean
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_char
  description: Returns true if VARIANT value is a text string
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_database_role_in_session
  description: Return true if the db role is in current role hierarchy
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_date
  description: Returns true if VARIANT value is a DATE
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_date_value
  description: Returns true if VARIANT value is a DATE
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_decimal
  description: Returns true if VARIANT value is a decimal fixed-point number
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_double
  description: Returns true if VARIANT value is a real number
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_granted_to_invoker_role
  description: Returns true if the arg is in invoker_role's hierarchy
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_integer
  description: Returns true if VARIANT value is integer
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_null_value
  description: Returns true if VARIANT value is null
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_object
  description: Returns true if VARIANT value is an object
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_real
  description: Returns true if VARIANT value is a real number
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_role_in_session
  description: Return true if in current hierarchy
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_time
  description: Returns true if VARIANT value is a TIME
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_timestamp_ltz
  description: Returns true if VARIANT value is a TIMESTAMP_LTZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_timestamp_ntz
  description: Returns true if VARIANT value is a TIMESTAMP_NTZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_timestamp_tz
  description: Returns true if VARIANT value is a TIMESTAMP_TZ
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: is_varchar
  description: Returns true if VARIANT value is a text string
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: jarowinkler_similarity
  description: Returns the Jaro-Winkler similarity metric between two strings.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: json_extract_path_text
  description: Parses the first argument as a JSON and returns the value of the element pointed to by the second argument
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: kurtosis
  description: Returns the sample kurtosis of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: kurtosis
  description: Returns the sample kurtosis of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: lag
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: lag
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: lag
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: last_query_id
  description: Returns the id of the last executed statement in the current session.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: last_query_id
  description: Returns the id of the last executed statement in the current session.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: last_transaction
  description: Returns the transaction id of the last committed or rolled back transaction in the current session.
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: last_value
  description: Returns the last value of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: lead
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: lead
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: lead
  description: Returns the value of an expression at the specified offset row
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: least
  description: returns the smallest value from a list of expressions
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: least_ignore_nulls
  description: returns the smallest value from a list of expressions
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: left
  description: Returns leftmost N characters of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: len
  description: Returns length of string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: len
  description: Returns length of binary input
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: length
  description: Returns the length of the string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: length
  description: Returns the length of the string
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: like
  description: returns TRUE if subject LIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: like
  description: returns TRUE if subject LIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: like
  description: returns TRUE if subject LIKE pattern
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: like
  description: returns TRUE if subject LIKE pattern
  parameters:
  - datatype: array
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: like_all
  description: returns TRUE if subject LIKE all of the patterns
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: like_any
  description: returns TRUE if subject LIKE any of the patterns
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: listagg
  description: output string
  kind: aggregate
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: listagg
  description: output string
  kind: aggregate
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: ln
  description: returns the natural logarithm of a
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: localtime
  description: Returns the current time.
  parameters: []
  optional-parameters: []
  returns:
    datatype: time
  special: true
---
function:
  name: localtime
  description: Returns the current time.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
  special: true
---
function:
  name: localtimestamp
  description: Returns the current timestamp.
  parameters: []
  optional-parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: localtimestamp
  description: Returns the current timestamp.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: log
  description: returns the logarithm base b of a
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: lower
  description: return string with all characters in lowercase
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: lpad
  description: padded result string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: lpad
  description: padded result string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: lpad
  description: padded result string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: ltrim
  description: return string trimmed from left
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: ltrim
  description: return string trimmed from left
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: max
  description: Returns the maximum of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: md5
  description: Hex-encoded MD5 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: md5
  description: Hex-encoded MD5 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: md5_binary
  description: Binary MD5 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: md5_binary
  description: Binary MD5 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: md5_hex
  description: Hex-encoded MD5 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: md5_hex
  description: Hex-encoded MD5 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: md5_number
  description: Integral MD5 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: md5_number
  description: Integral MD5 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: median
  description: value of sort key at specified percentile
  kind: aggregate
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: median
  description: value of sort key at specified percentile
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: min
  description: Returns the minimum of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: minhash
  description: Minhash state including an array of k (first input arg) minimum hash values
  variadic: uniform
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: minhash_combine
  description: Combined result of two (or more) minhash states
  kind: aggregate
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: mod
  description: Computes modulo of two numbers
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: mod
  description: Computes modulo of two numbers
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: mode
  description: Returns the most frequent item of a column
  kind: aggregate
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: negate
  description: returns the negative value of its input argument.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: negate
  description: returns the negative value of its input argument.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normal
  description: Returns a normal distribution
  parameters:
  - datatype: double
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: double
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: time
  - datatype: time
  - datatype: time
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: timestamp
  - datatype: timestamp
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: normalize
  description: normalized value
  parameters:
  - datatype: date
  - datatype: date
  - datatype: date
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: not
  description: returns TRUE if input is FALSE, FALSE otherwise
  parameters:
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: nth_value
  description: Returns the first value of a column
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: ntile
  description: Number of groups (ntiles) per window
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: nullifzero
  description: Returns the 1st input, with values equal to 0 replaced with NULL
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: nullifzero
  description: Returns the 1st input, with values equal to 0 replaced with NULL
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: nvl
  description: Returns second expression if the first expression is NULL, the first expression otherwise.
  parameters:
  - datatype: $1
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: nvl2
  description: Returns second expression if the first expression is NOT NULL. Returns the third expression otherwise.
  parameters:
  - datatype: $1
  - datatype: $1
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: $1
---
function:
  name: objectagg
  description: output object
  kind: aggregate
  parameters:
  - datatype: varchar
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_agg
  description: output object
  kind: aggregate
  parameters:
  - datatype: varchar
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_construct_keep_null
  description: the resulting object with null value
  variadic: uniform
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_delete
  description: the resulting OBJECT
  variadic: uniform
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_delete
  description: the resulting OBJECT
  variadic: uniform
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_insert
  description: the resulting OBJECT
  parameters:
  - datatype: object
  - datatype: varchar
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_insert
  description: the resulting OBJECT
  parameters:
  - datatype: object
  - datatype: varchar
  - datatype: $1
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_insert
  description: the resulting OBJECT
  parameters:
  - datatype: object
  - datatype: varchar
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_insert
  description: the resulting OBJECT
  parameters:
  - datatype: object
  - datatype: varchar
  - datatype: $1
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_keys
  description: the resulting ARRAY
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: object_keys
  description: the resulting ARRAY
  parameters:
  - datatype: object
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: object_pick
  description: the resulting OBJECT
  variadic: uniform
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_pick
  description: the resulting OBJECT
  variadic: uniform
  parameters:
  - datatype: object
  - datatype: array
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: object_pick
  description: the resulting OBJECT
  variadic: uniform
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: octet_length
  description: Returns the length of the string in bytes
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: octet_length
  description: Returns the length of the string in bytes
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: parse_ip
  description: Returns an object with all the components of the IP
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: parse_ip
  description: Returns an object with all the components of the IP
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: parse_json
  description: Parses string as a JSON document
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: parse_url
  description: Returns an object with all the components of the URL
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: parse_url
  description: Returns an object with all the components of the URL
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: parse_xml
  description: Parses string as an XML document
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: parse_xml
  description: Parses string as an XML document
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: percentile_cont
  description: value of sort key at specified percentile
  kind: aggregate
  parameters: []
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: percentile_cont
  description: value of sort key at specified percentile
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: percentile_disc
  description: value of sort key at specified percentile
  kind: aggregate
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: percentile_disc
  description: value of sort key at specified percentile
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: percent_rank
  description: Returns the percent rank of a row in the window
  parameters: []
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: pi
  description: Returns the constant pi.
  parameters: []
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: position
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: position
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: position
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: position
  description: Returns the position of the needle in the haystack, optionally from a given index
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: pow
  description: returns x raised to the y'th power
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: power
  description: returns x raised to the y'th power
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: projection_constraint
  description: Returns the projection constraint
  parameters:
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: radians
  description: convert d (degrees) to radians.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: random
  description: returns a random number sequence
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: random
  description: returns a random number sequence
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: randstr
  description: Returns a random string of alphanumeric characters
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rank
  description: Returns the rank of a row in the window
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: ratio_to_report
  description: Returns a cumulative ratio_to_report of a column
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: ratio_to_report
  description: Returns a cumulative ratio_to_report of a column
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: ratio_to_report
  description: Returns a cumulative ratio_to_report of a column
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: ratio_to_report
  description: Returns a cumulative ratio_to_report of a column
  parameters:
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regexp
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: regexp
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: regexp_count
  description: returns number of matches of regular expression pattern in subject
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_count
  description: returns number of matches of regular expression pattern in subject
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_count
  description: returns number of matches of regular expression pattern in subject
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_extract_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_extract_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_extract_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_extract_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_extract_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_instr
  description: returns position at which the subject matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: regexp_like
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: regexp_like
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: regexp_replace
  description: replaces substring in subject matching a regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_replace
  description: replaces substring in subject matching a regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_replace
  description: replaces substring in subject matching a regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_replace
  description: replaces substring in subject matching a regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_replace
  description: replaces substring in subject matching a regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr
  description: returns substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr
  description: returns substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr
  description: returns substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr
  description: returns substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr
  description: returns substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: regexp_substr_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_substr_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_substr_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_substr_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regexp_substr_all
  description: returns all substring in subject which matches the regular expression pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: regr_avgx
  description: Returns the average of the independent variable (2nd parameter) for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_avgy
  description: Returns the average of the dependent variable (1st parameter) for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_count
  description: Returns the number of non-null number pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_intercept
  description: Returns the intercept of the univariate linear regression line for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_r2
  description: Returns the coefficient of determination for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_slope
  description: Returns the slope of the linear regression line for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_sxx
  description: Returns REGR_COUNT(expr1, expr2) * VAR_POP(expr2) for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_sxy
  description: Returns REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_syy
  description: Returns REGR_COUNT(expr1, expr2) * VAR_POP(expr1) for non-null pairs.
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_valx
  description: Returns the value of the dependent variable (2nd param) if both values are not-null.
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: regr_valy
  description: Returns the value of the independent variable (1st param) if both values are not-null.
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: repeat
  description: Returns the input string repeated N times
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: replace
  description: replaces all occurrences of searched substring in subject with a replacement
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: replace
  description: replaces all occurrences of searched substring in subject with a replacement
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: reverse
  description: return string with character order reversed
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: reverse
  description: return string with character order reversed
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: right
  description: Returns rightmost N characters of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rlike
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: rlike
  description: returns TRUE if subject RLIKE pattern
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: double
  - datatype: double
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: round
  description: round to the nearest integer, with .5 rounded away from 0
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: row_number
  description: Returns the position of this row in the window
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: rpad
  description: padded result string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rpad
  description: padded result string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rpad
  description: padded result string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: rtrim
  description: return string trimmed from right
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rtrim
  description: return string trimmed from right
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: rtrimmed_length
  description: Returns the length of the input string without trailing blanks
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: seq1
  description: returns a sequence of 1-byte integers
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq1
  description: returns a sequence of 1-byte integers
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq2
  description: returns a sequence of 2-byte integers
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq2
  description: returns a sequence of 2-byte integers
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq4
  description: returns a sequence of 4-byte integers
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq4
  description: returns a sequence of 4-byte integers
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq8
  description: returns a sequence of 8-byte integers
  parameters: []
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: seq8
  description: returns a sequence of 8-byte integers
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: sha1
  description: Hex-encoded SHA1 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha1
  description: Hex-encoded SHA1 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha1_binary
  description: Binary SHA1 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha1_binary
  description: Binary SHA1 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha1_hex
  description: Hex-encoded SHA1 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha1_hex
  description: Hex-encoded SHA1 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2_binary
  description: Binary SHA2 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha2_binary
  description: Binary SHA2 digest
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha2_binary
  description: Binary SHA2 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha2_binary
  description: Binary SHA2 digest
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sha2_hex
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2_hex
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2_hex
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sha2_hex
  description: Hex-encoded SHA2 digest
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: shared_result_generate_token
  description: ResultShare token string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: shared_result_readable
  description: readable to current user
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: sign
  description: returns sign of x
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: sign
  description: returns sign of x
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: sin
  description: Compute the sine of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: sinh
  description: Compute the hyperbolic sine of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: skew
  description: Returns the sample skew of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: skew
  description: Returns the sample skew of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: soundex
  description: soundex encoding of string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: soundex_p123
  description: soundex_p123 encoding of string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: space
  description: N spaces
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: split
  description: return split string as array
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: split_part
  description: Splits a string with a delimiter and returns the requested part
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: sqrt
  description: Compute the square root of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: square
  description: Compute the square of the input expression.
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: startswith
  description: returns TRUE if arg1 starts with arg2
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: startswith
  description: returns TRUE if arg1 starts with arg2
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: stddev
  description: Returns the sample standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: stddev
  description: Returns the sample standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: stddev_pop
  description: Returns the population standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: stddev_pop
  description: Returns the population standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: stddev_samp
  description: Returns the sample standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: stddev_samp
  description: Returns the sample standard deviation of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: string_as_binary
  description: Returns the input interpreted as a binary.
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: strip_null_value
  description: Converts null values to SQL NULLs
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: strtok
  description: Tokenizes a string with a delimiter and returns the requested part
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: strtok
  description: Tokenizes a string with a delimiter and returns the requested part
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: strtok
  description: Tokenizes a string with a delimiter and returns the requested part
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: strtok_to_array
  description: Return tokenized string as array
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: strtok_to_array
  description: Return tokenized string as array
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: array
---
function:
  name: st_area
  description: Area of the object in square meters
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_area
  description: Area of the object in the same units as the input coordinates
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_asbinary
  description: Return the WKB representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_asbinary
  description: Return the WKB representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_asewkb
  description: Return the EWKB representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_asewkb
  description: Return the EWKB representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_asewkt
  description: Return the WKB representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_asewkt
  description: Return the WKB representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_asgeojson
  description: Return the GeoJSON representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: st_asgeojson
  description: Return the GeoJSON representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: st_astext
  description: Return the WKT representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_astext
  description: Return the WKT representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_aswkb
  description: Return the WKB representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_aswkb
  description: Return the WKB representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_aswkt
  description: Return the WKB representation of the GEOGRAPHY object
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_aswkt
  description: Return the WKB representation of the GEOMETRY object
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_azimuth
  description: Returns the azimuth in radians of the segment defined by the given point
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_azimuth
  description: Returns the azimuth in radians of the segment defined by the given point
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_buffer
  description: Returns the geometry generated by the buffer operation upon the given input geometry using the diven distance
  parameters:
  - datatype: geometry
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_centroid
  description: The centroid of geography
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_centroid
  description: The centroid of geometry
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_collect
  description: Aggregates all geographies into a GeometryCollection or Multi* geography if they are all of the same single element type (e.g. Point)
  kind: aggregate
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_collect
  description: Version of ST_COLLECT that merges the two input geographies into one
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_contains
  description: True if the first object fully contains the second
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_contains
  description: True if the first object fully contains the second
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_coveredby
  description: True if the second object covers the first
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_coveredby
  description: True if the second object covers the first
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_covers
  description: True if the first object covers the second
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_covers
  description: True if the first object covers the second
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_difference
  description: Geometry representing the set difference a minus b
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_dimension
  description: The dimension of the input geography
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_dimension
  description: The dimension of the input geometry
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_disjoint
  description: True if the two objects not intersect
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_disjoint
  description: True if the two objects not intersect
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_distance
  description: Distance between two geography objects in meters
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_distance
  description: Distance between two geometries in the same units as the input coordinates
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_dwithin
  description: True if the minimum distance between two objects is smaller than or equal to the specified distance in meters
  parameters:
  - datatype: geography
  - datatype: geography
  - datatype: double
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_endpoint
  description: The last point in the geography, only supports LineStrings
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_endpoint
  description: The last point in the geometry, only supports LineStrings
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_envelope
  description: the double-precision (float8) minimum bounding box for the supplied geometry
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_envelope
  description: the shape of the minimum bounding box of the supplied geometry
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geogfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromewkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromewkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromgeohash
  description: The geography represented by the geohash
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromgeohash
  description: The geography represented by the geohash
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromtext
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromtext
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geogpointfromgeohash
  description: The point represented by the geohash
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkb
  description: Alias of ST_GEOGRAPHYFROMWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromewkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geographyfromwkt
  description: Alias of ST_GEOGRAPHYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_geohash
  description: The geohash of a geography
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_geohash
  description: The geohash of a geography
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB from binary
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB from binary
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB from binary
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkb
  description: Parse EWKB from binary
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkt
  description: Parse EWKT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkt
  description: Parse EWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkt
  description: Parse EWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromewkt
  description: Parse EWKT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Parse WKT or EWKT
  parameters:
  - datatype: varchar
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB from binary
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB from binary
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB from binary
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB from binary
  parameters:
  - datatype: binary
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Parse WKB or EWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkb
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geometryfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkb
  description: Alias of ST_GEOMETRYFROMEWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkt
  description: Alias of ST_GEOMETRYFROMEWKT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkt
  description: Alias of ST_GEOMETRYFROMEWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkt
  description: Alias of ST_GEOMETRYFROMEWKT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromewkt
  description: Alias of ST_GEOMETRYFROMEWKT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromtext
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkb
  description: Alias of ST_GEOMETRYFROMWKB
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geomfromwkt
  description: Alias of ST_GEOMETRYFROMTEXT
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_geompoint
  description: Creates a point with the given x and y
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_hausdorffdistance
  description: the Hausdorff distance between two geometries
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_intersection
  description: Geometry representing the intersection of a and b
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_intersection_agg_geography_internal
  description: output
  kind: aggregate
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_intersects
  description: True if the two objects intersect
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_intersects
  description: True if the two objects intersect
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_isrepaired
  description: Return true if geometry was repaired on construction
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_isvalid
  description: True if g has an internal representation
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_isvalid
  description: Return true if geometry is valid
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_length
  description: Length or perimeter of the object in meters
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_length
  description: Length of the geometry in the same units as the input coordinates
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_makegeompoint
  description: Creates a point with the given x and y
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_makeline
  description: Create a Line out of the points in the input geographies
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_makeline
  description: Create a LineString out of the points in the input geographies
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_makepoint
  description: Creates a point with the given longitude and latitude
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_makepolygon
  description: The Polygon consisting of the LineString as outer shell
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_makepolygon
  description: The Polygon consisting of the LineString as outer shell
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_makepolygonoriented
  description: The Polygon consisting of the LineString as outer shell, with unmodified orientation
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_npoints
  description: The number of points in the object's definition
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_npoints
  description: The number of points in the geometry
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_numpoints
  description: Alias for ST_NPOINTS
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_numpoints
  description: Alias for ST_NPOINTS
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_perimeter
  description: Perimeter of the object in meters
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_perimeter
  description: Perimeter of the geometry in the same units as the input coordinates
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_point
  description: Creates a point with the given longitude and latitude
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_pointn
  description: The nth point in the geography, only supports LineStrings
  parameters:
  - datatype: geography
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_pointn
  description: The nth point in the geometry, only supports LineStrings
  parameters:
  - datatype: geometry
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_polygon
  description: Alias for ST_MAKEPOLYGON
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_polygon
  description: Alias for ST_MAKEPOLYGON
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_setsrid
  description: Returns a geometry same as input geometry but with SRID set to the given value
  parameters:
  - datatype: geometry
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_simplify
  description: Simplified version of the given geometry
  parameters:
  - datatype: geography
  - datatype: double
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_simplify
  description: Simplified version of the given geometry
  parameters:
  - datatype: geography
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_simplify
  description: Returns the geometry generated by the simplify operation upon the given input geometry using the given distance, or NULL if the resulting geometry is invalid
  parameters:
  - datatype: geometry
  - datatype: double
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_srid
  description: Returns the SRID of a geography if present. Otherwise 4326
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_srid
  description: Returns the SRID of a geometry if present. Otherwise 0
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: st_startpoint
  description: The first point in the geography, only supports LineStrings
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_startpoint
  description: The first point in the geometry, only supports LineStrings
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_symdifference
  description: Geometry representing the set symmetric difference a minus b
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_transform
  description: Returns the geometry transformed from one SRID to another SRID.
  parameters:
  - datatype: geometry
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_transform
  description: Returns the geometry transformed to another SRID.
  parameters:
  - datatype: geometry
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: st_union
  description: Geometry representing the union of a and b
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: st_union_agg_geography_internal
  description: output
  kind: aggregate
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: st_within
  description: True if the second object fully contains the first
  parameters:
  - datatype: geography
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_within
  description: True if the second object fully contains the first
  parameters:
  - datatype: geometry
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: st_x
  description: The longitude of a point
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_x
  description: The X coordinate of a point
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_xmax
  description: The maximum longitude
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_xmax
  description: The maximum X coordinate
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_xmin
  description: The minimum longitude
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_xmin
  description: The minimum X coordinate
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_y
  description: The latitude of a point
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_y
  description: The Y coordinate of a point
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_ymax
  description: The maximum latitude
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_ymax
  description: The maximum Y coordinate
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_ymin
  description: The minimum latitude
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: st_ymin
  description: The minimum Y coordinate
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: substr
  description: Returns string fragment of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: substr
  description: Returns string fragment of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: substr
  description: Returns string fragment of the input string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: substr
  description: Returns string fragment of the input string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: substring
  description: Returns string fragment of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: substring
  description: Returns string fragment of the input string
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: substring
  description: Returns string fragment of the input string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: substring
  description: Returns string fragment of the input string
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: sum
  description: Returns a sum of a column
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: sum
  description: Returns a sum of a column
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: sum_internal
  description: Returns a sum of a column
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: sum_internal
  description: Returns a sum of a column
  kind: aggregate
  parameters:
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: sysdate
  description: Returns the current timestamp in the UTC time zone
  parameters: []
  optional-parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: system$abort_session
  description: Abort the specified open session
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$abort_transaction
  description: Abort the specified transaction if it is running. If the transaction is already is committed/rolled back then the state of the transaction is not altered.
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$add_reference
  description: Returns whether the persisted reference is successfully associated
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$app_validate_permission_request
  description: response message
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$behavior_change_bundle_status
  description: returned value
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$cancel_all_queries
  description: cancel all the queries running in the specified session
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$cancel_all_queries
  description: cancel all the queries running in the specified session
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$cancel_job
  description: status
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$cancel_query
  description: cancel the specified running query
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_depth
  description: Average depth of the table
  variadic: uniform
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$clustering_depth
  description: Average depth of the table
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$clustering_depth
  description: Average depth of the table
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$clustering_information
  description: returns clustering information as json
  variadic: uniform
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_information
  description: returns clustering information as json
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_information
  description: returns clustering information as json
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_information
  description: returns clustering information as json
  variadic: uniform
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_information
  description: returns clustering information as json
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$clustering_ratio
  description: Clustering ratio for the specified table
  variadic: uniform
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$clustering_ratio
  description: Clustering ratio for the specified table
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$clustering_ratio
  description: Clustering ratio for the specified table
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: system$convert_global_secondary_share_to_rg_replica
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$convert_pipes_sqs_to_sns
  description: returns true if all SQS pipes' metadata based on this bucket are successfully converted to new SNS topic-based pipes.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$convert_primary_database_for_replication_group
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$convert_primary_share_for_replication_group
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$convert_secondary_database_for_replication_group
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$convert_secondary_share_for_replication_group
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$disable_database_replication
  description: Returns success/fail message of the operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$estimate_query_acceleration
  description: estimate query acceleration result
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$estimate_search_optimization_costs
  description: 'result: the cost report result for search optimization on the given table'
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$estimate_search_optimization_costs
  description: 'result: the cost report result for search optimization on the given table'
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$explain_json_to_text
  description: text format explain plan from json
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$explain_plan_json
  description: json of the explain plan result
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$external_table_pipe_status
  description: returns pipe status as json
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$generate_saml_csr
  description: returns the result of the operation.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_account_locator_url
  description: 'Returns default locator url for the current account '
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_all_references
  description: Returns all persisted references under the definition
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_aws_sns_iam_policy
  description: returns IAM policy for the SNS topic
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_dependent_iceberg_tables
  description: returns the list of Dependent Iceberg table fully qualified names
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_directory_table_status
  description: returns the associated directory table status
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_directory_table_status
  description: returns the associated directory table status
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_iceberg_table_information
  description: returns the latest Iceberg metadata information
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_iceberg_table_information
  description: returns the latest Iceberg metadata information
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_iceberg_table_information
  description: returns the latest Iceberg metadata information
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_iceberg_table_information
  description: returns the latest Iceberg metadata information
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_job_logs
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_job_logs
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_job_logs_s3
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_job_status
  description: return service resource set status
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_job_status
  description: return service resource set status
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_predecessor_return_value
  description: Return data
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_predecessor_return_value
  description: Return data
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_referenced_object_id_hash
  description: Returns the hashed associated object id with give reference definition name and alias (optional)
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_referenced_object_id_hash
  description: Returns the hashed associated object id with give reference definition name and alias (optional)
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_service_logs
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_service_logs
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_service_logs_s3
  description: return status of operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_service_status
  description: return service resource set status
  parameters:
  - datatype: $1
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_service_status
  description: return service resource set status
  parameters:
  - datatype: $1
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_share_refresh_missing_objects
  description: returns the missing underlying objects for the most recent share refresh task for a share
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_tag
  description: Returns the associated tag value
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_tag_allowed_values
  description: Returns the allowed values for a tag
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_tag_on_current_column
  description: Returns the associated tag value
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_tag_on_current_table
  description: Returns the associated tag value on the current table
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_task_graph_config
  description: Result
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_task_graph_config
  description: Result
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$global_account_set_parameter
  description: param set result from the account
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$hold_privilege_on_account
  description: Return true if any activated role contains the given privilege
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: system$iceberg_table_auto_refresh_status
  description: returns pipe status as json
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$last_change_commit_time
  description: returns the largest commit time as a long.
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: system$md5_number
  description: Integral MD5 digest
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: system$md5_number
  description: Integral MD5 digest
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: system$migrate_saml_idp_registration
  description: Returns the result of the operation.
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$migrate_saml_idp_registration
  description: Returns the result of the operation.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$pipe_force_resume
  description: returns result of operation
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$pipe_force_resume
  description: returns result of operation
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$pipe_rebinding_with_notification_channel
  description: returns true if the pipe successfully rebinds with its assigned notification channel
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$pipe_status
  description: returns pipe status as json
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$query_reference
  description: Returns the query reference identifier
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$query_reference
  description: Returns the query reference identifier
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: boolean
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$reference
  description: Returns the reference identifier
  variadic: uniform
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$remove_all_delegated_authorizations
  description: The Username.
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$remove_all_references
  description: Returns whether all the Persisted references are successfully dropped under the ref name
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$remove_reference
  description: Returns whether the Persisted reference is successfully dropped
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$remove_reference
  description: Returns whether the Persisted reference is successfully dropped
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$run_query_with_session_token
  description: return query response
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$run_query_with_session_token
  description: return query response
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$set_reference
  description: Returns whether the persisted reference is successfully associated
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$set_return_value
  description: Returns "OK" if succeeded
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$show_active_behavior_change_bundles
  description: returned value
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$snowpipe_streaming_update_channel_offset_token
  description: returns status of update
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$snowservices_resolve_ingress
  description: json info for routing to snowservice ingress
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$stage_pipe_status
  description: returns pipe status as json
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$streamlit_rerun
  description: Rerun dispatch successful
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: system$task_dependents_enable
  description: Returns "OK" if succeeded
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$task_runtime_info
  description: result
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$ui_replication_information
  description: returns information about replication databases for the UI
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$user_task_cancel_ongoing_executions
  description: Returns "OK" if succeeded
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$verify_external_oauth_token
  description: The OAuth Access Token.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$wait
  description: Wait for a finite amount of time
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$wait
  description: Wait for a finite amount of time
  parameters:
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: system$get_image_repository_metadata
  description: return JSON RepositoryMetadata, if caller has access
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: systimestamp
  description: Returns the current timestamp
  parameters: []
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: tan
  description: Compute the tangent of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: tanh
  description: Compute the hyperbolic tangent of the input expression (as radians).
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: time
  description: Converts the timestamp argument to a time
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: time
  description: Converts the timestamp argument to a time
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: time
  description: Converts the timestamp argument to a time
  parameters:
  - datatype: timestamp
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: time
  description: Converts the timestamp argument to a time
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: time
  description: Converts the timestamp argument to a time
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: timefromparts
  description: Construct a time from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: timefromparts
  description: Construct a time from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: timestampfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: date
  - datatype: time
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampltzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampltzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampntzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampntzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestampntzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: date
  - datatype: time
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamptzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamptzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamptzfromparts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: date
  - datatype: time
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_ltz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_ltz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_ntz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_ntz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_ntz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: date
  - datatype: time
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_tz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_tz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: timestamp_tz_from_parts
  description: Construct a timestamp from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: time_from_parts
  description: Construct a time from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: time_from_parts
  description: Construct a time from individual components
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: tmp_search_fix_900259
  description: Indicates whether the row in question satisfies the query in at least one of the specified columns and variant paths.
  parameters:
  - datatype: array
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: tmp_search_fix_900259
  description: Indicates whether the row in question satisfies the query in at least one of the specified columns and variant paths.
  parameters:
  - datatype: array
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: boolean
---
function:
  name: to_geography
  description: No-op; prevents us from re-packaging GEOGRAPHY during input
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: No-op; prevents us from re-packaging GEOGRAPHY during input
  parameters:
  - datatype: geography
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses a variant as a GEOGRAPHY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses a variant as a GEOGRAPHY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses a string as a GEOGRAPHY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses a string as a GEOGRAPHY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses binary input in WKB format into a GEOGRAPHY object
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geography
  description: Parses binary input in WKB format into a GEOGRAPHY object
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: to_geometry
  description: No-op; prevents us from re-packaging GEOMETRY during input
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  parameters:
  - datatype: variant
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_geometry
  description: Parses binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: to_json
  description: Convert variant data to string as JSON
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: to_xml
  description: Convert variant data to string as XML
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: translate
  description: replaces all occurences of each character of the source alphabet in the subject with the corresponding character in the target alphabet
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: trim
  description: return string trimmed from both sides
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: trim
  description: return string trimmed from both sides
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: date
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: time
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: trunc
  description: truncate the fractional or date part
  parameters:
  - datatype: timestamp
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: double
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: date
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: date
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: time
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: time
---
function:
  name: truncate
  description: truncate the fractional or date part
  parameters:
  - datatype: timestamp
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: timestamp
---
function:
  name: try_base64_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_base64_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_base64_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: try_base64_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_decrypt_raw
  description: decrypted binary string (return)
  parameters:
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: binary
  - datatype: varchar
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_hex_decode_binary
  description: return decoded binary
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: binary
---
function:
  name: try_hex_decode_string
  description: return decoded string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: try_parse_ip
  description: Returns an object with all the components of the IP
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: try_parse_json
  description: Parses string as a JSON document
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: variant
---
function:
  name: try_to_geography
  description: No-op; prevents us from re-packaging GEOGRAPHY during input
  parameters:
  - datatype: geography
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: No-op; prevents us from re-packaging GEOGRAPHY during input
  parameters:
  - datatype: geography
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse a variant as a GEOGRAPHY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse a variant as a GEOGRAPHY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse a string as a GEOGRAPHY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse a string as a GEOGRAPHY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse binary input in WKB format into a GEOGRAPHY object
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geography
  description: Tries to parse binary input in WKB format into a GEOGRAPHY object
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geography
---
function:
  name: try_to_geometry
  description: No-op; prevents us from re-packaging GEOMETRY during input
  parameters:
  - datatype: geometry
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a variant as a GEOMETRY object; supported format is GeoJSON
  parameters:
  - datatype: variant
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse a string as a GEOMETRY object; supported formats are GeoJSON, WKT, and WKB
  parameters:
  - datatype: varchar
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: boolean
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: decimal(38, 0)
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_to_geometry
  description: Tries to parse binary input in WKB format into a GEOMETRY object
  parameters:
  - datatype: binary
  - datatype: boolean
  optional-parameters: []
  returns:
    datatype: geometry
---
function:
  name: try_validate_utf8
  description: return the input string if valid UTF8 otherwise null
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: typeof
  description: Returns SQL type word of a variant value
  parameters:
  - datatype: variant
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: unicode
  description: Returns the Unicode code point of the first character of the string
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: uniform
  description: Returns a uniform random distribution
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: uniform
  description: Returns a uniform random distribution
  parameters:
  - datatype: double
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: upper
  description: return string with all characters in uppercase
  parameters:
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: uuid_string
  description: Returns a pseudo-randomly generated (version 4) UUID.
  parameters: []
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: uuid_string
  description: Returns a pseudo-randomly generated (version 4) UUID.
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: validate_stage_location_against_integration
  description: returns whether a stage location is allowed or blocked by the integration
  parameters:
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: validate_stage_location_against_integration
  description: returns whether a stage location is allowed or blocked by the integration
  parameters:
  - datatype: varchar
  - datatype: varchar
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: varchar
---
function:
  name: variance
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: variance
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: variance_pop
  description: Returns the population variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: variance_pop
  description: Returns the population variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: variance_samp
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: variance_samp
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: var_pop
  description: Returns the population variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: var_pop
  description: Returns the population variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: var_samp
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: var_samp
  description: Returns the sample variance of the values in a group. Null values are ignored.
  kind: aggregate
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: vector_cosine_distance
  description: Cosine distance between vectors
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: vector_inner_product
  description: Inner product between vectors
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: vector_l2_distance
  description: L2 distance between vectors
  parameters:
  - datatype: array
  - datatype: array
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: width_bucket
  description: returns the bucket a value falls into in an equiwidth histogram
  parameters:
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: width_bucket
  description: returns the bucket a value falls into in an equiwidth histogram
  parameters:
  - datatype: double
  - datatype: double
  - datatype: double
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: xmlget
  description: Get XML element object by XML tag name
  parameters:
  - datatype: variant
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: xmlget
  description: Get XML element object by XML tag name
  parameters:
  - datatype: object
  - datatype: varchar
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: xmlget
  description: Get XML element object by XML tag name
  parameters:
  - datatype: variant
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: xmlget
  description: Get XML element object by XML tag name
  parameters:
  - datatype: object
  - datatype: varchar
  optional-parameters: []
  returns:
    datatype: object
---
function:
  name: zeroifnull
  description: Converts to zero if the input is NULL
  parameters:
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)
---
function:
  name: zeroifnull
  description: Converts to zero if the input is NULL
  parameters:
  - datatype: double
  optional-parameters: []
  returns:
    datatype: double
---
function:
  name: zipf
  description: Returns a Zipf distribution
  parameters:
  - datatype: double
  - datatype: decimal(38, 0)
  - datatype: decimal(38, 0)
  optional-parameters: []
  returns:
    datatype: decimal(38, 0)