sql-functions 0.1.3

---
function:
  name: date_sub
  section: temporal
  kind: scalar
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
        - timestamp
---
function:
  name: strpos
  kind: scalar
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: bigint
---
function:
  name: is_nan
  kind: scalar
  parameters:
    - datatype: $1
  returns:
    datatype: bool
---
function:
  name: is_inf
  kind: scalar
  parameters:
    - datatype: $1
  returns:
    datatype: bool
---
function:
  name: bit_and
  kind: aggregate
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: logical_or
  kind: aggregate
  parameters:
    - datatype: bool
  returns:
    datatype: bool
---
function:
  name: logical_and
  kind: aggregate
  parameters:
    - datatype: bool
  returns:
    datatype: bool
---
function:
  name: any_value
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#any_value
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: approx_count_distinct
  section: approximate_aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_count_distinct
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: bigint
---
function:
  name: approx_quantiles
  section: approximate_aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_quantiles
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: bigint
  returns:
    datatype: array<$1>
---
function:
  name: approx_top_count
  section: approximate_aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_top_count
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: bigint
  returns:
    datatype: array<struct<value $1, count bigint>>
---
function:
  name: approx_top_sum
  section: approximate_aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/approximate_aggregate_functions#approx_top_sum
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: array<struct<value $1, sum $1>>
---
function:
  name: array_concat_agg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#array_concat_agg
  kind: aggregate
  parameters:
    - datatype: array<$1>
  returns:
    datatype: array<$1>
---
function:
  name: ifnull
  kind: scalar
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: reclassify
  kind: scalar
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: string
  returns:
    datatype: $1
  description:
    "Changes the classification label of the first argument from the expected
    classifier specified by the second argument to the desired classifier
    specified by the third. The expected and desired classifiers
    must belong to the same classifier group. No other classifiers attached to
    the first argument are impacted. The function will emit a warning if the
    the first argument does not have the expected classifier"
  examples:
    - input: select reclassify(12345, 'pii.clear_text', 'pii.masked') as value;
      output: "12345"
  section: other
---
function:
  name: reclassify
  kind: scalar
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: $1
  description: "Changes the classification label of the first argument
    to the desired classifier specified by the second argument. The first
    argument is expected to have one or more classifiers from the same
    classifier group as the desired classifier. All of these classifiers
    will be removed and replaced by the desired classifier. No other classifiers
    attached to the first argument will be impacted. The function will emit a warning
    if the first argument does not have a classifier from the expected classifier group"
  examples:
    - input: select reclassify(12345, 'pii.masked') as value;
      output: "12345"
  section: other
---
function:
  name: offset
  kind: scalar
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: ordinal
  kind: scalar
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: safe_offset
  kind: scalar
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: if
  section: other
  kind: scalar
  parameters:
    - datatype: bool
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: array_avg
  section: aggregate_functions
  kind: aggregate
  parameters:
    - datatype: array<$1>
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - int
        - bigint
        - float
        - double
---
function:
  name: array_avg
  kind: aggregate
  parameters:
    - datatype: array<decimal(p,s)>
  returns:
    datatype: decimal(p,s)
---
function:
  name: array_concat
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_concat
  kind: scalar
  variadic: uniform
  parameters:
    - datatype: array<$1>
  returns:
    datatype: array<$1>
  examples:
    - input: SELECT ARRAY_CONCAT([1, 2], [3, 4], [5, 6]) as count_to_six;
      output: "[1,2,3,4,5,6]"
---
function:
  name: array_agg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#array_agg
  kind: aggregate
  parameters:
    - datatype: $1 # All Data Types EXCEPT Array (which we currently cannot express without enumerating everything)
  returns:
    datatype: array<$1>
---
function:
  name: avg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#avg
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
        - interval
---
function:
  name: avg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#avg
  kind: aggregate
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: bit_and
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_and
  kind: aggregate
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: bit_or
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_or
  kind: aggregate
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: bit_xor
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#bit_xor
  kind: aggregate
  parameters:
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: count
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#count
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: bigint
---
function:
  name: countif
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#countif
  kind: aggregate
  parameters:
    - datatype: bool
  returns:
    datatype: bigint
---
function:
  name: logical_and
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#logical_and
  kind: aggregate
  parameters:
    - datatype: bool
  returns:
    datatype: bool
---
function:
  name: logical_or
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#logical_or
  kind: aggregate
  parameters:
    - datatype: bool
  returns:
    datatype: bool
---
function:
  name: max_by
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#max_by
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: $2
  returns:
    datatype: $1
---
function:
  name: min_by
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#min_by
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: $2
  returns:
    datatype: $1
---
function:
  name: string_agg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#string_agg
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: string_agg
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#string_agg
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: array_length
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_length
  parameters:
    - datatype: array<$1>
  returns:
    datatype: bigint
  kind: scalar
---
function:
  name: array_reverse
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_reverse
  parameters:
    - datatype: array<$1>
  returns:
    datatype: array<$1>
  kind: scalar
---
function:
  name: array_to_string
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_to_string
  parameters:
    - datatype: array<$1>
    - datatype: string
  returns:
    datatype: string
---
function:
  name: array_to_string
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#array_to_string
  parameters:
    - datatype: array<$1>
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: generate_array
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_array
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: array<int>
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: generate_array
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_array
  parameters:
    - datatype: $1
    - datatype: $1
    - datatype: $1
  returns:
    datatype: array<int>
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: generate_date_array
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_date_array
  parameters:
    - datatype: date
    - datatype: date
  returns:
    datatype: array<date>
---
function:
  name: generate_date_array
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_date_array
  parameters:
    - datatype: date
    - datatype: date
    - datatype: interval
  returns:
    datatype: array<date>
---
function:
  name: generate_timestamp_array
  section: array_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/array_functions#generate_timestamp_array
  parameters:
    - datatype: $1
    - datatype: $2
    - datatype: interval
  returns:
    datatype: array<timestamp>
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - string
    - type-variable: $2
      datatypes:
        - timestamp
        - string
