Primary Key not being created in target tables

[Anonymous]

Hello,

I have a task with SAP Application endpoint as source, and AWS Redshift endpoint as target. The tables in SAP have primary keys detected by Qlik (shown in the table selection tab, see image).

But when doing a full load on target, with the drop and create option selected (see image), the tables created in Redshift have not the primary keys.

Why is this happening?

[shashi_holla · Accepted solution]

Hi @Anonymous 

We just tried on the 2022.05 version of Replicate and primary keys are getting replicated to Redshift. Could you please let us know your Replicate version and also if you enable the checkbox "Create Primary key or unique indes after Full Load completes" in Full Load settings, does it make any difference. 

Please let me know.

Thank you,