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

This section describes the array functions for SQL supported in AWS Clean Rooms. 

**Topics**
+ [ARRAY function](array.md)
+ [ARRAY\_CONTAINS function](array_contains.md)
+ [ARRAY\_DISTINCT function](array_distinct.md)
+ [ARRAY\_EXCEPT function](array_except.md)
+ [ARRAY\_INTERSECT function](array_intersect.md)
+ [ARRAY\_JOIN function](array_join.md)
+ [ARRAY\_REMOVE function](array_remove.md)
+ [ARRAY\_UNION function](array_union.md)
+ [EXPLODE function](explode.md)
+ [FLATTEN function](flatten.md)