Store and process large strings in Amazon Redshift SUPER columns

This article explains three key enhancements to Amazon Redshift's SUPER data type for handling semi-structured data like JSON and arrays at scale.

• SUPER columns now support individual strings up to 16 million bytes, eliminating need to split or truncate large JSON documents
• In-memory string function operations process SUPER data beyond 65,535 bytes VARCHAR limit without truncation or errors
• SUPER data type now works in case-insensitive databases, simplifying migrations from legacy data warehouses
• Cast SUPER values to VARCHAR to apply string functions like LOWER, SUBSTRING, and LISTAGG without truncation
• Use enable_large_strings_opt_in parameter and enable_case_sensitive_super_attribute setting to activate features
• Best practices include explicit data type casting, creating materialized views, and promoting frequently queried fields to regular columns

These enhancements enable organizations to store complete legal documents, product catalogs, IoT sensor data, and customer profiles in Redshift without data loss or performance degradation.