---
function:
name: add_months
parameters:
- datatype: string
- datatype: bigint
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: temporal
---
function:
name: all_user_names
parameters: []
returns:
datatype: array
kind: scalar
volatility: pure
section: other
---
function:
name: to_array
parameters:
- datatype: $1
returns:
datatype: array
kind: scalar
volatility: pure
section: other
---
function:
name: to_variant
parameters:
- datatype: $1
returns:
datatype: variant
kind: scalar
volatility: pure
section: other
---
function:
name: to_object
parameters:
- datatype: $1
returns:
datatype: object
kind: scalar
volatility: pure
section: other
---
function:
name: to_binary
parameters:
- datatype: $1
returns:
datatype: binary
kind: scalar
volatility: pure
section: other
---
function:
name: to_binary
parameters:
- datatype: $1
- datatype: string
returns:
datatype: binary
kind: scalar
volatility: pure
section: other
---
function:
name: to_date
parameters:
- datatype: $1
returns:
datatype: datetime
kind: scalar
volatility: pure
section: other
---
function:
name: to_date
parameters:
- datatype: $1
- datatype: string
returns:
datatype: datetime
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_date
parameters:
- datatype: $1
returns:
datatype: datetime
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_date
parameters:
- datatype: $1
- datatype: string
returns:
datatype: datetime
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_decimal
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_decimal
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_time
parameters:
- datatype: $1
returns:
datatype: time
kind: scalar
volatility: pure
section: other
---
function:
name: to_time
parameters:
- datatype: $1
- datatype: string
returns:
datatype: time
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_time
parameters:
- datatype: $1
returns:
datatype: time
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_time
parameters:
- datatype: $1
- datatype: string
returns:
datatype: time
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp_tz
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp_tz
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp_ntz
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp_ntz
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp_tz
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp_tz
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp_ntz
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp_ntz
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_timestamp
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: avg
parameters:
- datatype: string
returns:
datatype: string
kind: aggregate
volatility: pure
section: other
---
function:
name: to_varchar
parameters:
- datatype: $1
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: to_varchar
parameters:
- datatype: $1
- datatype: string
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: collate
parameters:
- datatype: $1
- datatype: string
returns:
datatype: $1
kind: scalar
volatility: pure
section: other
---
function:
name: bitand_agg
parameters:
- datatype: string
returns:
datatype: string
kind: aggregate
volatility: pure
section: other
---
function:
name: bitor_agg
parameters:
- datatype: string
returns:
datatype: string
kind: aggregate
volatility: pure
section: other
---
function:
name: bitxor_agg
parameters:
- datatype: string
returns:
datatype: string
kind: aggregate
volatility: pure
section: other
---
function:
name: booland_agg
parameters:
- datatype: boolean
returns:
datatype: boolean
kind: aggregate
volatility: pure
section: other
---
function:
name: boolor_agg
parameters:
- datatype: boolean
returns:
datatype: boolean
kind: aggregate
volatility: pure
section: other
---
function:
name: boolxor_agg
parameters:
- datatype: boolean
returns:
datatype: boolean
kind: aggregate
volatility: pure
section: other
---
function:
name: cleanup_database_role_grants
parameters:
- datatype: string
- datatype: string
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: collation
parameters:
- datatype: $1
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: conditional_true_event
parameters:
- datatype: decimal(38, 0)
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: current_account
parameters: []
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: current_account_name
parameters: []
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: current_available_roles
parameters: []
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: current_client
parameters: []
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: date_part
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- dayofweek
- weekday
- dow
- dw
- dayofweekiso
- weekday_iso
- dow_iso
- dw_iso
- dayofyear
- yearday
- doy
- dy
- week
- w
- wk
- weekofyear
- woy
- wy
- weekiso
- week_iso
- weekofyeariso
- weekofyear_iso
- quarter
- q
- qtr
- qtrs
- quarters
- yearofweek
- yearofweekiso
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- epoch_second
- epoch
- epoch_seconds
- epoch_millisecond
- epoch_milliseconds
- epoch_microsecond
- epoch_microseconds
- epoch_nanosecond
- epoch_nanoseconds
- timezone_hour
- tzh
- timezone_minute
- tzm
- datatype: $1
returns:
datatype: double
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: extract
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- dayofweek
- weekday
- dow
- dw
- dayofweekiso
- dayofweek_iso
- weekday_iso
- dow_iso
- dw_iso
- dayofyear
- yearday
- doy
- dy
- week
- w
- wk
- weekofyear
- woy
- wy
- weekiso
- week_iso
- weekofyeariso
- weekofyear_iso
- quarter
- q
- qtr
- qtrs
- quarters
- yearofweek
- yearofweekiso
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- epoch_second
- epoch
- epoch_seconds
- epoch_millisecond
- epoch_milliseconds
- epoch_microsecond
- epoch_microseconds
- epoch_nanosecond
- epoch_nanoseconds
- timezone_hour
- tzh
- timezone_minute
- tzm
- datatype: $1
returns:
datatype: double
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: date_trunc
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: $1
returns:
datatype: $1
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: to_timestamp_ltz
parameters:
- datatype: $1
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: to_timestamp_ltz
parameters:
- datatype: $1
- datatype: string
returns:
datatype: timestamp
kind: scalar
volatility: pure
section: other
---
function:
name: dateadd
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- day
- days
- dayofmonth
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: double
- datatype: $1
returns:
datatype: $1
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: timestampadd
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- day
- days
- dayofmonth
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: double
- datatype: $1
returns:
datatype: $1
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: timeadd
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: double
- datatype: $1
returns:
datatype: $1
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: datediff
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: $1
- datatype: $2
returns:
datatype: bigint
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
- type-variable: $2
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: getvariable
parameters:
- datatype: string
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: to_geggraphy
parameters:
- datatype: $1
returns:
datatype: geography
kind: scalar
volatility: pure
section: other
---
function:
name: year
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: hour
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: minute
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: second
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: hash_agg
description: aggregate hash value
kind: aggregate
parameters:
- datatype: $1
optional-parameters: []
returns:
datatype: decimal(38, 0)
---
function:
name: hash_agg
description: aggregate hash value
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
optional-parameters: []
returns:
datatype: decimal(38, 0)
---
function:
name: hash_agg
description: aggregate hash value
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
optional-parameters: []
returns:
datatype: decimal(38, 0)
---
function:
name: hash_agg
description: aggregate hash value
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
- datatype: $4
optional-parameters: []
returns:
datatype: decimal(38, 0)
---
function:
name: hash_agg
description: aggregate hash value
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
- datatype: $4
- datatype: $5
optional-parameters: []
returns:
datatype: decimal(38, 0)
---
function:
name: last_day
parameters:
- datatype: $1
returns:
datatype: date
kind: scalar
volatility: pure
section: temporal
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
---
function:
name: last_day
parameters:
- datatype: $1
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- week
- w
- wk
- weekofyear
- woy
- wy
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- millisecond
- ms
- mesc
- milliseconds
- microsecond
- us,
- usec,
- microseconds
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
returns:
datatype: date
kind: scalar
volatility: pure
section: temporal
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
---
function:
name: md5_number_upper64
parameters:
- datatype: string
returns:
datatype: binary
kind: scalar
volatility: pure
section: other
---
function:
name: md5_number_lower64
parameters:
- datatype: string
returns:
datatype: binary
kind: scalar
volatility: pure
section: other
---
function:
name: months_between
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
---
function:
name: round
parameters: []
optional-parameters:
- datatype: double
name: expr
- datatype: bigint
name: scale
- datatype: string
name: rounding_mode
returns:
datatype: bigint
kind: scalar
volatility: pure
section: other
---
function:
name: time_slice
parameters:
- datatype: $1
- datatype: bigint
- datatype: string
returns:
datatype: $1
kind: scalar
volatility: pure
section: temporal
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
---
function:
name: time_slice
parameters:
- datatype: $1
- datatype: bigint
- datatype: string
- datatype: string
returns:
datatype: $1
kind: scalar
volatility: pure
section: temporal
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
---
function:
name: timediff
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- dayofweek
- dayofyear
- yearday
- doy
- dy
- week
- w
- wk
- weekofyear
- woy
- wy
- weekofyeariso
- weekofyear_iso
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: $1
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: to_char
parameters:
- datatype: $1
- datatype: string
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: to_char
parameters:
- datatype: $1
returns:
datatype: string
kind: scalar
volatility: pure
section: other
---
function:
name: to_boolean
parameters:
- datatype: $1
returns:
datatype: boolean
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_boolean
parameters:
- datatype: $1
returns:
datatype: boolean
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_number
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_number
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_numeric
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
- datatype: string
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_numeric
parameters:
- datatype: $1
- datatype: string
- datatype: bigint
- datatype: bigint
returns:
datatype: decimal(38, 0)
kind: scalar
volatility: pure
section: other
---
function:
name: to_double
parameters:
- datatype: $1
returns:
datatype: double
kind: scalar
volatility: pure
section: other
---
function:
name: try_to_double
parameters:
- datatype: $1
returns:
datatype: double
kind: scalar
volatility: pure
section: other
---
function:
name: week
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: dayofweek
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: quarter
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: dayofweekiso
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: weekiso
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: month
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: day
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: weekofyear
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: yearofweek
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: dayofmonth
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: yearofweekiso
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: dayofyear
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: yearofweekiso
parameters:
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
section: temporal
---
function:
name: parse_xml
parameters: []
optional-parameters:
- datatype: string
name: str
- datatype: boolean
name: disable_auto_convert
returns:
datatype: variant
kind: scalar
volatility: pure
section: other
---
function:
name: flatten
parameters:
- datatype: $1
name: input
optional-parameters:
- datatype: string
name: path
- datatype: boolean
name: outer
- datatype: boolean
name: recursive
- datatype: string
name: mode
returns:
datatype: struct<seq bigint, key string, path string, index bigint, value variant, this $1>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- variant
- object
- array
---
function:
name: split_to_table
parameters:
- datatype: string
- datatype: string
returns:
datatype: struct<seq int, index int, value string>
kind: table
volatility: pure
---
function:
name: strtok_split_to_table
parameters:
- datatype: string
returns:
datatype: struct<seq int, index int, value string>
kind: table
volatility: pure
variadic: uniform
---
function:
name: get_object_references
parameters: []
optional-parameters:
- datatype: string
name: database_name
- datatype: string
name: schema_name
- datatype: string
name: object_name
returns:
datatype: struct<database_name string, schema_name string, object_name string, referenced_database_name string, referenced_schema_name string, referenced_object_name string, referenced_object_type string>
kind: table
volatility: pure
---
function:
name: get_query_operator_stats
parameters:
- datatype: string
returns:
datatype: >
struct<query_id string, step_id bigint, operator_id bigint, parent_operators array, operator_type string, operator_statistics variant, execution_time_breakdown variant, operator_attributes variant>
kind: table
volatility: pure
---
function:
name: login_history_by_user
parameters: []
optional-parameters:
- datatype: $1
name: time_range_start
- datatype: $2
name: time_range_end
- datatype: string
name: user_name
- datatype: bigint
name: result_limit
returns:
datatype: struct<event_timestamp timestamp, event_id bigint, event_type string, user_name string, client_ip string, reported_client_type string, reported_client_version string, first_authentication_factor string, second_authentication_factor string, is_success string, error_code bigint, error_message string, related_event_id bigint, "connection" string>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
---
function:
name: login_history
parameters: []
optional-parameters:
- datatype: $1
name: time_range_start
- datatype: $2
name: time_range_end
- datatype: bigint
name: result_limit
returns:
datatype: struct<event_timestamp timestamp, event_id bigint, event_type string, user_name string, client_ip string, reported_client_type string, reported_client_version string, first_authentication_factor string, second_authentication_factor string, is_success string, error_code bigint, error_message string, related_event_id bigint, "connection" string>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
---
function:
name: query_history
parameters: []
optional-parameters:
- datatype: $1
name: end_time_range_start
- datatype: $2
name: end_time_range_end
- datatype: bigint
name: result_limit
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
returns:
datatype: >
struct<query_id string,
query_text string,
database_name string,
schema_name string,
query_type string,
session_id bigint,
user_name string,
role_name string,
warehouse_name string,
warehouse_size string,
warehouse_type string,
cluster_number bigint,
query_tag string,
execution_status string,
error_code bigint,
error_message string,
start_time timestamp,
end_time timestamp,
total_elapsed_time bigint,
bytes_scanned bigint,
rows_produced bigint,
compilation_time bigint,
execution_time bigint,
queued_provisioning_time bigint,
queued_repair_time bigint,
queued_overload_time bigint,
transaction_blocked_time bigint,
outbound_data_transfer_cloud string,
outbound_data_transfer_region string,
outbound_data_transfer_bytes bigint,
inbound_data_transfer_cloud string,
inbound_data_transfer_region string,
inbound_data_transfer_bytes bigint,
list_external_file_time bigint,
credits_used_cloud_services bigint,
release_version string,
external_function_total_invocations bigint,
external_function_total_sent_rows bigint,
external_function_total_received_rows bigint,
external_function_total_sent_bytes bigint,
external_function_total_received_bytes bigint,
is_client_generated_statement boolean,
query_hash string,
query_hash_version bigint,
query_parameterized_hash string,
query_parameterized_hash_version bigint>
kind: table
volatility: pure
---
function:
name: query_history_by_session
parameters: []
optional-parameters:
- datatype: bigint
name: session_id
- datatype: $1
name: end_time_range_start
- datatype: $2
name: end_time_range_end
- datatype: bigint
name: result_limit
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
returns:
datatype: >
struct<query_id string,
query_text string,
database_name string,
schema_name string,
query_type string,
session_id bigint,
user_name string,
role_name string,
warehouse_name string,
warehouse_size string,
warehouse_type string,
cluster_number bigint,
query_tag string,
execution_status string,
error_code bigint,
error_message string,
start_time timestamp,
end_time timestamp,
total_elapsed_time bigint,
bytes_scanned bigint,
rows_produced bigint,
compilation_time bigint,
execution_time bigint,
queued_provisioning_time bigint,
queued_repair_time bigint,
queued_overload_time bigint,
transaction_blocked_time bigint,
outbound_data_transfer_cloud string,
outbound_data_transfer_region string,
outbound_data_transfer_bytes bigint,
inbound_data_transfer_cloud string,
inbound_data_transfer_region string,
inbound_data_transfer_bytes bigint,
list_external_file_time bigint,
credits_used_cloud_services bigint,
release_version string,
external_function_total_invocations bigint,
external_function_total_sent_rows bigint,
external_function_total_received_rows bigint,
external_function_total_sent_bytes bigint,
external_function_total_received_bytes bigint,
is_client_generated_statement boolean,
query_hash string,
query_hash_version bigint,
query_parameterized_hash string,
query_parameterized_hash_version bigint>
kind: table
volatility: pure
---
function:
name: query_history_by_user
parameters: []
optional-parameters:
- datatype: bigint
name: user_name
- datatype: $1
name: end_time_range_start
- datatype: $2
name: end_time_range_end
- datatype: bigint
name: result_limit
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
returns:
datatype: >
struct<query_id string,
query_text string,
database_name string,
schema_name string,
query_type string,
session_id bigint,
user_name string,
role_name string,
warehouse_name string,
warehouse_size string,
warehouse_type string,
cluster_number bigint,
query_tag string,
execution_status string,
error_code bigint,
error_message string,
start_time timestamp,
end_time timestamp,
total_elapsed_time bigint,
bytes_scanned bigint,
rows_produced bigint,
compilation_time bigint,
execution_time bigint,
queued_provisioning_time bigint,
queued_repair_time bigint,
queued_overload_time bigint,
transaction_blocked_time bigint,
outbound_data_transfer_cloud string,
outbound_data_transfer_region string,
outbound_data_transfer_bytes bigint,
inbound_data_transfer_cloud string,
inbound_data_transfer_region string,
inbound_data_transfer_bytes bigint,
list_external_file_time bigint,
credits_used_cloud_services bigint,
release_version string,
external_function_total_invocations bigint,
external_function_total_sent_rows bigint,
external_function_total_received_rows bigint,
external_function_total_sent_bytes bigint,
external_function_total_received_bytes bigint,
is_client_generated_statement boolean,
query_hash string,
query_hash_version bigint,
query_parameterized_hash string,
query_parameterized_hash_version bigint>
kind: table
volatility: pure
---
function:
name: query_history_by_warehouse
parameters: []
optional-parameters:
- datatype: string
name: warehouse_name
- datatype: $1
name: end_time_range_start
- datatype: $2
name: end_time_range_end
- datatype: bigint
name: result_limit
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
returns:
datatype: >
struct<query_id string,
query_text string,
database_name string,
schema_name string,
query_type string,
session_id bigint,
user_name string,
role_name string,
warehouse_name string,
warehouse_size string,
warehouse_type string,
cluster_number bigint,
query_tag string,
execution_status string,
error_code bigint,
error_message string,
start_time timestamp,
end_time timestamp,
total_elapsed_time bigint,
bytes_scanned bigint,
rows_produced bigint,
compilation_time bigint,
execution_time bigint,
queued_provisioning_time bigint,
queued_repair_time bigint,
queued_overload_time bigint,
transaction_blocked_time bigint,
outbound_data_transfer_cloud string,
outbound_data_transfer_region string,
outbound_data_transfer_bytes bigint,
inbound_data_transfer_cloud string,
inbound_data_transfer_region string,
inbound_data_transfer_bytes bigint,
list_external_file_time bigint,
credits_used_cloud_services bigint,
release_version string,
external_function_total_invocations bigint,
external_function_total_sent_rows bigint,
external_function_total_received_rows bigint,
external_function_total_sent_bytes bigint,
external_function_total_received_bytes bigint,
is_client_generated_statement boolean,
query_hash string,
query_hash_version bigint,
query_parameterized_hash string,
query_parameterized_hash_version bigint>
kind: table
volatility: pure
---
function:
name: query_acceleration_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: warehouse_name
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
returns:
datatype: >
struct<start_time timestamp,
end_time timestamp,
credits_used bigint,
warehouse_name string,
num_files_scanned bigint,
num_bytes_scanned bigint
>
kind: table
volatility: pure
---
function:
name: database_storage_usage_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: database_name
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
returns:
datatype: >
struct<usage_date date,
database_name string,
average_database_bytes bigint,
average_fail_safe_bytes bigint
>
kind: table
volatility: pure
---
function:
name: warehouse_load_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: warehouse_name
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
returns:
datatype: >
struct<start_time timestamp,
end_time timestamp,
warehouse_name string,
avg_running decimal(38,2),
avg_queued_load decimal(38,2),
avg_queued_provisioning decimal(38,2),
avg_blocked decimal(38,2)
>
kind: table
volatility: pure
---
function:
name: warehouse_metering_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: warehouse_name
returns:
datatype: >
struct<start_time timestamp,
end_time timestamp,
warehouse_name string,
credits_used bigint,
credits_used_compute bigint,
credits_used_cloud_services bigint
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
---
function:
name: stage_storage_usage_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
returns:
datatype: >
struct<usage_date date, average_stage_bytes bigint>
kind: table
volatility: pure
---
function:
name: stage_directory_file_registration_history
parameters:
- datatype: string
name: stage_name
optional-parameters:
- datatype: $1
name: start_time
binds:
- type-variable: $1
datatypes:
- timestamp
- string
returns:
datatype: >
struct<
job_created_time timestamp,
file_name string,
operation_status string,
message string,
file_size bigint,
last_modified timestamp
>
kind: table
volatility: pure
---
function:
name: policy_references
parameters: []
optional-parameters:
- datatype: string
name: policy_name
- datatype: string
name: ref_entity_name
- datatype: string
name: ref_entity_domain
returns:
datatype: >
struct<
policy_db string,
policy_schema string,
policy_name string,
policy_kind string,
ref_database_name string,
ref_schema_name string,
ref_entity_name string,
ref_entity_domain string,
ref_column_name string,
ref_arg_column_names array,
tag_database string,
tag_schema string,
tag_name string,
policy_status string
>
kind: table
volatility: pure
---
function:
name: tag_references
parameters:
- datatype: string
- datatype: string
returns:
datatype: >
struct<
tag_database string,
tag_schema string,
tag_name string,
tag_value string,
level string,
object_database string,
object_schema string,
object_name string,
domain string,
column_name string
>
kind: table
volatility: pure
---
function:
name: tag_references_all_columns
parameters:
- datatype: string
- datatype: string
returns:
datatype: >
struct<
tag_database string,
tag_schema string,
tag_name string,
tag_value string,
level string,
object_database string,
object_schema string,
object_name string,
domain string,
column_name string
>
kind: table
volatility: pure
---
function:
name: tag_references_with_lineage
parameters:
- datatype: string
returns:
datatype: >
struct<
tag_database string,
tag_schema string,
tag_id bigint,
tag_name string,
tag_value string,
level string,
object_database string,
object_schema string,
object_id bigint,
object_name string,
object_deleted timestamp,
domain string,
column_id bigint,
column_name string
>
kind: table
volatility: pure
---
function:
name: replication_group_refresh_history
parameters:
- datatype: string
returns:
datatype: >
struct<
phase_name string,
start_time timestamp,
end_time timestamp,
job_uuid string,
total_bytes variant,
object_count variant,
primary_snapshot_timestamp timestamp,
error variant
>
kind: table
volatility: pure
---
function:
name: replication_group_refresh_progress
parameters:
- datatype: string
returns:
datatype: >
struct<
phase_name string,
start_time timestamp,
end_time timestamp,
progress string,
details variant
>
kind: table
volatility: pure
---
function:
name: replication_group_refresh_progress_by_job
parameters:
- datatype: string
returns:
datatype: >
struct<
phase_name string,
start_time timestamp,
end_time timestamp,
progress string,
details variant
>
kind: table
volatility: pure
---
function:
name: replication_group_usage_history
parameters: []
optional-parameters:
- datatype: date
name: date_range_start
- datatype: date
name: date_range_end
- datatype: string
name: replication_group_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
replication_group_name string,
credits_used string,
bytes_transferred bigint
>
kind: table
volatility: pure
---
function:
name: replication_usage_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: database_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
database_name string,
credits_used string,
bytes_transferred bigint
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
---
function:
name: database_refresh_history
parameters:
- datatype: string
returns:
datatype: >
struct<
current_phase string,
start_time timestamp,
end_time timestamp,
job_uuid string,
copy_bytes bigint,
object_count bigint
>
kind: table
volatility: pure
---
function:
name: database_refresh_history
parameters: []
returns:
datatype: >
struct<
current_phase string,
start_time timestamp,
end_time timestamp,
job_uuid string,
copy_bytes bigint,
object_count bigint
>
kind: table
volatility: pure
---
function:
name: database_refresh_progress
parameters:
- datatype: string
returns:
datatype: >
struct<
phase_name string,
result string,
start_time timestamp,
end_time timestamp,
details variant
>
kind: table
volatility: pure
---
function:
name: database_refresh_progress
parameters: []
returns:
datatype: >
struct<
phase_name string,
result string,
start_time timestamp,
end_time timestamp,
details variant
>
kind: table
volatility: pure
---
function:
name: database_refresh_progress_by_job
parameters:
- datatype: string
returns:
datatype: >
struct<
phase_name string,
result string,
start_time timestamp,
end_time timestamp,
details variant
>
kind: table
volatility: pure
---
function:
name: database_replication_usage_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: database_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
database_name string,
credits_used string,
bytes_transferred bigint
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
---
function:
name: copy_history
parameters:
- datatype: string
name: table_name
- datatype: timestamp
name: start_time
optional-parameters:
- datatype: timestamp
name: end_time
returns:
datatype: >
struct<
file_name string,
stage_location string,
last_load_time timestamp,
row_count bigint,
row_parsed bigint,
file_size bigint,
first_error_message string,
first_error_line_number bigint,
first_error_character_pos bigint,
first_error_column_name string,
error_count bigint,
error_limit bigint,
status string,
table_catalog_name string,
table_schema_name string,
table_name string,
pipe_catalog_name string,
pipe_schema_name string,
pipe_name string,
pipe_received_time timestamp
>
kind: table
volatility: pure
---
function:
name: data_transfer_history
parameters: []
optional-parameters:
- datatype: date
name: date_range_start
- datatype: date
name: date_range_end
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
source_cloud string,
source_region string,
destination_cloud string,
destination_region string,
bytes_transferred bigint,
transfer_type string
>
kind: table
volatility: pure
---
function:
name: pipe_usage_history
parameters: []
optional-parameters:
- datatype: date
name: date_range_start
- datatype: date
name: date_range_end
- datatype: string
name: pipe_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
pipe_name string,
credits_used string,
bytes_inserted bigint,
files_inserted bigint
>
kind: table
volatility: pure
---
function:
name: validate_pipe_load
parameters:
- datatype: string
name: pipe_name
- datatype: timestamp
name: start_time
optional-parameters:
- datatype: timestamp
name: end_time
returns:
datatype: >
struct<
error string,
file string,
line bigint,
character bigint,
byte_offset bigint,
category string,
code bigint,
sql_state bigint,
column_name string,
row_number bigint,
row_start_line bigint,
rejected_record string
>
kind: table
volatility: pure
---
function:
name: validate
parameters:
- datatype: string
- datatype: string
name: job_id
returns:
datatype: >
struct<
error string,
file string,
line bigint,
character bigint,
byte_offset bigint,
category string,
code bigint,
sql_state bigint,
column_name string,
row_number bigint,
row_start_line bigint,
rejected_record string
>
kind: table
volatility: pure
---
function:
name: validate
parameters:
- datatype: string
name: job_id
returns:
datatype: >
struct<
error string,
file string,
line bigint,
character bigint,
byte_offset bigint,
category string,
code bigint,
sql_state bigint,
column_name string,
row_number bigint,
row_start_line bigint,
rejected_record string
>
kind: table
volatility: pure
---
function:
name: automatic_clustering_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: table_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
table_name string,
credits_used bigint,
num_bytes_reclustered bigint,
num_rows_reclustered bigint
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
---
function:
name: dynamic_table_graph_history
parameters: []
optional-parameters:
- datatype: timestamp
name: as_of
- datatype: timestamp
name: history_start
- datatype: timestamp
name: history_end
returns:
datatype: >
struct<
name string,
schema_name string,
database_name string,
qualified_name string,
inputs array,
target_lag_type string,
target_lag_sec bigint,
query_text string,
valid_from timestamp,
valid_to timestamp,
scheduling_state object
>
kind: table
volatility: pure
---
function:
name: dynamic_table_refresh_history
parameters: []
optional-parameters:
- datatype: timestamp
name: data_timestamp_start
- datatype: timestamp
name: data_timestamp_end
- datatype: bigint
name: result_limit
- datatype: string
name: name
- datatype: string
name: name_prefix
- datatype: boolean
name: error_only
returns:
datatype: >
struct<
name string,
schema_name string,
database_name string,
state string,
state_code string,
state_message string,
query_id string,
data_timestamp timestamp,
refresh_start_time timestamp,
refresh_end_time timestamp,
completion_target timestamp,
qualified_name string,
last_completed_dependency object,
statistics object,
refresh_action string,
refresh_trigger string
>
kind: table
volatility: pure
---
function:
name: external_functions_history
parameters: []
optional-parameters:
- datatype: timestamp
name: date_range_start
- datatype: timestamp
name: date_range_end
- datatype: string
name: function_signature
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
name string,
arguments string,
function_endpoint_url string,
source_cloud string,
source_region string,
target_cloud string,
target_region string,
invocations bigint,
sent_rows bigint,
received_rows bigint,
sent_bytes bigint,
received_bytes bigint
>
kind: table
volatility: pure
---
function:
name: auto_refresh_registration_history
parameters: []
optional-parameters:
- datatype: date
name: date_range_start
- datatype: date
name: date_range_end
- datatype: string
name: object_type
- datatype: string
name: object_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
object_name string,
object_type string,
credits_used bigint,
files_registered bigint
>
kind: table
volatility: pure
---
function:
name: external_table_files
parameters:
- datatype: string
name: table_name
returns:
datatype: >
struct<
file_name string,
registered_on timestamp,
file_size bigint,
last_modified timestamp,
etag string,
md5 string
>
kind: table
volatility: pure
---
function:
name: external_table_file_registration_history
parameters:
- datatype: string
name: table_name
optional-parameters:
- datatype: timestamp
name: start_time
returns:
datatype: >
struct<
job_created_time timestamp,
file_name string,
operation_status string,
message string,
file_size bigint,
last_modified timestamp
>
kind: table
volatility: pure
---
function:
name: materialized_view_refresh_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: materialized_view_name
returns:
datatype: struct<
start_time timestamp,
end_time timestamp,
credits_used string,
materialized_view_name string
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- string
- type-variable: $2
datatypes:
- date
- string
---
function:
name: notification_history
parameters: []
optional-parameters:
- datatype: timestamp
name: start_time
- datatype: timestamp
name: end_time
- datatype: string
name: integration_name
- datatype: bigint
name: result_limit
returns:
datatype: >
struct<
created timestamp,
processed timestamp,
message_source string,
integration_name string,
status string,
message string
>
kind: table
volatility: pure
---
function:
name: rest_event_history
parameters:
- datatype: string
name: rest_service_type
optional-parameters:
- datatype: timestamp
name: time_range_start
- datatype: timestamp
name: time_range_end
- datatype: bigint
name: result_limit
returns:
datatype: >
struct<
event_timestamp timestamp,
event_id bigint,
event_type string,
endpoint string,
method string,
status string,
error_code bigint,
details string,
client_ip string,
actor_name string,
actor_domain string,
resource_name string,
resource_domain string
>
kind: table
volatility: pure
---
function:
name: search_optimization_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: table_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
credits_used string,
table_name string
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
---
function:
name: generator
parameters: []
optional-parameters:
- datatype: bigint
name: rowcount
- datatype: bigint
name: timelimit
returns:
datatype: struct<dummy bigint>
kind: table
volatility: pure
---
function:
name: complete_task_graphs
parameters: []
optional-parameters:
- datatype: bigint
name: result_limit
- datatype: string
name: root_task_name
- datatype: boolean
name: error_only
returns:
datatype: >
struct<
root_task_name string,
database_name string,
schema_name string,
state string,
scheduled_from string,
first_error_task_name string,
first_error_code bigint,
first_error_message string,
scheduled_time timestamp,
query_start_time timestamp,
next_scheduled_time timestamp,
completed_time timestamp,
root_task_id string,
graph_version bigint,
run_id bigint,
attempt_number bigint,
config string,
graph_run_group_id bigint
>
kind: table
volatility: pure
---
function:
name: current_task_graphs
parameters: []
optional-parameters:
- datatype: bigint
name: result_limit
- datatype: string
name: root_task_name
returns:
datatype: >
struct<
root_task_name string,
database_name string,
schema_name string,
state string,
scheduled_from string,
first_error_task_name string,
first_error_code bigint,
first_error_message string,
scheduled_time timestamp,
query_start_time timestamp,
next_scheduled_time timestamp,
completed_time timestamp,
root_task_id string,
graph_version bigint,
run_id bigint,
attempt_number bigint,
config string,
graph_run_group_id bigint
>
kind: table
volatility: pure
---
function:
name: serverless_task_history
parameters: []
optional-parameters:
- datatype: $1
name: date_range_start
- datatype: $2
name: date_range_end
- datatype: string
name: task_name
returns:
datatype: >
struct<
start_time timestamp,
end_time timestamp,
task_name string,
credits_used string
>
kind: table
volatility: pure
binds:
- type-variable: $1
datatypes:
- timestamp
- string
- type-variable: $2
datatypes:
- timestamp
- string
---
function:
name: task_dependents
parameters:
- datatype: string
name: task_name
optional-parameters:
- datatype: boolean
name: recursive
returns:
datatype: >
struct<
created_on timestamp,
name string,
database_name string,
schema_name string,
owner string,
comment string,
warehouse string,
schedule string,
predecessors array,
state string,
definition string,
condition string
>
kind: table
volatility: pure
---
function:
name: task_history
parameters: []
optional-parameters:
- datatype: timestamp
name: scheduled_time_range_start
- datatype: timestamp
name: scheduled_time_range_end
- datatype: bigint
name: result_limit
- datatype: string
name: task_name
- datatype: boolean
name: error_only
returns:
datatype: >
struct<
query_id string,
name string,
database_name string,
schema_name string,
query_text string,
condition_text string,
state string,
error_code bigint,
error_message string,
scheduled_time timestamp,
query_start_time timestamp,
next_scheduled_time timestamp,
completed_time timestamp,
root_task_id string,
graph_version bigint,
run_id bigint,
attempt_number bigint,
config string,
query_hash string,
query_hash_version bigint,
query_parameterized_hash string,
query_parameterized_hash_version bigint,
graph_run_group_id bigint
>
kind: table
volatility: pure
---
function:
name: alert_history
parameters: []
optional-parameters:
- datatype: timestamp
name: scheduled_time_range_start
- datatype: timestamp
name: scheduled_time_range_end
- datatype: bigint
name: result_limit
- datatype: string
name: alert_name
returns:
datatype: >
struct<
name string,
database_name string,
schema_name string,
condition string,
condition_query_id string,
action string,
action_query_id string,
state string,
sql_error_code bigint,
sql_error_message string,
scheduled_time timestamp,
completed_time timestamp
>
kind: table
volatility: pure
---
function:
name: infer_schema
parameters: []
optional-parameters:
- datatype: string
name: location
- datatype: string
name: file_format
- datatype: string
name: files
- datatype: boolean
name: ignore_case
- datatype: bigint
name: max_file_count
- datatype: bigint
name: max_records_per_file
returns:
datatype: >
struct<
column_name string,
type string,
nullable boolean,
expression string,
filenames string,
order_id bigint
>
kind: table
volatility: pure
---
function:
name: array_construct
description: the resulting array
parameters:
- datatype: $1
- datatype: $2
optional-parameters: []
returns:
datatype: array
---
function:
name: array_construct
description: the resulting array
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
optional-parameters: []
returns:
datatype: array
---
function:
name: array_construct
description: the resulting array
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
- datatype: $4
optional-parameters: []
returns:
datatype: array
---
function:
name: array_construct
description: the resulting array
parameters:
- datatype: $1
- datatype: $2
- datatype: $3
- datatype: $4
- datatype: $5
optional-parameters: []
returns:
datatype: array
---
function:
name: get
description: Get VARIANT element value from an array or object
parameters:
- datatype: variant
- datatype: varchar
optional-parameters: []
returns:
datatype: variant
---
function:
name: get
description: Get VARIANT element value from an array or object
parameters:
- datatype: variant
- datatype: decimal(38, 0)
optional-parameters: []
returns:
datatype: variant
---
function:
name: get
description: Get VARIANT element value from an array or object
parameters:
- datatype: object
- datatype: varchar
optional-parameters: []
returns:
datatype: variant
---
function:
name: get
description: Get VARIANT element value from an array or object
parameters:
- datatype: array
- datatype: decimal(38, 0)
optional-parameters: []
returns:
datatype: variant
---
function:
name: get
description: Get VARIANT element value from an array or object
parameters:
- datatype: object
- datatype: $1
optional-parameters: []
returns:
datatype: variant
---
function:
name: "+"
description: Add two numbers
parameters:
- datatype: date
- datatype: bigint
returns:
datatype: date
---
function:
name: "+"
description: Add two numbers
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: $1
---
function:
name: "-"
description: Subtract two numbers
parameters:
- datatype: date
- datatype: bigint
returns:
datatype: date
---
function:
name: "-"
description: Subtract two numbers
parameters:
- datatype: date
- datatype: date
returns:
datatype: bigint
---
function:
name: "-"
parameters:
- datatype: $1
- datatype: $2
returns:
datatype: $1
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
- type-variable: $2
datatypes:
- interval
---
function:
name: "-"
description: Subtract two numbers
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: $1
---
function:
name: "*"
description: Multiply two numbers
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: $1
---
function:
name: "/"
description: Divide two numbers
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: $1
---
function:
name: timestampdiff
parameters:
- datatype: string
identifiers:
- year
- y
- yy
- yyy
- yyyy
- yr
- years
- yrs
- month
- mm
- mon
- mons
- months
- day
- d
- dd
- days
- dayofmonth
- dayofweek
- dayofyear
- yearday
- doy
- dy
- week
- w
- wk
- weekofyear
- woy
- wy
- weekofyeariso
- weekofyear_iso
- quarter
- q
- qtr
- qtrs
- quarters
- hour
- h
- hh
- hr
- hours
- hrs
- minute
- m
- mi
- min
- minutes
- mins
- second
- s
- sec
- seconds
- secs
- nanosecond
- ns
- nsec
- nanosec
- nsecond
- nanoseconds
- nanosecs
- nseconds
- datatype: $1
- datatype: $1
returns:
datatype: bigint
kind: scalar
volatility: pure
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
section: temporal
---
function:
name: max_by
description: Returns value of first column with maximum second column val
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
optional-parameters: []
returns:
datatype: $1
---
function:
name: max_by
description: Returns value of first column with maximum second column val
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
- datatype: decimal(38, 0)
optional-parameters: []
returns:
datatype: array
---
function:
name: min_by
description: Returns value of first column with minimum second column val
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
optional-parameters: []
returns:
datatype: $1
---
function:
name: min_by
description: Returns value of first column with minimum second column val
kind: aggregate
parameters:
- datatype: $1
- datatype: $2
- datatype: decimal(38, 0)
optional-parameters: []
returns:
datatype: array
---
function:
name: "+"
parameters:
- datatype: $1
- datatype: $2
returns:
datatype: $1
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
- type-variable: $2
datatypes:
- interval
---
function:
name: "+"
parameters:
- datatype: $2
- datatype: $1
returns:
datatype: $2
binds:
- type-variable: $1
datatypes:
- date
- time
- timestamp
- varchar
- type-variable: $2
datatypes:
- interval
---
function:
name: map_cat
parameters:
- datatype: object
- datatype: object
returns:
datatype: object
---
function:
name: map_contains_key
parameters:
- datatype: varchar
- datatype: object
returns:
datatype: boolean
---
function:
name: map_delete
parameters:
- datatype: object
- datatype: varchar
returns:
datatype: object
---
function:
name: map_delete
parameters:
- datatype: object
- datatype: varchar
- datatype: varchar
returns:
datatype: object
---
function:
name: map_delete
parameters:
- datatype: object
- datatype: varchar
- datatype: varchar
- datatype: varchar
returns:
datatype: object
---
function:
name: map_delete
parameters:
- datatype: object
- datatype: varchar
- datatype: varchar
- datatype: varchar
- datatype: varchar
returns:
datatype: object
---
function:
name: map_delete
parameters:
- datatype: object
- datatype: varchar
- datatype: varchar
- datatype: varchar
- datatype: varchar
- datatype: varchar
returns:
datatype: object
---
function:
name: map_insert
parameters:
- datatype: object
- datatype: $1
- datatype: $2
returns:
datatype: object
---
function:
name: map_insert
parameters:
- datatype: object
- datatype: $1
- datatype: $2
- datatype: boolean
returns:
datatype: object
---
function:
name: map_keys
parameters:
- datatype: object
returns:
datatype: array
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: string
returns:
datatype: object
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: string
- datatype: string
returns:
datatype: object
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: string
- datatype: string
- datatype: string
returns:
datatype: object
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: string
- datatype: string
- datatype: string
- datatype: string
returns:
datatype: object
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: string
- datatype: string
- datatype: string
- datatype: string
- datatype: string
returns:
datatype: object
---
function:
name: map_pick
parameters:
- datatype: object
- datatype: array
returns:
datatype: object
---
function:
name: map_size
parameters:
- datatype: object
returns:
datatype: bigint
---
function:
name: try_to_binary
parameters:
- datatype: $1
returns:
datatype: binary
---
function:
name: try_to_binary
parameters:
- datatype: string
- datatype: string
returns:
datatype: binary
---
function:
name: object_construct
variadic: any
parameters: []
returns:
datatype: object
---
function:
name: system$typeof
parameters:
- datatype: $1
returns:
datatype: varchar
---
function:
name: nullif
parameters:
- datatype: $1
- datatype: $1
returns:
datatype: $1
---
function:
name: ifnull
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: iff
description: Returns arg2 if arg1 is true, arg3 otherwise.
parameters:
- datatype: boolean
- datatype: $1
- datatype: $1
optional-parameters: []
returns:
datatype: $1
---
function:
name: dayname
parameters:
- datatype: $1
returns:
datatype: varchar
binds:
- type-variable: $1
datatypes:
- date
- string
---
function:
name: monthname
parameters:
- datatype: $1
returns:
datatype: varchar
binds:
- type-variable: $1
datatypes:
- date
- string
---
function:
name: next_day
parameters:
- datatype: $1
- datatype: varchar
returns:
datatype: date
binds:
- type-variable: $1
datatypes:
- date
- string
---
function:
name: previous_day
parameters:
- datatype: $1
- datatype: varchar
returns:
datatype: date
binds:
- type-variable: $1
datatypes:
- date
- string
---
function:
name: convert_timezone
description: Returns the input timestamp converted from source timezone to a destination timezone
parameters:
- datatype: varchar
- datatype: varchar
- datatype: $1
optional-parameters: []
returns:
datatype: timestamp
binds:
- type-variable: $1
datatypes:
- timestamp
- string
---
function:
name: convert_timezone
description: Returns the input timestamp converted from source timezone to a destination timezone
parameters:
- datatype: varchar
- datatype: $1
optional-parameters: []
returns:
datatype: timestamp
binds:
- type-variable: $1
datatypes:
- timestamp
- string
---
function:
name: grouping
kind: aggregate
variadic: any
parameters: []
returns:
datatype: int
---
function:
name: metadata$filename
kind: scalar
parameters: []
returns:
datatype: varchar
special: true
---
function:
name: metadata$file_row_number
kind: scalar
parameters: []
returns:
datatype: int
special: true
---
function:
name: metadata$file_content_key
kind: scalar
parameters: []
returns:
datatype: varchar
special: true
---
function:
name: metadata$file_last_modified
kind: scalar
parameters: []
returns:
datatype: timestamp
special: true
---
function:
name: metadata$start_scan_time
kind: scalar
parameters: []
returns:
datatype: timestamp
special: true
---
function:
name: "="
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "="
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "!="
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "!="
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<>"
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<>"
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<"
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<"
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: ">"
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: ">"
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<="
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "<="
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: ">="
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: ">="
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- bigint
- int
- smallint
- tinyint
- varchar
---
function:
name: "="
parameters:
- datatype: $1
- datatype: $2
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- varchar
- object
- type-variable: $2
datatypes:
- varchar
- object
---
function:
name: "!="
parameters:
- datatype: $1
- datatype: $2
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- varchar
- object
- type-variable: $2
datatypes:
- varchar
- object
---
function:
name: "sdf::and"
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- int
- double
---
function:
name: "sdf::and"
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- int
- double
---
function:
name: "sdf::or"
parameters:
- datatype: $1
- datatype: boolean
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- int
- double
---
function:
name: "sdf::or"
parameters:
- datatype: boolean
- datatype: $1
returns:
datatype: boolean
binds:
- type-variable: $1
datatypes:
- int
- double