If I create a model based on a data source, will the model automatically update when the source data is refreshed or updated?
If not can I setup a trigger to automatically rerun the query?
If you've not enabled caching, then you have fresh data every time the model is used in a question.
If you have enabled caching, you set the refresh frequency.
How do I enable/disable caching or set the refresh frequency?
Sorry, slightly wrong termininology. For some reason, caching of models is called 'persistence'.
1 Like
So if persistence is off does it mean every time I query a model it refreshes it?
I'm not sure if the Database caching would be used. It's not clear in the docs if a persisted model's query is then cached, or if a non-persisted model's query would be cached.
I'm guessing that it is but just because it makes more sense to me!
Would be a good experiment if nobody from Metabase can answer. You can check for cached results easily enough in the database.
1 Like
Models are like views in a database, while cached models are like materialized views. This means that models are like querying the database directly while cached models will query the data at the time it was cached
@Luiggi - what about persisted models? Are those queries cached?