Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,696 questions
Fact History Load is taking quite huge time in Synapse
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 82%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUB%3C/text%3E%3C/svg%3E)
Uma B
1
Reputation point
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 ?
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 44%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Samara Soucy - MSFT 5,051 Reputation points2021-05-28T03:52:38.547+00:00 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.
Sign in to comment