Our Blog

Amazon Redshift introduces new array functions for semi-structured data processing

Published
March 6, 2026
https://aws.amazon.com/about-aws/whats-new/2026/03/amazon-redshift-nine-new-array-functions/

Amazon Redshift Array Functions Update

Amazon Redshift now supports nine new array functions for working with semi-structured data stored in the SUPER data type. These functions include ARRAY_CONTAINS, ARRAY_DISTINCT, ARRAY_EXCEPT, ARRAY_INTERSECTION, ARRAY_POSITION, ARRAY_POSITIONS, ARRAY_SORT, ARRAY_UNION, and ARRAYS_OVERLAP. They enable you to search, compare, sort, and transform arrays directly within your SQL queries, simplifying complex data transformations and reducing query complexity.

What to do

  • Explore the new array functions in your SQL queries.
  • Utilize these functions for element lookup, set operations, and data organization.
  • Leverage these capabilities for applications involving nested data structures, event processing, and analytics workflows.

Source: AWS release notes




If you need further guidance on AWS, our experts are available at AWS@westloop.io. You may also reach us by submitting the Contact Us form.

Follow our blog

Get the latest insights and advice on AWS services from our experts.

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Related posts

Check out other insights from the team at West Loop Strategy.

View all
https://aws.amazon.com/about-aws/whats-new/2025/10/aws-pcs-slurm-node-reboot/

AWS Parallel Computing Service (PCS) now supports node reboot via Slurm

AWS Parallel Computing Service (PCS) now allows you to reboot compute nodes using Slurm commands without triggering instance replacement
Read more
https://aws.amazon.com/about-aws/whats-new/2026/01/microsoft-office-visio-project-2024-amazon-workspaces/

Microsoft Office, Visio and Project 2024 Apps now on Amazon WorkSpaces

Today, Amazon WorkSpaces Personal and Core announce the availability of new Microsoft productivity applications for WorkSpaces instances, including Microsoft Office LTSC Professional Plus 2024, Microsoft Office LTSC Standard 2024, Microsoft Visio LTSC Professional 2024, Microsoft Visio LTSC Standard 2024, Microsoft Project Professional 2024 and Microsoft Project Standard 2024
Read more
https://aws.amazon.com/about-aws/whats-new/2025/10/amazon-nova-multimodal-embeddings/

Announcing Amazon Nova Multimodal Embeddings

We are excited to announce the general availability of Amazon Nova Multimodal Embeddings, a state-of-the-art embedding model for agentic RAG and semantic search
Read more
View all