1

Should it be possible to update an existing data extension to add additional primary keys?

We have a current Data Extension that has a primary key as subscriber key however noticed that a person can be in the data more than once but unique based on store ID so wanted to update the data extension to add a second primary key on store location. I could have sworn i was able to do this in the past.

Is this a permission issue or is it not possible once the data extension has been created?

I can see if i add an additional field, i can add that as the primary key, just wont let me update an exciting field

Improve this question

1 Answer 1

Reset to default
2

If the DE has data in it you cannot add a primary key. Once you clear the data you can delete the field you want to add the primary key, then re-add it and select it as a primarykey. You could also copy the DE and then set the primary key then use a query activity to populate the new DE if you need to save the data

Improve this answer
3
  • Thanks, i cleared out the data however still wont let me add a primary key. Was trying to do it without creating a new DE as its used to populate a journey. Not a biggie just hoping it was permission issue
    – Andyw
    Commented Jun 12, 2019 at 1:33
  • To add on, see this question for more info on copying de to edit pkeys: salesforce.stackexchange.com/questions/265485/…
    – Gortonington
    Commented Jun 12, 2019 at 1:34
  • 1
    @Andyw I updated the steps to edit, you have to remove the field and re-add it
    – EazyE
    Commented Jun 12, 2019 at 1:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .