> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# JSON Functions

## `bool`

*Supported Signatures*

```sql theme={null}
function bool(json) returns bool
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#bool)

## `float64`

*Supported Signatures*

```sql theme={null}
function float64(json) returns double
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#float64)

## `int64`

*Supported Signatures*

```sql theme={null}
function int64(json) returns bigint
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#int64)

## `json_extract`

*Supported Signatures*

```sql theme={null}
function json_extract(string, string) returns json
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_extract)

## `json_extract_array`

*Supported Signatures*

```sql theme={null}
function json_extract_array(json) returns array<json>
function json_extract_array(json, string) returns array<json>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_extract_array)

## `json_extract_scalar`

*Supported Signatures*

```sql theme={null}
function json_extract_scalar(json) returns string
function json_extract_scalar(json, string) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_extract_scalar)

## `json_extract_string_array`

*Supported Signatures*

```sql theme={null}
function json_extract_string_array(json) returns array<string>
function json_extract_string_array(json, string) returns array<string>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_extract_string_array)

## `json_query`

*Supported Signatures*

```sql theme={null}
function json_query(json, string) returns json
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_query)

## `json_query_array`

*Supported Signatures*

```sql theme={null}
function json_query_array(json, string) returns array<json>
function json_query_array(json) returns array<json>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_query_array)

## `json_type`

*Supported Signatures*

```sql theme={null}
function json_type(json) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_type)

## `json_value`

*Supported Signatures*

```sql theme={null}
function json_value(json, string) returns string
function json_value(json) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_value)

## `json_value_array`

*Supported Signatures*

```sql theme={null}
function json_value_array(json, string) returns array<string>
function json_value_array(json) returns array<string>
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#json_value_array)

## `parse_json`

*Supported Signatures*

```sql theme={null}
function parse_json(string) returns json
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#parse_json)

## `string`

*Supported Signatures*

```sql theme={null}
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)
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#string)

## `to_json_string`

*Supported Signatures*

```sql theme={null}
function to_json_string($1) returns string
function to_json_string($1, pretty_print bool) returns string
```

[🔗 Official Documentation](https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#to_json_string)