Bigquery Functions
JSON Functions
bool
Supported Signatures
function bool(json) returns bool
float64
Supported Signatures
function float64(json) returns double
int64
Supported Signatures
function int64(json) returns bigint
json_extract
Supported Signatures
function json_extract(string, string) returns json
json_extract_array
Supported Signatures
function json_extract_array(json) returns array<json>
function json_extract_array(json, string) returns array<json>
json_extract_scalar
Supported Signatures
function json_extract_scalar(json) returns string
function json_extract_scalar(json, string) returns string
json_extract_string_array
Supported Signatures
function json_extract_string_array(json) returns array<string>
function json_extract_string_array(json, string) returns array<string>
json_query
Supported Signatures
function json_query(json, string) returns json
json_query_array
Supported Signatures
function json_query_array(json, string) returns array<json>
function json_query_array(json) returns array<json>
json_type
Supported Signatures
function json_type(json) returns string
json_value
Supported Signatures
function json_value(json, string) returns string
function json_value(json) returns string
json_value_array
Supported Signatures
function json_value_array(json, string) returns array<string>
function json_value_array(json) returns array<string>
parse_json
Supported Signatures
function parse_json(string) returns json
string
Supported Signatures
function string $1($1) returns string
where $1 in (timestamp, json)
function string $1($1, time_zone string) returns string
where $1 in (timestamp, json)
to_json_string
Supported Signatures
function to_json_string($1) returns string
function to_json_string($1, pretty_print bool) returns string