Our Blog

Amazon Redshift announces support for the SUPER data type in Databases with Case-Insensitive Collation

Published
November 18, 2025
https://aws.amazon.com/about-aws/whats-new/2025/11/amazon-redshift-super-data-type-databases/

Amazon Redshift

Amazon Redshift now supports the SUPER data type in databases with case insensitive collation, enabling analytics on semi-structured and nested data in these databases. Using the SUPER data type with PartiQL in Amazon Redshift, you can perform advanced analytics that combine structured SQL data with semi-structured SUPER data. This enhancement allows you to leverage the SUPER data type for structured and semi-structured data processing needs in databases with case-insensitive collation. You can now explicitly specify case sensitivity preferences for SUPER columns using the COLLATE function, providing greater flexibility in handling data with varying case patterns. This is particularly valuable when working with JSON documents, APIs, or application data where case consistency isn't guaranteed.

Amazon Redshift support for the SUPER data type in databases with case insensitive collation is available in all AWS Regions, including the AWS GovCloud (US) Regions, where Amazon Redshift is available. To learn more, visit our documentation.

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/twelvelabs-pegasus-model-in-additional-aws-regions/

TwelveLabs’ Pegasus 1.2 model now available in three additional AWS regions

Amazon announces the expansion of the TwelveLabs’ Pegasus 1
Read more
https://aws.amazon.com/about-aws/whats-new/2025/11/recycle-bin-support-amazon-ebs-volumes

Recycle Bin adds support for Amazon EBS Volumes

Recycle Bin for Amazon EBS, which helps you recover accidentally deleted snapshots and EBS-backed AMIs, now supports EBS Volumes
Read more
https://aws.amazon.com/about-aws/whats-new/2025/11/amazon-vpc-ipam-policies-ip-allocation-strategy/

Amazon VPC IPAM now supports policies to enforce IP allocation strategy

Amazon Virtual Private Cloud (VPC) IP Address Manager (IPAM) supports policies to centrally configure and enforce your desired IP allocation strategy
Read more
View all