Customers dealing with especially large volumes of data commonly have an ETL process that runs once a day, typically at night when loads are lower and servers are cheaper.
For these types of setups, it’s best to change the default dashboard settings, which are focused more on a real time data visualization environment. It would be best for your dashboards to simply update once a day, right after the ETL process has run. There’s no reason to rerun your queries multiple times a day, or for it not to be cached before the first person opens it in the morning.
On the dashboard you would like to cache prime, select Settings in the bottom right sidebar.
Under the first tab (Settings), set your Cache Duration to be 24 hours.
Enable Snapshots and set the Snapshot Hour to be sometime after your ETL process. Note: The Snapshot Hour is set using UTC, so adjust accordingly.
Click Update to save changes.
Now the Snapshots feature will run fresh queries of your dashboards every day at that hour. This primes the cache for the remaining 24 hours that you’ve now set your cache duration to. When someone logs into Chartio and views the dashboard in the morning, they will have the latest updates right away and unnecessary queries won’t be run constantly as people view it throughout the day.