---
function:
  name: bit_count
  section: bit_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/bit_functions#bit_count
  parameters:
    - datatype: $1
  returns:
    datatype: bigint
  binds:
    - type-variable: $1
      datatypes:
        - int
        - bytes
# ---
# function:
#   name: external_object_transform
#   section: table-functions-built-in
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/table-functions-built-in#external_object_transform
#   parameters:
#     - datatype: table
#     - datatype: array<string>
#   returns:
#     datatype: table
---
function:
  name: parse_bignumeric
  parameters:
    - datatype: string
  returns:
    datatype: decimal(76,38)
---
function:
  name: parse_numeric
  parameters:
    - datatype: string
  returns:
    datatype: decimal(38,9)
---
function:
  name: current_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#current_date
  parameters: []
  returns:
    datatype: date
  special: true
---
function:
  name: current_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#current_date
  parameters:
    - datatype: string
  returns:
    datatype: date
  special: true
---
function:
  name: date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: date
---
function:
  name: date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date
  parameters:
    - datatype: timestamp
  returns:
    datatype: date
---
function:
  name: date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date
  parameters:
    - datatype: timestamp
    - datatype: string
  returns:
    datatype: date
---
function:
  name: date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date
  parameters:
    - datatype: datetime
  returns:
    datatype: date
---
function:
  name: date_add
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_add
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
        - timestamp
---
function:
  name: date_diff
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_diff
  parameters:
    - datatype: $1
    - datatype: $1
    - name: date_part
      datatype: string
      identifiers:
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: bigint
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
        - timestamp
---
function:
  name: date_from_unix_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_from_unix_date
  parameters:
    - datatype: bigint
  returns:
    datatype: date
---
function:
  name: date_trunc
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#date_trunc
  parameters:
    - datatype: $1
    - name: date_part
      datatype: string
      identifiers:
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
        - timestamp
---
function:
  name: format_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#format_date
  parameters:
    - datatype: string
    - datatype: $1
  returns:
    datatype: string
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
        - timestamp
---
function:
  name: last_day
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#last_day
  parameters:
    - datatype: $1
  returns:
    datatype: date
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
---
function:
  name: last_day
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#last_day
  parameters:
    - datatype: $1
    - name: date_part
      datatype: string
      identifiers:
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: date
  binds:
    - type-variable: $1
      datatypes:
        - date
        - datetime
---
function:
  name: parse_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#parse_date
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: date
---
function:
  name: unix_date
  section: date_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#unix_date
  parameters:
    - datatype: date
  returns:
    datatype: bigint
---
function:
  name: current_datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#current_datetime
  parameters: []
  returns:
    datatype: datetime
  special: true
---
function:
  name: current_datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#current_datetime
  parameters:
    - datatype: string # TODO: Enumerate all timezones
  returns:
    datatype: datetime
  special: true
---
function:
  name: datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: datetime
---
function:
  name: datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime
  parameters:
    - datatype: date
  returns:
    datatype: datetime
---
function:
  name: datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime
  parameters:
    - datatype: date
    - datatype: time
  returns:
    datatype: datetime
---
function:
  name: datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime
  parameters:
    - datatype: timestamp
  returns:
    datatype: datetime
---
function:
  name: datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime
  parameters:
    - datatype: timestamp
    - datatype: string # TODO: Enumerate all timezones
  returns:
    datatype: datetime
---
function:
  name: datetime_add
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_add
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - datetime
        - timestamp
---
function:
  name: datetime_diff
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_diff
  parameters:
    - datatype: $1
    - datatype: $1
    - name: part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: bigint
  binds:
    - type-variable: $1
      datatypes:
        - datetime
        - timestamp
---
function:
  name: datetime_sub
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_sub
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - datetime
        - timestamp
---
function:
  name: datetime_trunc
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#datetime_trunc
  parameters:
    - datatype: $1
    - name: date_time_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - datetime
        - timestamp
---
function:
  name: format_datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#format_datetime
  parameters:
    - datatype: string
    - datatype: $1
  returns:
    datatype: string
  binds:
    - type-variable: $1
      datatypes:
        - datetime
        - timestamp
---
function:
  name: parse_datetime
  section: datetime_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/datetime_functions#parse_datetime
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: datetime
---
function:
  name: error
  section: debugging_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/debugging_functions#error
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: farm_fingerprint
  section: hash_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#farm_fingerprint
  parameters:
    - datatype: $1
  returns:
    datatype: bigint
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: md5
  section: hash_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#md5
  parameters:
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: sha1
  section: hash_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha1
  parameters:
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: sha256
  section: hash_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha256
  parameters:
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: sha512
  section: hash_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hash_functions#sha512
  parameters:
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: justify_days
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_days
  parameters:
    - datatype: interval
  returns:
    datatype: interval
---
function:
  name: justify_hours
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_hours
  parameters:
    - datatype: interval
  returns:
    datatype: interval
---
function:
  name: justify_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#justify_interval
  parameters:
    - datatype: interval
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: make_interval
  section: interval_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/interval_functions#make_interval
  parameters:
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: interval
---
function:
  name: bool
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#bool_for_json
  parameters:
    - datatype: json
  returns:
    datatype: bool
---
function:
  name: float64
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#float64_for_json
  parameters:
    - datatype: json
  optional-parameters:
    - datatype: string
      name: wide_number_mode
      identifiers:
        - exact
        - round
  returns:
    datatype: double
---
function:
  name: int64
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#int64_for_json
  parameters:
    - datatype: json
  returns:
    datatype: bigint
---
function:
  name: json_extract
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: json
# ---
# function:
#   name: json_extract
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: string
---
function:
  name: json_extract_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_array
  parameters:
    - datatype: json
  returns:
    datatype: array<json>
---
function:
  name: json_extract_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_array
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: array<json>
# ---
# function:
#   name: json_extract_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_array
#   parameters:
#     - datatype: string
#   returns:
#     datatype: array<string>
# ---
# function:
#   name: json_extract_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_array
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: json_extract_scalar
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_scalar
  parameters:
    - datatype: json
  returns:
    datatype: string
