snowflake.snowpark.functions.array_slice¶
- snowflake.snowpark.functions.array_slice(array: ColumnOrName, from_: ColumnOrName, to: ColumnOrName) Column[source]¶
Returns an ARRAY constructed from a specified subset of elements of the input ARRAY.
- Parameters:
array – Column containing the source ARRAY.
from – Column containing a position in the source ARRAY. The position of the first element is 0. Elements from positions less than this parameter are not included in the resulting ARRAY.
to – Column containing a position in the source ARRAY. Elements from positions equal to or greater than this parameter are not included in the resulting array.
- Example::
>>> from snowflake.snowpark import Row >>> df = session.create_dataframe([Row(a=[1, 2, 3, 4, 5])]) >>> df.select(array_slice("a", lit(1), lit(3)).alias("result")).show() ------------ |"RESULT" | ------------ |[ | | 2, | | 3 | |] | ------------