AEP Schema Updation | Community
Skip to main content
J
jeeshan02
Level 2
December 22, 2023
Solved

AEP Schema Updation

  • December 22, 2023
  • 2 replies
  • 1531 views

Hi Team,

                   

I'm having trouble with AEP Schema. My question is this: I created a schema in AEP and inserted 50 records into it. Then I changed some values in the same file and inserted the record into the same schema, but it was not updated; instead, it was inserted into the same schema.

Is there any way to update the records?

 

 

SS for reference

 

 

    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 abhinavbalooni

    Hey @jeeshan02 

     

    You would not need this approach for an event dataset as events are time series data with timestamps. They don't overwrite information as they happen over a period of time.

     

    Profile data on the other hand is record data and hence might get overwritten. That's why the need to upsert enable the dataset in case of profile dataset.

     

    Hope the above clarifies the approach.

     

    Cheers,

    Abhinav

    2 replies

    abhinavbalooni
    Community Advisor
    abhinavbalooniCommunity Advisor
    Community Advisor
    December 22, 2023

    Hi @jeeshan02 

     

    I guess you meant you inserted records into an AEP dataset.

     

    By default, datasets are not enabled for upserts (update and inserts). You can enable them using the method described on this link: https://experienceleague.adobe.com/docs/experience-platform/catalog/datasets/enable-upsert.html?lang=en

     

    Once you enable the dataset for upsert, your data will not be overwritten but the profile instead would be updated. 

    Hope the above helps.

     

    Cheers,

    Abhinav

      J
      jeeshan02Author
      Level 2
      December 27, 2023

      Thanks for the Responce

       

       

      Can we get this approach for Event as well.

       

       

      Thanks,

      Jeeshan

        abhinavbalooni
        Community Advisor
        abhinavbalooniCommunity AdvisorAccepted solution
        Community Advisor
        December 27, 2023

        Hey @jeeshan02 

         

        You would not need this approach for an event dataset as events are time series data with timestamps. They don't overwrite information as they happen over a period of time.

         

        Profile data on the other hand is record data and hence might get overwritten. That's why the need to upsert enable the dataset in case of profile dataset.

         

        Hope the above clarifies the approach.

         

        Cheers,

        Abhinav

          NimashaJain
          Adobe Employee
          NimashaJainAdobe Employee
          Adobe Employee
          January 16, 2024

          @jeeshan02 Did you find the suggested solutions helpful? It would be great if you can  mark the answer as correct for posterity. If you have found out solution yourself, share it with wider audience in the community.

          Terms & ConditionsAccessibility statement

          Loading footer...