I'm reading data from a table using federated query, and one of the fields of this table stores a text in JSON format.
I'm using Redshift to extract data from the JSON field and store it into several tables inside Redshift. But some of those JSONs have a size over 65535, and Redshift triggers an error while reading this field.
Is there any work around for this situation, any way to increase this size limit or on doing Redshift reading the field as something else (not as varchar)?