Preview dataset different from the last execution | Community
Skip to main content
G
gprime84
March 12, 2022
Solved

Preview dataset different from the last execution

  • March 12, 2022
  • 1 reply
  • 2044 views

When I preview the dataset in AEP, only the last ingestion of the data set is always displayed. Even if I select a previous data set and click on the button, the latest data set is always displayed. Is it possible, from the UI and not via the API, to view data sets prior to the last ingestion date?

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 jayakrishnaaparthasarathy

ok, last question on the topic. In addition to using the query service I can also use the API, correct? in case you don't want to buy the query service on the project. Thanks in advance


Hi @gprime84  - Yes, you can use the Data Access API with a RESTful interface where you could leverage the data accessibility.
Here you go - https://experienceleague.adobe.com/docs/experience-platform/data-access/api.html%3Flang%3Dko

However, API has their own limitation of accessing the raw data from AEP.

1 reply

jayakrishnaaparthasarathy
Community Advisor
jayakrishnaaparthasarathyCommunity Advisor
Community Advisor
March 14, 2022

Hi @gprime84  - Yes, the preview option only display the latest file that was being on boarded in to the AEP data lake. There is no direct option to preview the existing data under the dataset. However, you can utilize query service to see all other data from the respective dataset. Also, check if it is possible to see the data in batch vise as you expected (I am not a query expert), probably platform should allow us to see the batch vise data from individual data set. Therefore, get a respective query to view all the data from datasets (prior to the last ingestion date).

jayakrishnaaparthasarathy
Community Advisor
jayakrishnaaparthasarathyCommunity Advisor
Community Advisor
March 16, 2022

Hi @gprime84  - You can use query like below to preview the individual batch data.

SELECT * FROM "Dataset Table Name"where _ACP_SYSTEM_METADATA.ACP_SOURCEBATCHID='Batch ID'

Hope, this would be useful for you to preview the prior to the last ingestion data.

 

G
gprime84Author
March 16, 2022

ok, last question on the topic. In addition to using the query service I can also use the API, correct? in case you don't want to buy the query service on the project. Thanks in advance

Terms & ConditionsAccessibility statement

Loading footer...