Subscript operator [ ]

This function isn’t in the updated function reference yet. The details below come from the previous docs, and the product team is confirming them.

Syntax

SUBSCRIPT OPERATOR [] The Subscript operator is used to access the elements of an array. The index starts with 1

> select a[1] from (select array[1,2,3] as a)
1

Last modified on November 3, 2026