Amazon Redshift introduces new array functions for semi-structured data processing
News
This article announces nine new array functions for Amazon Redshift to process semi-structured data stored in the SUPER data type.
- New functions: ARRAY_CONTAINS, ARRAY_DISTINCT, ARRAY_EXCEPT, ARRAY_INTERSECTION, ARRAY_POSITION, ARRAY_POSITIONS, ARRAY_SORT, ARRAY_UNION, ARRAYS_OVERLAP
- Enable searching, comparing, sorting, and transforming arrays directly in SQL queries
- Eliminate need for complex custom PartiQL SQL logic
- Simplify data transformations and reduce query complexity
- Ideal for nested data structures, event processing, and analytics workflows
- Available in all AWS Regions including GovCloud
These new array functions streamline semi-structured data processing in Redshift by providing native SQL operations for complex array manipulations.
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Mar 18
2026
2026
Amazon Redshift increases performance for new queries in dashboards and ETL workloads by up to 7x
Apr 14
2026
2026
Amazon Redshift introduces key performance optimization for Top-K queries
Feb 9
2026
2026
Amazon Redshift now supports allocating extra compute for automatic optimizations
Jan 27
2026
2026
Analyze JSON data efficiently with Amazon Redshift SUPER
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.