---
function:
  name: json_extract_scalar
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_scalar
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: string
# ---
# function:
#   name: json_extract_scalar
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_scalar
#   parameters:
#     - datatype: string
#   returns:
#     datatype: string
# ---
# function:
#   name: json_extract_scalar
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_scalar
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: string
---
function:
  name: json_extract_string_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_string_array
  parameters:
    - datatype: json
  returns:
    datatype: array<string>
---
function:
  name: json_extract_string_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_string_array
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: array<string>
# ---
# function:
#   name: json_extract_string_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_string_array
#   parameters:
#     - datatype: string
#   returns:
#     datatype: array<string>
# ---
# function:
#   name: json_extract_string_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_extract_string_array
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: json_query
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: json
# ---
# function:
#   name: json_query
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: string
---
function:
  name: json_query_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query_array
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: array<json>
# ---
# function:
#   name: json_query_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query_array
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: json_query_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query_array
  parameters:
    - datatype: json
  returns:
    datatype: array<json>
# ---
# function:
#   name: json_query_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_query_array
#   parameters:
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: json_type
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_type
  parameters:
    - datatype: json
  returns:
    datatype: string
---
function:
  name: json_value
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: string
# ---
# function:
#   name: json_value
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: string
---
function:
  name: json_value
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value
  parameters:
    - datatype: json
  returns:
    datatype: string
# ---
# function:
#   name: json_value
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value
#   parameters:
#     - datatype: string
#   returns:
#     datatype: string
---
function:
  name: json_value_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value_array
  parameters:
    - datatype: json
    - datatype: string
  returns:
    datatype: array<string>
# ---
# function:
#   name: json_value_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value_array
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: json_value_array
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value_array
  parameters:
    - datatype: json
  returns:
    datatype: array<string>
# ---
# function:
#   name: json_value_array
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#json_value_array
#   parameters:
#     - datatype: string
#   returns:
#     datatype: array<string>
---
function:
  name: parse_json
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#parse_json
  parameters:
    - datatype: string
  returns:
    datatype: json
# ---
# TODO: (Zhong) Handle PARSE_JSON(json_string_expr[, wide_number_mode=>{ 'exact' | 'round' }])
# function:
#   name: parse_json
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#parse_json
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: json
---
function:
  name: string
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#string_for_json
  parameters:
    - datatype: $1
  returns:
    datatype: string
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - json
---
function:
  name: string
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#string_for_json
  parameters:
    - datatype: $1
    - datatype: string
      name: time_zone
  returns:
    datatype: string
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - json
# ---
# TODO: (Zhong) Handle TO_JSON(sql_value[, stringify_wide_numbers=>{ TRUE | FALSE }])

# function:
#   name: to_json
#   section: json_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#to_json
#   parameters:
#     - datatype: string
#     - datatype: string
#   returns:
#     datatype: json
---
function:
  name: to_json_string
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#to_json_string
  parameters:
    - datatype: $1
  returns:
    datatype: string
---
function:
  name: to_json_string
  section: json_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions#to_json_string
  parameters:
    - datatype: $1
    - datatype: bool
      name: pretty_print
  returns:
    datatype: string
---
function:
  name: split
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#split
  parameters:
    - datatype: $1
  returns:
    datatype: array<$1>
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: split
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#split
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: array<$1>
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: st_geogpoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpoint
  parameters:
    - datatype: double
    - datatype: double
  returns:
    datatype: geography
---
function:
  name: st_contains
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_contains
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: s2_cellidfrompoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#s2_cellidfrompoint
  parameters:
    - datatype: geography
  optional-parameters:
    - datatype: bigint
      name: level
  returns:
    datatype: bigint
---
function:
  name: s2_coveringcellids
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#s2_coveringcellids
  parameters:
    - datatype: geography
  optional-parameters:
    - datatype: bigint
      name: min_level
    - datatype: bigint
      name: max_level
    - datatype: bigint
      name: max_cells
    - datatype: double
      name: buffer
  returns:
    datatype: array<bigint>
---
function:
  name: st_angle
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_angle
  parameters:
    - datatype: geography
    - datatype: geography
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_area
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_area
  parameters:
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_area
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_area
  parameters:
    - datatype: geography
    - datatype: bool
  returns:
    datatype: double
---
function:
  name: st_asbinary
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asbinary
  parameters:
    - datatype: geography
  returns:
    datatype: bytes
---
function:
  name: st_asgeojson
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_asgeojson
  parameters:
    - datatype: geography
  returns:
    datatype: string
---
function:
  name: st_astext
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_astext
  parameters:
    - datatype: geography
  returns:
    datatype: string
---
function:
  name: st_azimuth
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_azimuth
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_boundary
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_boundary
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_boundingbox
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_boundingbox
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_buffer
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_buffer
  parameters:
    - datatype: geography
    - datatype: double
  optional-parameters:
    - datatype: double
      name: num_seg_quarter_circle
    - datatype: bool
      name: use_spheroid
    - datatype: string
      name: endcap
      identifiers:
        - round
        - flat
    - datatype: string
      name: side
      identifiers:
        - both
        - left
        - right
  returns:
    datatype: geography
---
function:
  name: st_buffer
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_buffer
  parameters:
    - datatype: geography
    - datatype: double
    - datatype: double
  optional-parameters:
    - datatype: bool
      name: use_spheroid
    - datatype: string
      name: endcap
      identifiers:
        - round
        - flat
    - datatype: string
      name: side
      identifiers:
        - both
        - left
        - right
  returns:
    datatype: geography
---
function:
  name: st_bufferwithtolerance
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_bufferwithtolerance
  parameters:
    - datatype: geography
    - datatype: double
    - datatype: double
  optional-parameters:
    - datatype: bool
      name: use_spheroid
    - datatype: string
      name: endcap
      identifiers:
        - round
        - flat
    - datatype: string
      name: side
      identifiers:
        - both
        - left
        - right
