# Store and process large strings in Amazon Redshift SUPER columns

DevFeed: [Store and process large strings in Amazon Redshift SUPER columns](<https://devfeed.tech/articles/store-and-process-large-strings-in-amazon-redshift-super-columns-122142.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/big-data/store-and-process-large-strings-in-amazon-redshift-super-columns/>)

Author: Ritesh Sinha

Published: 2026-11-06T20:19:36Z

Content type: tutorial

Language: en

Sources: [AWS Big Data Blog](<https://devfeed.tech/sources/aws-big-data-blog.md>)

Topics: [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [data type](<https://devfeed.tech/topics/data-type.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [sql-database](<https://devfeed.tech/topics/sql-database.md>), [cloud-migration](<https://devfeed.tech/topics/cloud-migration.md>), [data lake](<https://devfeed.tech/topics/data-lake.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [arrays](<https://devfeed.tech/tags/arrays.md>), [data](<https://devfeed.tech/tags/data.md>), [data-type](<https://devfeed.tech/tags/data-type.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [data-workflows](<https://devfeed.tech/tags/data-workflows.md>), [json](<https://devfeed.tech/tags/json.md>), [migration](<https://devfeed.tech/tags/migration.md>), [semi](<https://devfeed.tech/tags/semi.md>), [simplify](<https://devfeed.tech/tags/simplify.md>), [store](<https://devfeed.tech/tags/store.md>), [strings](<https://devfeed.tech/tags/strings.md>), [structured-data](<https://devfeed.tech/tags/structured-data.md>), [type](<https://devfeed.tech/tags/type.md>)

## AI overview

Amazon Redshift's SUPER enhancements let you store individual strings in semi-structured data up to 16 million bytes, process long strings in memory, and use SUPER in databases with case-insensitive collation. Large-string support requires patch 206 or later and `enable_large_strings_opt_in` set to Yes; provisioned clusters must be rebooted, while Serverless uses a workgroup setting. Cast SUPER values to VARCHAR before applying string functions to avoid errors and truncation. The larger limit applies to in-memory operations, not VARCHAR(MAX) table columns; views, UDFs, and stored procedures created before enabling the setting must be recreated to use it. Case-insensitive database behavior can coexist with SUPER, with `COLLATE` specifying case sensitivity where needed. The text also recommends setting SUPER attribute case handling carefully, explicitly casting values, and aligning the large-string setting across data-sharing warehouses.

## Source excerpt

Storing large semi-structured data such as JSON and arrays in a data warehouse often means splitting or truncating your data. With PartiQL and the SUPER data type, Amazon Redshift is now equipped to handle these issues. In this post, we walk you through three key SUPER data type enhancements that simplify semi-structured data workflows and reduce common migration challenges.