ELEMENT_AT
Learn how to use the ELEMENT_AT array function in PlaidCloud Lakehouse. Returns the element at a specified position in an array (1-indexed).
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 │
└────┘