---
function:
  name: st_centroid
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_centroid
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_centroid_agg
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_centroid_agg
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_closestpoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_closestpoint
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_closestpoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_closestpoint
  parameters:
    - datatype: geography
    - datatype: geography
    - datatype: bool
  returns:
    datatype: geography
---
function:
  name: st_clusterdbscan
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_clusterdbscan
  parameters:
    - datatype: geography
    - datatype: double
    - datatype: bigint
  returns:
    datatype: bigint
---
function:
  name: st_convexhull
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_convexhull
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_coveredby
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_coveredby
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_covers
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_covers
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_difference
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_difference
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_dimension
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dimension
  parameters:
    - datatype: geography
  returns:
    datatype: bigint
---
function:
  name: st_disjoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_disjoint
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_distance
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_distance
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_distance
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_distance
  parameters:
    - datatype: geography
    - datatype: geography
    - datatype: bool
  returns:
    datatype: double
---
function:
  name: st_dump
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dump
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_dump
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dump
  parameters:
    - datatype: geography
    - datatype: bigint
  returns:
    datatype: geography
---
function:
  name: st_dwithin
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_dwithin
  parameters:
    - datatype: geography
    - datatype: geography
    - datatype: double
  returns:
    datatype: bool
---
function:
  name: st_endpoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_endpoint
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_equals
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_equals
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
# ---
# function:
#   name: st_extent
#   section: geography_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_extent
#   parameters:
#     - datatype: geography
#   returns:
#     datatype: struct<xmin:double, ymin:double, xmax:double, ymax:double>
---
function:
  name: st_exteriorring
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_exteriorring
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_geogfrom
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfrom
  parameters:
    - datatype: string
  returns:
    datatype: geography
---
function:
  name: st_geogfrom
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfrom
  parameters:
    - datatype: bytes
  returns:
    datatype: geography
---
function:
  name: st_geogfromgeojson
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromgeojson
  parameters:
    - datatype: string
  optional-parameters:
    - datatype: bool
      name: make_valid
  returns:
    datatype: geography
---
function:
  name: st_geogfromtext
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromtext
  parameters:
    - datatype: string
    - datatype: bool
  returns:
    datatype: geography
---
function:
  name: st_geogfromtext
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromtext
  parameters:
    - datatype: string
  optional-parameters:
    - datatype: bool
      name: oriented
    - datatype: bool
      name: planar
    - datatype: bool
      name: make_valid
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromwkb
  parameters:
    - datatype: bytes
  returns:
    datatype: geography
---
function:
  name: st_geogfromwkb
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogfromwkb
  parameters:
    - datatype: string
  returns:
    datatype: geography
---
function:
  name: st_geogpointfromgeohash
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpointfromgeohash
  parameters:
    - datatype: string
  returns:
    datatype: geography
---
function:
  name: st_geogpointfromgeohash
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geogpointfromgeohash
  parameters:
    - datatype: string
    - datatype: double
    - datatype: double
  returns:
    datatype: geography
---
function:
  name: st_geohash
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geohash
  parameters:
    - datatype: geography
  returns:
    datatype: string
---
function:
  name: st_geohash
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geohash
  parameters:
    - datatype: geography
    - datatype: bigint
  returns:
    datatype: string
---
function:
  name: st_geometrytype
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_geometrytype
  parameters:
    - datatype: geography
  returns:
    datatype: string
---
function:
  name: st_interiorrings
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_interiorrings
  parameters:
    - datatype: geography
  returns:
    datatype: array<geography>
---
function:
  name: st_intersection
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersection
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_intersects
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersects
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_intersectsbox
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_intersectsbox
  parameters:
    - datatype: geography
    - datatype: double
    - datatype: double
    - datatype: double
    - datatype: double
  returns:
    datatype: bool
---
function:
  name: st_isclosed
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isclosed
  parameters:
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_iscollection
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_iscollection
  parameters:
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_isempty
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isempty
  parameters:
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_isring
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_isring
  parameters:
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_length
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_length
  parameters:
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_length
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_length
  parameters:
    - datatype: geography
    - datatype: bool
  returns:
    datatype: double
---
function:
  name: st_linelocatepoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_linelocatepoint
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_makeline
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makeline
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_makepolygon
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makepolygon
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_makepolygon
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makepolygon
  parameters:
    - datatype: geography
    - datatype: array<geography>
  returns:
    datatype: geography
---
function:
  name: st_makepolygonoriented
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_makepolygonoriented
  parameters:
    - datatype: array<geography>
  returns:
    datatype: geography
---
function:
  name: st_maxdistance
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_maxdistance
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_maxdistance
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_maxdistance
  parameters:
    - datatype: geography
    - datatype: geography
    - datatype: bool
  returns:
    datatype: double
---
function:
  name: st_npoints
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_npoints
  parameters:
    - datatype: geography
  returns:
    datatype: bigint
---
function:
  name: st_numgeometries
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_numpoints
  parameters:
    - datatype: geography
  returns:
    datatype: bigint
---
function:
  name: st_numpoints
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_numpoints
  parameters:
    - datatype: geography
  returns:
    datatype: bigint
---
function:
  name: st_perimeter
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_perimeter
  parameters:
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_perimeter
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_perimeter
  parameters:
    - datatype: geography
    - datatype: bool
  returns:
    datatype: double
---
function:
  name: st_pointn
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_pointn
  parameters:
    - datatype: geography
    - datatype: bigint
  returns:
    datatype: geography
---
function:
  name: st_simplify
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_simplify
  parameters:
    - datatype: geography
    - datatype: bigint
  returns:
    datatype: geography
---
function:
  name: st_snaptogrid
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_snaptogrid
  parameters:
    - datatype: geography
    - datatype: double
---
function:
  name: st_startpoint
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_snaptogrid
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_touches
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_touches
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_union
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_union
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_union_agg
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_union_agg
  parameters:
    - datatype: geography
  returns:
    datatype: geography
---
function:
  name: st_within
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_within
  parameters:
    - datatype: geography
    - datatype: geography
  returns:
    datatype: bool
---
function:
  name: st_x
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_x
  parameters:
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: st_y
  section: geography_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions#st_y
  parameters:
    - datatype: geography
  returns:
    datatype: double
