WHY DATA WAREHOUSE TAKE SO LONG TO EXPORT DATA? | Community
Skip to main content
March 3, 2021
Solved

WHY DATA WAREHOUSE TAKE SO LONG TO EXPORT DATA?

  • March 3, 2021
  • 3 replies
  • 1399 views

It is already 48hrs. since I requested for the data but still I don't receive anything. Is there a way we can track it? It says In progress in the status. 

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 zxfdafgsdh

Hi @mikikagawamercado122620 

If you see data warehouse requests consistently take a long time, consider altering your requests to accommodate the following:

  • Use a segment containing a smaller sample of data: The less data a request works with, the faster it returns a report.
  • Run requests in 14 day increments or less: Smaller requests are processed faster than large requests.
  • Use fewer breakdowns: Many breakdowns in a Data Warehouse request exponentially increase the time it takes to process.

Please visit the following document to troubleshoot delivery times for DWH report and review other alternatives: https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/delivery-time.html?lang=en#data-warehouse

 

 

3 replies

zxfdafgsdhAdobe EmployeeAccepted solution
Adobe Employee
March 3, 2021

Hi @mikikagawamercado122620 

If you see data warehouse requests consistently take a long time, consider altering your requests to accommodate the following:

  • Use a segment containing a smaller sample of data: The less data a request works with, the faster it returns a report.
  • Run requests in 14 day increments or less: Smaller requests are processed faster than large requests.
  • Use fewer breakdowns: Many breakdowns in a Data Warehouse request exponentially increase the time it takes to process.

Please visit the following document to troubleshoot delivery times for DWH report and review other alternatives: https://experienceleague.adobe.com/docs/analytics/export/data-warehouse/delivery-time.html?lang=en#data-warehouse

 

 

yuhuisg
Community Advisor
Community Advisor
March 4, 2021

Also, if your report's date range is "This Month", you won't get the report until after this month has ended. So if you had set it up on 2 March, you need to wait till 1 April to get it.

khurshid
Adobe Employee
Adobe Employee
March 4, 2021

It depends on the amount of data and complexity of the report on how much time a Data Warehouse report will take to complete the request.