Redshift SUPER data type

[simonB2020]

Am replicating from AWS Aurora (Postgres) to AWS Redshift.
A source JSON data type is read as widestring, treated as CLOB in Replicate, and written to Redshift as varchar.

I would like the target type to be a Redshift SUPER type.
After manually altering the redshift DDL this works well.

However, looking for a way of having Qlik create the table with this data type in the first place.
Is there anything I can tweek to enable this ?

Thanks

[Shai_E · Accepted solution]

Hi @simonB2020 ,

If the 'SUPER' data type was supported in Replicate on the target database, then you could have done this with a global transformation.

But, that won't be possible since the target aws redshift does not support the 'SUPER' data type in Replicate.

Supported data types | Qlik Replicate Help

Best Regards