​
Introduction

To make things faster and minimize wait times, Latitude stores the results of your queries in a cache layer.

​
How It Works

  • Cached by default

    The first time you run a query, the results are automatically cached. This means that the next time you visit the view, it will load almost instantly.

  • You can refresh data by:

    • Running the query using the RunButton in a view. See the page Run Button for more information.
    • Forcing a view to run by query parameters in the URL. See the section Forcing Refresh with Query Param for more information.

  • Configurable Expiration

    The cached data doesn’t expire by default. It remains stored until you either click the Run button or use a special URL parameter that updates and overwrites the cached data. This can be configured by setting the ttl parameter either in the source configuration or in the query itself.

​
Forcing Refresh With Query Param

You can use the __force parameter to force a refresh of results on a specific page.

See the page parameters to learn how query params work.

SQL SyntaxVariables