Updating existing PK in the table | Community
Skip to main content
R
RajatPanwar
Level 2
April 19, 2023
Solved

Updating existing PK in the table

  • April 19, 2023
  • 2 replies
  • 870 views

If there is a custom schema with composite PK. Is it recommended to change the composite PK and remove columns from previous PK and add new columns?

 

Will this change result in corruption of existing campaign workflows using the schema? Any other issues and if there is a recommendation on dealing with this type of change?

 

Thanks. 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by LakshmiPravallika

Hi @rajatpanwar ,

 

The change of a column in the Primary Composite key will not corrupt the columns not the data in the Schema.

 

In the downstream Campaigns, in any logic if you are using the Reconciliation Keys in Enrichment to Join or Using Update Data activity these keys should be changes accordingly as per the Unique Primary key combination, so that it won't be impacting the Campaigns.

 

Regards,

Pravallika.

2 replies

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity AdvisorAccepted solution
Community Advisor
April 19, 2023

Hi @rajatpanwar ,

 

The change of a column in the Primary Composite key will not corrupt the columns not the data in the Schema.

 

In the downstream Campaigns, in any logic if you are using the Reconciliation Keys in Enrichment to Join or Using Update Data activity these keys should be changes accordingly as per the Unique Primary key combination, so that it won't be impacting the Campaigns.

 

Regards,

Pravallika.

    R
    RajatPanwarAuthor
    Level 2
    April 19, 2023

    Thanks. if the new composite PK have records in the schema which are not unique based on the combination, will the schema/other screens in the console through an error and we need to clean up those rows and make it unique based on the new composite PK?

    LakshmiPravallika
    Community Advisor
    LakshmiPravallikaCommunity Advisor
    Community Advisor
    April 19, 2023

    Hi @rajatpanwar ,

     

    Yes, if the previous data before changing composite key is not unique as per latest Composite key, either u can update the newly added primary key column to get the Unique key combination or delete the data.

     

    Regards,

    Pravallika

      Terms & ConditionsAccessibility statement

      Loading footer...