You can translate the question and the replies:

Denodo scheduler with cached views queries.

Hi team, I'm a Denodo7 admin and wanted to know how can I validate the views that are cached have a corresponding schedule that keep the cache up to date? For example I can use *CACHECONTENT()* to see last it was 'full' cached but is there a existing job?
20-03-2020 17:18:53 -0400

1 Answer

Hi, I am not sure whether you want to check if the latest data is available when you query a cached view through a scheduled job, but if you are trying to use full cache for your views, you can get the latest data by using the full incremental option. ‘Incremental Queries’ work by merging in real-time the data cached for a view, with the data from the source that has been either added or updated since the last time the cache was refreshed. This way, Denodo can return fully up to date results, without needing to retrieve the full result set from the data source (only the rows added/changed from the last cache refresh). In order to use this option, there are several requirements that must be met. You can read more on this in the[ Incremental Queries]( document. If you need to get some info about the status of the cache or the last refreshed data, you can get this info through JMX. More on this can be found in the [Information on the Cache]( document. Hope it helps!
Denodo Team
23-03-2020 10:32:17 -0400
You must sign in to add an answer. If you do not have an account, you can register here