Amazon Redshift now supports nine new array functions for working with semi-structured data stored in the SUPER data type. The new functions include ARRAY_CONTAINS, ARRAY_DISTINCT, ARRAY_EXCEPT, ARRAY_INTERSECTION, ARRAY_POSITION, ARRAY_POSITIONS, ARRAY_SORT, ARRAY_UNION, and ARRAYS_OVERLAP, enabling you to search, compare, sort, and transform arrays directly within your SQL queries. Previously, performing these operations required writing complex custom PartiQL SQL logic.
These functions simplify complex data transformations and reduce query complexity by enabling sophisticated array operations in a single SQL statement. For example, you can use ARRAY_CONTAINS and ARRAY_POSITION for element lookup, ARRAY_INTERSECTION and ARRAY_EXCEPT for set operations, or ARRAY_SORT and ARRAY_DISTINCT to organize and deduplicate data. These functions are particularly valuable for applications involving nested data structures, event processing, and analytics workflows where data needs to be aggregated, filtered, or transformed at scale.
The new Amazon Redshift array functions are available in all AWS Regions, including the AWS GovCloud (US) Regions, where Amazon Redshift is available. To learn more, please visit our documentation.
Categories: marketing:marchitecture,general:use-case/database-and-data-warehouse,marketing:marchitecture/analytics,general:products/amazon-redshift
Source: Amazon Web Services
Latest Posts
- Announcing Region Expansion of P6-B200 instances on SageMaker Studio notebooks
- Microsoft Teams Town halls (Teams Premium): Upload custom backgrounds in Manage what attendees see [MC1307982]
- Microsoft 365 Copilot: Copilot chat pane and Summary feature in OneNote Mobile (iPhone) [MC1307979]
- ENA Express for Amazon EC2 instances now supports traffic between Availability Zones
