topic Redshift SUPER data type in Qlik Replicate

Redshift SUPER data type

simonB2020 — Mon, 24 Jul 2023 15:14:41 GMT

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

Re: Redshift SUPER data type

Shai_E — Tue, 25 Jul 2023 07:47:06 GMT

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