question

UmaB-3948 avatar image
0 Votes"
UmaB-3948 asked SamaraSoucy-MSFT commented

Fact History Load is taking quite huge time in Synapse

Hi Team ,

I am trying to load Fact Table (1.8Millions data) needs to be loaded as part of History Load.
first when I tried it took 14+ hours and then it got failed.
So then i tried to do partial load for each year. which i was able to quite well from 2015 to 2020 but now loading for current year it is taking quite hell lot of time(almost 4 + hours still not completing)
in query plan when i checked it is showing some 30billions estimated rows, also shuffling is happening

I have updated all statistics.

I have already raised Microsoft ticket regarding this but i have not received proper response from there.

Can some one assist me here ?

azure-synapse-analytics
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi,

I haven't heard anything back from you through my private messages. If you still need help with this issue, please @ me or open a new thread.

0 Votes 0 ·

0 Answers