Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Alternative to Data Warehouse query

Avatar

Avatar
Level 1
viving37773030
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile

Avatar
Level 1
viving37773030
Level 1

Likes

0 likes

Total Posts

1 post

Correct Reply

0 solutions
View profile
viving37773030
Level 1

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct Reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Give Back 50
Level 6
pabloc82923542
Level 6

Likes

78 likes

Total Posts

358 posts

Correct Reply

82 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
pabloc82923542
Level 6

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

Answers (1)

Answers (1)

Avatar

Avatar
Shape 1
Level 2
hayleyy88638989
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Shape 1
Level 2
hayleyy88638989
Level 2

Likes

5 likes

Total Posts

7 posts

Correct Reply

0 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
hayleyy88638989
Level 2

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