Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/) that was published on June 30, 2025. 

# Array functions
<a name="c_Array_Functions"></a>

Following, you can find a description for the array functions for SQL that Amazon Redshift supports to access and manipulate arrays.

**Topics**
+ [ARRAY function](r_array.md)
+ [ARRAY\_CONCAT function](r_array_concat.md)
+ [ARRAY\_CONTAINS function](array_contains.md)
+ [ARRAY\_DISTINCT function](array_distinct.md)
+ [ARRAY\_EXCEPT function](array_except.md)
+ [ARRAY\_FLATTEN function](array_flatten.md)
+ [ARRAY\_INTERSECTION function](array_intersection.md)
+ [ARRAY\_POSITION function](array_position.md)
+ [ARRAY\_POSITIONS function](array_positions.md)
+ [ARRAY\_SORT function](array_sort.md)
+ [ARRAY\_UNION function](array_union.md)
+ [ARRAYS\_OVERLAP function](arrays_overlap.md)
+ [GET\_ARRAY\_LENGTH function](get_array_length.md)
+ [SPLIT\_TO\_ARRAY function](split_to_array.md)
+ [SUBARRAY function](r_subarray.md)