Link Search Menu Expand Document

ARRAY_SLICE

Returns a slice of the array based on the indicated offset and length.

Syntax

ARRAY_SLICE(<array>, <start>[, <length>])

Parameters

Parameter Description Supported input types
<array> The array of data to be sliced ARRAY
<start> Indicates starting point of the array slice INTEGER
<length> The length of the required slice INTEGER

Return Type

ARRAY of the same type as input array

Example

The following example slices the levels array to a different length:

SELECT
	ARRAY_SLICE([ 1, 2, 3, 4, 5 ], 1, 3) AS levels;

Returns: [1, 2, 3]