In Redshift for storing JSON data we have introduced the SUPER data type.
However, the SUPER data type only supports up to 1MB of data for an individual SUPER field or object. For more information, see Ingesting and querying semistructured data in Amazon Redshift.
hope this helps,
AWS DMS Postgres to OpenSearch LOB handlingasked 9 months ago
How to import Postgres data that has JSON columns?asked 2 years ago
Redshift Federated Query (RDS Postgres) Long Varchar Value Error (code 25101)asked 4 months ago
Redshift External Table - unable to query struct data types using Avro as a formatAccepted Answerasked 8 months ago
Loading json string data as super from Glue job in to Redshiftasked 9 months ago
Redshift varchar(max) not enough to store json data type column from Postgresasked 7 months ago
How can I migrate a jsonb column from postgres on RDS to S3?asked 3 months ago
Case sensitivity problem in view of JSON in a SUPER columnasked a year ago
[Pandas] How to write data into JSON column of Postgres SQLasked 2 months ago
Redshift column VARCHAR(MAX) questionAccepted Answerasked 2 years ago