ELEMENT_AT (Array, Lakehouse v2)

Returns the element at a specified position in an array (1-indexed).

Analyze Syntax

func.element_at([10, 20, 30], 2)

Analyze Examples

func.element_at([10, 20, 30], 2)

┌────┐
│ 20 │
└────┘

SQL Syntax

ELEMENT_AT([10, 20, 30], 2)

SQL Examples

SELECT ELEMENT_AT([10, 20, 30], 2);

┌────┐
│ 20 │
└────┘