---
function:
  name: abs
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#abs
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - float64
---
function:
  name: acos
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acos
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - double
        - bigint
        # - decimal(p,s)
---
function:
  name: acosh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#acosh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - double
        - bigint
        # - decimal(p,s)
---
function:
  name: asin
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asin
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - double
        - bigint
        # - decimal(p,s)
---
function:
  name: asinh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#asinh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - double
        - bigint
        # - decimal(p,s)
---
function:
  name: atan
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - double
        - bigint
        # - decimal(p,s)
---
function:
  name: atan2
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atan2
  parameters:
    - datatype: $1
    - datatype: $2
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
    - type-variable: $2
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: atanh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#atanh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: cbrt
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cbrt
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: ceil
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: ceil
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: ceiling
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceil
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: ceiling
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ceiling
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: cos
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cos
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: cosh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cosh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: cot
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#cot
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: coth
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#coth
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: csc
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csc
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: csch
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#csch
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: div
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
---
function:
  name: div
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: div
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: div
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: div
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
# ---
# function:
#   name: div
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: div
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#div
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: exp
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#exp
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: exp
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#exp
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: floor
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#floor
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: floor
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#floor
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: greatest
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#greatest
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
  variadic: uniform
---
function:
  name: ieee_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ieee_divide
  parameters:
    - datatype: $1
    - datatype: $2
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
    - type-variable: $2
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: is_inf
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_inf
  parameters:
    - datatype: $1
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: is_nan
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#is_nan
  parameters:
    - datatype: $1
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: least
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#least
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
  variadic: uniform
---
function:
  name: ln
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ln
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: ln
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#ln
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: log
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: log
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: log
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: log10
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log10
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: log10
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#log10
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: mod
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
---
function:
  name: mod
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: mod
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: mod
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: mod
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
# ---
# function:
#   name: mod
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: mod
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#mod
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: pow
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: pow
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: pow
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#pow
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: power
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: power
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: power
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#power
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: rand
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#rand
  parameters: []
  returns:
    datatype: double
---
function:
  name: range_bucket
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#range_bucket
  parameters:
    - datatype: $1
    - datatype: array<$1>
  returns:
    datatype: int64
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: $1
    - datatype: bigint
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: bigint
    - datatype: bigint
    - name: rounding_mode
      datatype: string
      identifiers:
        - round_half_even
        - round_half_away_from_zero
  returns:
    datatype: double
---
function:
  name: round
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#round
  parameters:
    - datatype: $1
    - datatype: bigint
    - name: rounding_mode
      datatype: string
      identifiers:
        - round_half_even
        - round_half_away_from_zero
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: safe_add
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: safe_add
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_add
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_add
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: safe_divide
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: safe_divide
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_divide
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_divide
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_multiply
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: safe_multiply
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: safe_multiply
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_multiply
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: safe_negate
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_negate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: decimal(p,s)
    - datatype: bigint
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: bigint
    - datatype: decimal(p,s)
  returns:
    datatype: decimal(p,s)
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: double
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: bigint
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: double
    - datatype: decimal(p,s)
  returns:
    datatype: double
---
function:
  name: safe_subtract
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
  parameters:
    - datatype: decimal(p,s)
    - datatype: double
  returns:
    datatype: double
# ---
# function:
#   name: safe_subtract
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
# ---
# function:
#   name: safe_subtract
#   section: mathematical_functions
#   cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#safe_subtract
#   parameters:
#     - datatype: decimal(p,s)
#     - datatype: decimal(p,s)
#   returns:
#     datatype: decimal(p,s)
---
function:
  name: sec
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sec
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: sech
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sech
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: sign
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sign
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: sin
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sin
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: sinh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sinh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: sqrt
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sqrt
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: sqrt
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#sqrt
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: tan
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tan
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: tanh
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#tanh
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - bigint
        # - decimal(p,s)
        - double
---
function:
  name: trunc
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc
  parameters:
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: trunc
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: trunc
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc
  parameters:
    - datatype: bigint
    - datatype: bigint
  returns:
    datatype: double
---
function:
  name: trunc
  section: mathematical_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/mathematical_functions#trunc
  parameters:
    - datatype: $1
    - datatype: bigint
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        # - decimal(p,s)
        - double
---
function:
  name: search
  section: search_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/search_functions#search
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: bool
  optional-parameters:
    - datatype: string
      name: json_scope
      identifiers:
        - json_keys
        - json_values
        - json_keys_and_values
    - datatype: string
      name: analyzer
      identifiers:
        - log_analyzer
        - no_op_analyzer
  binds:
    - type-variable: $1
      datatypes:
        - string
        - json
        - array<string>
        # - struct
        # - array<struct>
---
function:
  name: session_user
  section: security_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/security_functions#session_user
  parameters: []
  returns:
    datatype: string
---
function:
  name: variance
  section: statistical_aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#var_samp
  parameters:
    - datatype: $1
  returns:
    datatype: double
  binds:
    - type-variable: $1
      datatypes:
        - int64
        # - decimal(p,s)
        - double
---
function:
  name: byte_length
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#byte_length
  parameters:
    - datatype: $1
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: code_points_to_bytes
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#code_points_to_bytes
  parameters:
    - datatype: array<int64>
  returns:
    datatype: bytes
---
function:
  name: code_points_to_string
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#code_points_to_string
  parameters:
    - datatype: array<int64>
  returns:
    datatype: string
---
function:
  name: collate
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#collate
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: contains_substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#contains_substr
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bigint
        - bool
        # - decimal(p,s)
        - timestamp
        - time
        - date
        - datetime
---
function:
  name: contains_substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#contains_substr
  parameters:
    - datatype: array<$1>
    - datatype: string
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bigint
        - bool
        # - decimal(p,s)
        - timestamp
        - time
        - date
        - datetime
---
function:
  name: ends_with
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ends_with
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
    - datatype: $1
  returns:
    datatype: string
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
    - datatype: $1
    - datatype: $2
  returns:
    datatype: string
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
    - datatype: $1
    - datatype: $2
    - datatype: $3
  returns:
    datatype: string
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
    - datatype: $1
    - datatype: $2
    - datatype: $3
    - datatype: $4
  returns:
    datatype: string
