The Array function returns an array containing specified values.

πŸ“˜

This function is currently supported by BigQuery, MySQL, PostgreSQL, Redshift, and Snowflake connections only.

Syntax

Array([values])

Function arguments

values

[optional] Comma-separated values used to construct the array.

Values can include a variety of input, including integers, strings, boolean values, columns, and results of function calls.

πŸ“˜

The Array function supports indexing using a zero-based indexing system. To retrieve a value in the array based on its position, append the index in square brackets directly following the function call. For a demonstration, see Example 3.

Examples

Example 1

Array(1, 2, 3)

Returns the array [1,2,3] as variant data.

Example 2

Array(1, "Hello", Today())

Returns the array [1,"Hello","2024-03-14 00:00:00.000 Z"] when the current date is March 14, 2024.

Example 3

Array("red", "orange", "yellow")[1]

Because the array has an index range from 0 to 2, [1] instructs Sigma to access the value in the second position, which returns "orange".