Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, 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/). 

# 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)