---
function:
  name: format
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#format
  parameters:
    - datatype: string
    - datatype: $1
    - datatype: $2
    - datatype: $3
    - datatype: $4
    - datatype: $5
  returns:
    datatype: string
---
function:
  name: from_base32
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_base32
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: from_base64
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_base64
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: from_hex
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#from_hex
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: initcap
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#initcap
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: initcap
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#initcap
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#instr
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: int64
---
function:
  name: instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#instr
  parameters:
    - datatype: string
    - datatype: string
    - datatype: int64
  returns:
    datatype: int64
---
function:
  name: instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#instr
  parameters:
    - datatype: string
    - datatype: string
    - datatype: int64
    - datatype: int64
  returns:
    datatype: int64
---
function:
  name: left
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#left
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: length
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#length
  parameters:
    - datatype: $1
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: normalize_and_casefold
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#normalize_and_casefold
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: normalize_and_casefold
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#normalize_and_casefold
  parameters:
    - datatype: string
    - name: normalization_mode
      datatype: string
      identifiers:
        - nfc
        - nfd
        - nfkc
        - nfkd
  returns:
    datatype: string
---
function:
  name: octet_length
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#octet_length
  parameters:
    - datatype: $1
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_contains
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_contains
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: bool
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_extract
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_extract
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_extract
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: int64
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_extract_all
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_extract_all
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: array<$1>
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_instr
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_instr
  parameters:
    - datatype: $1
    - datatype: $1
    - datatype: int64
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_instr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_instr
  parameters:
    - datatype: $1
    - datatype: $1
    - datatype: int64
    - datatype: int64
    - datatype: int64
  returns:
    datatype: int64
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_replace
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_replace
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: string
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr
  parameters:
    - datatype: $1
    - datatype: string
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: regexp_substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#regexp_substr
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: int64
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: repeat
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#repeat
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: replace
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#replace
  parameters:
    - datatype: $1
    - datatype: string
    - datatype: string
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: reverse
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#reverse
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: right
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#right
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: safe_convert_bytes_to_string
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#safe_convert_bytes_to_string
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: soundex
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#soundex
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: substring
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substring
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: substring
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substring
  parameters:
    - datatype: $1
    - datatype: int64
    - datatype: int64
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: to_base32
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_base32
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: to_base64
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_base64
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: to_code_points
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_code_points
  parameters:
    - datatype: $1
  returns:
    datatype: array<int64>
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: to_hex
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#to_hex
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: translate
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#translate
  parameters:
    - datatype: $1
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: unicode
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#unicode
  parameters:
    - datatype: string
  returns:
    datatype: int64
---
function:
  name: generate_uuid
  section: utility_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/utility-functions#generate_uuid
  parameters: []
  returns:
    datatype: string
---
function:
  name: current_time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#current_time
  parameters: []
  returns:
    datatype: time
  special: true
---
function:
  name: current_time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#current_time
  parameters:
    - datatype: string
      name: time_zone
  returns:
    datatype: time
  special: true
---
function:
  name: format_time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#format_time
  parameters:
    - datatype: string
    - datatype: time
  returns:
    datatype: string
---
function:
  name: parse_time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#parse_time
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: time
---
function:
  name: time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time
  parameters:
    - datatype: int64
    - datatype: int64
    - datatype: int64
  returns:
    datatype: time
---
function:
  name: time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time
  parameters:
    - datatype: timestamp
  returns:
    datatype: time
---
function:
  name: time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time
  parameters:
    - datatype: timestamp
    - datatype: string
      name: time_zone
  returns:
    datatype: time
---
function:
  name: time
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_add
  parameters:
    - datatype: datetime
  returns:
    datatype: time
---
function:
  name: time_add
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_add
  parameters:
    - datatype: time
    - datatype: interval microsecond to hour
  returns:
    datatype: time
---
function:
  name: time_diff
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_diff
  parameters:
    - datatype: time
    - datatype: time
    - name: date_time_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
  returns:
    datatype: bigint
---
function:
  name: time_sub
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_sub
  parameters:
    - datatype: time
    - datatype: interval microsecond to hour
  returns:
    datatype: time
---
function:
  name: time_trunc
  section: time_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/time_functions#time_trunc
  parameters:
    - datatype: time
    - name: time_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
  returns:
    datatype: time
---
function:
  name: current_timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#current_timestamp
  parameters: []
  returns:
    datatype: timestamp
  special: true
---
function:
  name: format_timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#format_timestamp
  parameters:
    - datatype: string
    - datatype: $1
  returns:
    datatype: string
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - datetime
---
function:
  name: format_timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#format_timestamp
  parameters:
    - datatype: string
    - datatype: timestamp
    - datatype: string
      name: time_zone
  returns:
    datatype: string
---
function:
  name: parse_timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#parse_timestamp
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: timestamp
---
function:
  name: parse_timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#parse_timestamp
  parameters:
    - datatype: string
    - datatype: string
    - datatype: string
      name: time_zone
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: string
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: string
    - datatype: string
      name: time_zone
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: date
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: date
    - datatype: string
      name: time_zone
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: datetime
  returns:
    datatype: timestamp
---
function:
  name: timestamp
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp
  parameters:
    - datatype: datetime
    - datatype: string
      name: time_zone
  returns:
    datatype: timestamp
---
function:
  name: timestamp_add
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_add
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - datetime
---
function:
  name: timestamp_diff
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_diff
  parameters:
    - datatype: $1
    - datatype: $1
    - name: date_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
        - day
        - week
        - month
        - quarter
        - year
  returns:
    datatype: bigint
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - datetime
---
function:
  name: timestamp_micros
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_micros
  parameters:
    - datatype: int64
  returns:
    datatype: timestamp
---
function:
  name: timestamp_millis
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_millis
  parameters:
    - datatype: int64
  returns:
    datatype: timestamp
