Amazon Redshift Adds Nine Array Functions for SUPER
🧩 Amazon Redshift now supports nine new array functions for the SUPER data type — ARRAY_CONTAINS, ARRAY_DISTINCT, ARRAY_EXCEPT, ARRAY_INTERSECTION, ARRAY_POSITION, ARRAY_POSITIONS, ARRAY_SORT, ARRAY_UNION, and ARRAYS_OVERLAP. These functions enable searching, comparing, sorting, and transforming arrays directly in SQL, reducing the need for custom PartiQL logic. They simplify nested-data analytics and are available in all AWS Regions, including GovCloud.
