Cache Priming with Snapshots


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.

This can be handled by setting up Chartio Snapshots for your dashboard for a time period right after your ETL was run and by setting your cache duration to be 24 hours.

  1. On the dashboard you would like to cache prime, select Settings in the bottom right sidebar.

    Click Settings from the dashboard sidebar

  2. Under the first tab (Settings), set your Cache Duration to be 24 hours.

    Set your cache duration and toggle Use Organization Default off

  3. 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.

    Enable Snapshots

  4. 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.

Related Dashboards Help Articles

See more