--- 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> --- 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> --- 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 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 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 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 --- 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 --- 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 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 # 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 --- 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 # --- # 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 # --- # 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 --- 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 --- 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 # --- # 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 # --- # 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 --- 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 # --- # 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 --- 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 # --- # 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 --- 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 # --- # 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 --- 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 # --- # 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 --- 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 --- 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 --- 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 --- 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 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 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 # - struct # - array --- 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 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 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 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