Alternative to Data Warehouse query

Avatar

Avatar

viving37773030

Avatar

viving37773030

viving37773030

29-10-2019

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

View Entire Topic

Avatar

Avatar

hayleyy88638989

Avatar

hayleyy88638989

hayleyy88638989

30-10-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