> ## 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.

# Array Functions

## `array_concat`

*Examples:*

```sql examples.sql theme={null}
SELECT ARRAY_CONCAT([1, 2], [3, 4], [5, 6]) as count_to_six; -- value '[1,2,3,4,5,6]'
```

*Supported Signatures*

```sql theme={null}
function array_concat(array<$1>, ...) returns array<$1>
```

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

## `array_length`

*Supported Signatures*

```sql theme={null}
function array_length(array<$1>) returns bigint
```

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

## `array_reverse`

*Supported Signatures*

```sql theme={null}
function array_reverse(array<$1>) returns array<$1>
```

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

## `array_to_string`

*Supported Signatures*

```sql theme={null}
function array_to_string(array<$1>, string) returns string
function array_to_string(array<$1>, string, string) returns string
```

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

## `generate_array`

*Supported Signatures*

```sql theme={null}
function generate_array $1($1, $1) returns array<int>
	where $1 in (bigint, double)
function generate_array $1($1, $1, $1) returns array<int>
	where $1 in (bigint, double)
```

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

## `generate_date_array`

*Supported Signatures*

```sql theme={null}
function generate_date_array(date, date) returns array[date]
function generate_date_array(date, date, interval) returns array[date]
```

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

## `generate_timestamp_array`

*Supported Signatures*

```sql theme={null}
function generate_timestamp_array $1, $2($1, $2, interval) returns array<timestamp>
	where $1 in (timestamp, string)
	and $2 in (timestamp, string)
```

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