Is there a way to query the unified profile store? | Community
Skip to main content
S
sharmilap
Level 2
December 13, 2023
Solved

Is there a way to query the unified profile store?

  • December 13, 2023
  • 2 replies
  • 3353 views

Hi, 

 

We ingested unique profiles using custom schemas into AEP. However, the number of profiles showing in the profile store is less than what we ingested and I would like to compare the two. 

 

Is there a way to run queries against the unified profile store?

 

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 BryanRek

    The profile snapshot export is a daily export of the UPS store after the global segmentation job.  This dataSet will hold approx. about 2 weeks of data in this dataSet.  

     

    You will have to use ranking to order the timestamp of when data was placed into this dataSet.  This dataSet will only contain XDM profile related data.

    2 replies

    adobechat
    adobechat
    Level 5
    December 14, 2023

    @sharmilap @Yes, you can use Adobe Experience Platform "Query Service" to run queries against the unified profile store in AEP. This allows you to retrieve and analyze data, helping you compare the ingested profiles with those in the profile store

      arijitg
      Adobe Employee
      arijitgAdobe Employee
      Adobe Employee
      December 14, 2023

      Hi @sharmilap 

       

      You can query profile snapshot dataset that gives you an idea on the profile structure. To mention this dataset updates on daily basis after segmentation jobs are completed. Hence if you upload some data today you will need to wait till next run. Otherwise there is no direct way to query profile store unlike data lake.

       

      Regards,

      Arijit Ghosh

      S
      sharmilapAuthor
      Level 2
      December 14, 2023

      Hi @arijitg & @adobechat ,

       

      I also figured out this profile snapshot dataset after posting this question. Is there any documentation on how this dataset is used? Is there one record in this dataset per profile whether it participates in segmentation or not? Would be good to understand how to interpret the data in this dataset without having to figure each out.

       

      Thanks

       

        BryanRek
        Community Advisor
        BryanRekCommunity AdvisorAccepted solution
        Community Advisor
        December 14, 2023

        The profile snapshot export is a daily export of the UPS store after the global segmentation job.  This dataSet will hold approx. about 2 weeks of data in this dataSet.  

         

        You will have to use ranking to order the timestamp of when data was placed into this dataSet.  This dataSet will only contain XDM profile related data.

          Terms & ConditionsAccessibility statement

          Loading footer...