---
function:
  name: timestamp_seconds
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_seconds
  parameters:
    - datatype: int64
  returns:
    datatype: timestamp
---
function:
  name: timestamp_sub
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_sub
  parameters:
    - datatype: $1
    - datatype: interval
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - datetime
---
function:
  name: timestamp_trunc
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc
  parameters:
    - datatype: $1
    - name: date_time_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - timestamp
        - datetime
---
function:
  name: timestamp_trunc
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#timestamp_trunc
  parameters:
    - datatype: timestamp
    - name: date_time_part
      datatype: string
      identifiers:
        - microsecond
        - millisecond
        - second
        - minute
        - hour
        - day
        - week
        - week(monday)
        - week(tuesday)
        - week(wednesday)
        - week(thursday)
        - week(friday)
        - week(saturday)
        - week(sunday)
        - isoweek
        - month
        - quarter
        - year
        - isoyear
    - datatype: string
      name: time_zone
  returns:
    datatype: timestamp
---
function:
  name: unix_micros
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_micros
  parameters:
    - datatype: timestamp
  returns:
    datatype: int64
---
function:
  name: unix_millis
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_millis
  parameters:
    - datatype: timestamp
  returns:
    datatype: int64
---
function:
  name: unix_seconds
  section: timestamp_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/timestamp_functions#unix_seconds
  parameters:
    - datatype: timestamp
  returns:
    datatype: int64
---
function:
  name: hll_count.extract
  section: hll_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countextract
  parameters:
    - datatype: bytes
  returns:
    datatype: int64
---
function:
  name: hll_count.init
  section: hll_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countinit
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - int64
        # - decimal(p,s)
        - string
        - bytes
---
function:
  name: hll_count.init
  section: hll_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countinit
  kind: aggregate
  parameters:
    - datatype: $1
    - datatype: bigint
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - int64
        # - decimal(p,s)
        - string
        - bytes
---
function:
  name: hll_count.merge
  section: hll_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countmerge
  kind: aggregate
  parameters:
    - datatype: bytes
  returns:
    datatype: int64
---
function:
  name: hll_count.merge_partial
  section: hll_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions#hll_countmergepartial
  kind: aggregate
  parameters:
    - datatype: bytes
  returns:
    datatype: bytes
---
function:
  name: aead.decrypt_bytes
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeaddecrypt_bytes
  parameters:
    - datatype: bytes
    - datatype: bytes
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
---
function:
  name: aead.decrypt_string
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeaddecrypt_string
  parameters:
    - datatype: bytes
    - datatype: $1
    - datatype: $2
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
    - type-variable: $2
      datatypes:
        - bytes
        - string
---
function:
  name: aead.encrypt
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#aeadencrypt
  parameters:
    - datatype: bytes
    - datatype: $1
    - datatype: $2
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
    - type-variable: $2
      datatypes:
        - bytes
        - string
---
function:
  name: deterministic_decrypt_bytes
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_decrypt_bytes
  parameters:
    - datatype: bytes
    - datatype: bytes
    - datatype: $1
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
---
function:
  name: deterministic_decrypt_string
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_decrypt_string
  parameters:
    - datatype: bytes
    - datatype: $1
    - datatype: $2
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
    - type-variable: $2
      datatypes:
        - bytes
        - string
---
function:
  name: deterministic_encrypt
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#deterministic_encrypt
  parameters:
    - datatype: bytes
    - datatype: $1
    - datatype: $2
  returns:
    datatype: bytes
  binds:
    - type-variable: $1
      datatypes:
        - bytes
        - string
    - type-variable: $2
      datatypes:
        - bytes
        - string
---
function:
  name: keys.add_key_from_raw_bytes
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysadd_key_from_raw_bytes
  parameters:
    - datatype: bytes
    - datatype: string
      identifiers:
        - aes_cbc_pkcs
        - aes_gcm
    - datatype: bytes
  returns:
    datatype: bytes
---
function:
  name: keys.keyset_chain
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_chain
  parameters:
    - datatype: string
    - datatype: bytes
  returns:
    datatype: string # This returns a struct
---
function:
  name: keys.keyset_from_json
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_from_json
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: keys.keyset_length
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_length
  parameters:
    - datatype: bytes
  returns:
    datatype: int64
---
function:
  name: keys.keyset_to_json
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keyskeyset_to_json
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: keys.new_keyset
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysnew_keyset
  parameters:
    - datatype: string
      identifiers:
        - aead_aes_gcm_256
        - deterministic_aead_aes_siv_cmac_256
  returns:
    datatype: bytes
---
function:
  name: keys.new_wrapped_keyset
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysnew_wrapped_keyset
  parameters:
    - datatype: string
    - datatype: string
      identifiers:
        - aead_aes_gcm_256
        - deterministic_aead_aes_siv_cmac_256
  returns:
    datatype: bytes
---
function:
  name: keys.rewrap_keyset
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrewrap_keyset
  parameters:
    - datatype: string
    - datatype: string
    - datatype: bytes
  returns:
    datatype: bytes
---
function:
  name: keys.rotate_keyset
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrotate_keyset
  parameters:
    - datatype: bytes
    - datatype: string
      identifiers:
        - aead_aes_gcm_256
        - deterministic_aead_aes_siv_cmac_256
  returns:
    datatype: bytes
---
function:
  name: keys.rotate_wrapped_keyset
  section: aead_encryption_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead_encryption_functions#keysrotate_wrapped_keyset
  parameters:
    - datatype: string
    - datatype: bytes
    - datatype: string
      identifiers:
        - aead_aes_gcm_256
        - deterministic_aead_aes_siv_cmac_256
  returns:
    datatype: bytes
---
function:
  name: net.host
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#nethost
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: net.ip_from_string
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_from_string
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: net.ip_net_mask
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_net_mask
  parameters:
    - datatype: int64
    - datatype: int64
  returns:
    datatype: bytes
---
function:
  name: net.ip_to_string
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_to_string
  parameters:
    - datatype: bytes
  returns:
    datatype: string
