Array Functions (Lakehouse v1)
This section provides reference information for the array functions in PlaidCloud Lakehouse.
Functions
Section titled “Functions”- ARRAYS_ZIP
- ARRAY_AGGREGATE
- ARRAY_APPEND
- ARRAY_APPLY
- ARRAY_CONCAT
- ARRAY_CONTAINS
- ARRAY_DISTINCT
- ARRAY_FILTER
- ARRAY_FLATTEN
- ARRAY_GET
- ARRAY_INDEXOF
- ARRAY_LENGTH
- ARRAY_PREPEND
- ARRAY_REDUCE
- ARRAY_REMOVE_FIRST
- ARRAY_REMOVE_LAST
- ARRAY_SIZE
- ARRAY_SLICE
- ARRAY_SORT
- ARRAY_TO_STRING
- ARRAY_TRANSFORM
- ARRAY_UNIQUE
- CONTAINS
- GET (Array, Lakehouse v1)
- RANGE
- SLICE
- UNNEST