You can translate the question and the replies:

VQL to show all cached sources and when it was last refreshed?

Is there a way to get a result set that has the view, number of rows and the last cache refresh date? I want to make this a data set availbe easily to end-users to see when the cache was last updated. I have scoured the user documentation but do not see anything that simple.
user
28-05-2021 08:13:06 -0400

1 Answer

Hi, You may be interested in the stored procedure [CACHE_CONTENT](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/cache_content), which returns information on the cached contents. Leaving the parameter “viewName” null would allow you to return results for all of your cached views in the same database, and the field “expirationdate” will return the latest cache refresh time, assuming the cache is set to “full”. Additionally, you can also see the number of rows fetched and when the last cache refresh was done in the execution trace after executing the view or query. Hope this helps!
Denodo Team
01-06-2021 17:37:03 -0400
You must sign in to add an answer. If you do not have an account, you can register here