Forum Discussion
Snowflake data refresh extremely long
I have built out fairly involved dashboard which is pulling in YTD data from our Snowflake platform. 12 seperate queries some pulling in as many as 18M rows of data. As you can imagine the refresh ...
Hi Anonymous ,
“As you can imagine the refresh process takes some time, about 3 hours from the desktop. ”
I think you need to reset your incremental refresh strategy and optimize your data model.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous the initial full load will take longer, I'm not sure what you mean by 12 different queries, are these different tables or the same on? 18 million is not that many rows. Are you using direct query?