Large JSON Support for Redshift
Large JSON payloads land in Amazon Redshift as the SUPER data type, which supports documents up to 16MB and avoids truncation.
JSON payloads are everywhere - but when they get large, most tools fall short. Many platforms land JSON into VARCHAR(MAX), which caps out at ~65k characters. For teams working with rich event logs, nested API responses, or anything more complex, that limit means truncated payloads and lost data.
When Artie encounters large JSON payloads, we now land them as the SUPER data type in Amazon Redshift. SUPER supports documents up to 16MB in size, preserving the full payload without truncation. That means you can capture, query, and transform large, complex JSON documents in Redshift without compromise.
Why this matters:
- Preserve entire JSON payloads instead of losing data to truncation
- Unlock the full power of Redshift's semi-structured query capabilities with SUPER
- Handle large event logs, nested API responses, and other big JSON columns with ease
- Avoid manual workarounds or post-processing to recover lost information
Working with big JSON in Redshift and want to see the difference? Reach out to our team - we'll help you get set up.