Automatic Primary Key | Community
Skip to main content
ASNeelima
Level 2
September 11, 2024
Solved

Automatic Primary Key

  • September 11, 2024
  • 1 reply
  • 683 views

What is Automatic Primary Key in Custom resource,  campaign Standard ?

 

 

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 Craig_Thonis

Hi ASNeelima,

 

Please check out the documentation below that describes this key:

https://experienceleague.adobe.com/en/docs/campaign-standard/using/developing/about-custom-resources/data-model-best-practices

 

 

Identification keys

"Each resource created in Adobe Campaign must have at least one unique identification key.

When creating a custom resource, you have two options:

A combination of auto-generated key and internal custom key. This option is interesting if your system key is a composite key or not an integer. Integers will provide higher performances in big tables and joining with other tables.
Using the primary key as the external system primary key. This solution is usually preferred as it simplifies the approach to import and export data, with a consistent key between different systems.

Identification keys should not be used as a reference in workflows."


Regards,
Craig

1 reply

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
September 11, 2024

Hi ASNeelima,

 

Please check out the documentation below that describes this key:

https://experienceleague.adobe.com/en/docs/campaign-standard/using/developing/about-custom-resources/data-model-best-practices

 

 

Identification keys

"Each resource created in Adobe Campaign must have at least one unique identification key.

When creating a custom resource, you have two options:

A combination of auto-generated key and internal custom key. This option is interesting if your system key is a composite key or not an integer. Integers will provide higher performances in big tables and joining with other tables.
Using the primary key as the external system primary key. This solution is usually preferred as it simplifies the approach to import and export data, with a consistent key between different systems.

Identification keys should not be used as a reference in workflows."


Regards,
Craig