Amazon Redshift announces support for the SUPER data type in Databases with Case-Insensitive Collation
News
This article announces Amazon Redshift support for the SUPER data type in case-insensitive collation databases, enabling advanced analytics on semi-structured and nested data.
- SUPER data type now works with case-insensitive collation in Redshift databases
- Combines structured SQL data with semi-structured JSON data using PartiQL
- COLLATE function allows explicit case sensitivity preferences for SUPER columns
- Eliminates need for data normalization when handling varying case patterns
- Useful for JSON documents, APIs, and multi-source data integration
- Available in all AWS Regions including GovCloud (US)
This enhancement simplifies analytics on mixed structured and semi-structured data by providing flexible case handling without additional normalization overhead.
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
Jun 19
2024
2024
Apply fine-grained access and transformation on the SUPER data type in Amazon Redshift
Nov 1
2024
2024
AWS announces CSV result format support for Amazon Redshift Data API
Sep 11
2024
2024
Amazon Redshift now supports altering sort keys on tables in zero-ETL integration
Jan 21
2025
2025
Amazon Redshift introduces new SQL features for zero-ETL integrations
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.