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\$1CONCAT function](r_array_concat.md)
+ [ARRAY\$1CONTAINS function](array_contains.md)
+ [ARRAY\$1DISTINCT function](array_distinct.md)
+ [ARRAY\$1EXCEPT function](array_except.md)
+ [ARRAY\$1FLATTEN function](array_flatten.md)
+ [ARRAY\$1INTERSECTION function](array_intersection.md)
+ [ARRAY\$1POSITION function](array_position.md)
+ [ARRAY\$1POSITIONS function](array_positions.md)
+ [ARRAY\$1SORT function](array_sort.md)
+ [ARRAY\$1UNION function](array_union.md)
+ [ARRAYS\$1OVERLAP function](arrays_overlap.md)
+ [GET\$1ARRAY\$1LENGTH function](get_array_length.md)
+ [SPLIT\$1TO\$1ARRAY function](split_to_array.md)
+ [SUBARRAY function](r_subarray.md)