---
function:
  name: net.ip_trunc
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netip_trunc
  parameters:
    - datatype: bytes
    - datatype: int64
  returns:
    datatype: bytes
---
function:
  name: net.ipv4_from_int64
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netipv4_from_int64
  parameters:
    - datatype: int64
  returns:
    datatype: bytes
---
function:
  name: net.ipv4_to_int64
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netipv4_to_int64
  parameters:
    - datatype: bytes
  returns:
    datatype: int64
---
function:
  name: net.public_suffix
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netpublic_suffix
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: net.reg_domain
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netreg_domain
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: net.safe_ip_from_string
  section: net_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/net_functions#netsafe_ip_from_string
  parameters:
    - datatype: string
  returns:
    datatype: bytes
---
function:
  name: max
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#max
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: min
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#min
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: sum
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#sum
  kind: aggregate
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: ascii
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ascii
  parameters:
    - datatype: string
  returns:
    datatype: int64
---
function:
  name: char_length
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#char_length
  parameters:
    - datatype: string
  returns:
    datatype: int64
---
function:
  name: character_length
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#character_length
  parameters:
    - datatype: string
  returns:
    datatype: int64
---
function:
  name: chr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#chr
  parameters:
    - datatype: int64
  returns:
    datatype: string
---
function:
  name: concat
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#concat
  variadic: uniform
  parameters:
    - datatype: $1
  returns:
    datatype: $1
  binds:
    - type-variable: $1
      datatypes:
        - string
        - bytes
---
function:
  name: corr
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#corr
  kind: aggregate
  parameters:
    - datatype: float64
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: covar_pop
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#covar_pop
  kind: aggregate
  parameters:
    - datatype: float64
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: covar_samp
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#covar_samp
  kind: aggregate
  parameters:
    - datatype: float64
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: lower
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#lower
  parameters:
    - datatype: string
  returns:
    datatype: string  
---
function:
  name: lpad
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#lpad
  parameters:
    - datatype: string
    - datatype: int64
    - datatype: string
  returns:
    datatype: string
---
function:
  name: lpad
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#lpad
  parameters:
    - datatype: string
    - datatype: int64
  returns:
    datatype: string
---
function:
  name: ltrim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ltrim
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: ltrim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#ltrim
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: trim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#trim
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: trim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#trim
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: rpad
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rpad
  parameters:
    - datatype: string
    - datatype: int64
    - datatype: string
  returns:
    datatype: string
---
function:
  name: rpad
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rpad
  parameters:
    - datatype: string
    - datatype: int64
  returns:
    datatype: string
---
function:
  name: rtrim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rtrim
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: rtrim
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#rtrim
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: string
---
function:
  name: starts_with
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#starts_with
  parameters:
    - datatype: string
    - datatype: string
  returns:
    datatype: bool
---
function:
  name: stddev_pop
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#stddev_pop
  kind: aggregate
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: stddev_samp
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#stddev_samp
  kind: aggregate
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substr
  parameters:
    - datatype: string
    - datatype: int64
  returns:
    datatype: string
---
function:
  name: substr
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#substr
  parameters:
    - datatype: string
    - datatype: int64
    - datatype: int64
  returns:
    datatype: string
---
function:
  name: upper
  section: string_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#upper
  parameters:
    - datatype: string
  returns:
    datatype: string
---
function:
  name: var_pop
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#var_pop
  kind: aggregate
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: var_samp
  section: aggregate_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/statistical_aggregate_functions#var_samp
  kind: aggregate
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: row_number
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#row_number
  kind: window
  parameters: []
  returns:
    datatype: int64
---
function:
  name: rank
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#rank
  kind: window
  parameters: []
  returns:
    datatype: int64
---
function:
  name: dense_rank
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#dense_rank
  kind: window
  parameters: []
  returns:
    datatype: int64
---
function:
  name: percent_rank
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#percent_rank
  kind: window
  parameters: []
  returns:
    datatype: float64
---
function:
  name: cume_dist
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#cume_dist
  kind: window
  parameters: []
  returns:
    datatype: float64
---
function:
  name: ntile
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/numbering_functions#ntile
  kind: window
  parameters:
    - datatype: int64
  returns:
    datatype: int64
---
function:
  name: lead
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lead
  kind: window
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: lead
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lead
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
---
function:
  name: lead
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lead
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: lag
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lag
  kind: window
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: lag
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lag
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
---
function:
  name: lag
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#lag
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: first_value
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#first_value
  kind: window
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: last_value
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#last_value
  kind: window
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: nth_value
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#nth_value
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
  returns:
    datatype: $1
---
function:
  name: nth_value
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#nth_value
  kind: window
  parameters:
    - datatype: $1
    - datatype: int64
    - datatype: bool
  returns:
    datatype: $1
---
function:
  name: percentile_cont
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_cont
  kind: window
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: percentile_cont
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_cont
  kind: window
  parameters:
    - datatype: float64
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: percentile_cont
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_cont
  kind: window
  parameters:
    - datatype: float64
    - datatype: float64
    - datatype: boolean
  returns:
    datatype: float64
---
function:
  name: percentile_disc
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_disc
  kind: window
  parameters:
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: percentile_disc
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_disc
  kind: window
  parameters:
    - datatype: float64
    - datatype: float64
  returns:
    datatype: float64
---
function:
  name: percentile_disc
  section: window_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/navigation_functions#percentile_disc
  kind: window
  parameters:
    - datatype: float64
    - datatype: float64
    - datatype: boolean
  returns:
    datatype: float64
---
function:
  name: nullif
  section: null_handling_functions
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#nullif
  parameters:
    - datatype: $1
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: coalesce
  cross-link: https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#coalesce
  variadic: uniform
  parameters:
    - datatype: $1
  returns:
    datatype: $1
---
function:
  name: week
  parameters:
    - datatype: string
      identifiers:
        - sunday
        - monday
        - tuesday
        - wednesday
        - thursday
        - friday
        - saturday
  returns:
    datatype: string
---
function:
  name: grouping
  kind: aggregate
  variadic: any
  parameters: []
  returns: 
    datatype: int