WHY DATA WAREHOUSE TAKE SO LONG TO EXPORT DATA? | Community
Skip to main content
New Participant
Mar 3, 2021 1:45 AM UTC
Solved

WHY DATA WAREHOUSE TAKE SO LONG TO EXPORT DATA?

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.
zxfdafgsdhAccepted solution
Employee
Mar 3, 2021 9:07 PM UTC

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

khurshid
Employee
Mar 4, 2021 4:59 PM UTC

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.

Translate
yuhuisg
New Participant
Mar 4, 2021 6:32 AM UTC

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.

Translate
zxfdafgsdhAccepted solution
Employee
Mar 3, 2021 9:07 PM UTC

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

 

 

Translate