Alternative to Data Warehouse query | Community
Skip to main content
V
vivin_geevarghese
October 30, 2019
Solved

Alternative to Data Warehouse query

  • October 30, 2019
  • 2 replies
  • 1799 views

For a project, I need to get order data from adobe workspace - but since it workspace has row limitations, many order data appear under 'small elements' and I am unable to export them. I tried scheduling a data warehouse query as an alternative - It gives me the entire data accurately, but it 2-3 hours for the query result to reach my inbox. Is there any way I can do this faster? Any suggestions are welcome

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 Pablo_Childe

For a large data request 2-3 hrs is good for Datawarehouse.

Some things you could try. If its sales data I would guess monthly totals are key. Try breaking the request into smaller chunks.

weekly for example.

Also make sure you dont have any waste columns(data you ultimately do not use) this can speed things up.

Worst case you get weekly within tens of minutes then start your build into what ever master you have adding others as they arrive.

GLTU

2 replies

hayleyy88638989
hayleyy88638989
Level 2
October 30, 2019

How many rows do you require? if less than 50k you can use report builder

both RB and DW may not necessarily be fast depending on the complexity and volume of your query thats how long it takes, like any large database.

You can schedule both to run out of hours or on a regular basis

Pablo_Childe
Community Advisor
Pablo_ChildeCommunity AdvisorAccepted solution
Community Advisor
October 30, 2019

For a large data request 2-3 hrs is good for Datawarehouse.

Some things you could try. If its sales data I would guess monthly totals are key. Try breaking the request into smaller chunks.

weekly for example.

Also make sure you dont have any waste columns(data you ultimately do not use) this can speed things up.

Worst case you get weekly within tens of minutes then start your build into what ever master you have adding others as they arrive.

GLTU

Terms & ConditionsAccessibility statement

Loading footer...