Need to know limitation on derived dataset created via queries. | Community
Skip to main content
October 23, 2023
Solved

Need to know limitation on derived dataset created via queries.

  • October 23, 2023
  • 2 replies
  • 733 views

Query 1: 

If the query output number is in the millions, will it be able to successfully ingest the data into a data lake, profile store, or identity services?

 

Test use case: An error was thrown when batch ingesting data larger than 20 GB.

 

Few limitation is available in the below link required some additional information.

Ref url: Export Datasets to Cloud Storage Destinations | Adobe Experience Platform

 

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

Hi @vvishnu0332  - Seems there is a limit up to 20 GB  of data per hour to data lake using the batch ingestion API.
Batch Ingestion Guardrails - 
https://experienceleague.adobe.com/docs/experience-platform/ingestion/guardrails.html?lang=en#:~:text=You%20can%20ingest%20up%20to%2020%20GB%20of%20data%20per%20hour%20to%20data%20lake%20using%20the%20batch%20ingestion%20API
Default Guardrails - https://experienceleague.adobe.com/docs/experience-platform/profile/guardrails.html?lang=en 
Refer the above limits to avoid the error on your ingestion. 
Thank you,

Jay.

2 replies

jayakrishnaaparthasarathy
Community Advisor
jayakrishnaaparthasarathyCommunity AdvisorAccepted solution
Community Advisor
October 24, 2023

Hi @vvishnu0332  - Seems there is a limit up to 20 GB  of data per hour to data lake using the batch ingestion API.
Batch Ingestion Guardrails - 
https://experienceleague.adobe.com/docs/experience-platform/ingestion/guardrails.html?lang=en#:~:text=You%20can%20ingest%20up%20to%2020%20GB%20of%20data%20per%20hour%20to%20data%20lake%20using%20the%20batch%20ingestion%20API
Default Guardrails - https://experienceleague.adobe.com/docs/experience-platform/profile/guardrails.html?lang=en 
Refer the above limits to avoid the error on your ingestion. 
Thank you,

Jay.

Level 2
October 25, 2023

for better ingestion of data through query service I think you need to have Data distiller SKU purchased.

https://experienceleague.adobe.com/docs/experience-platform/query/data-distiller/overview.html?lang=en

Thanks,

HariP