You can translate the question and the replies:

fetch cache details.

Hi Team, I need to build views in Denodo, which could fetch below information: 1. when was the view last refreshed 2. how many records got loaded please suggest what tables from cache DB can be utilized . Thanks.
15-02-2022 01:01:18 -0500

1 Answer

Hi, I believe that you are looking for a way to create a view which returns the last cache refresh date and the number of rows inserted into the cache database. You could achieve this with help of [Denodo Monitor](’s vdp-loadcacheprocesses.log file. In order to get the desired information from the log file, you can follow the below steps * Start the Denodo Monitor * Pre-load the cache for the required views which enables the Denodo Monitor to capture the information of the cache load process such as number of rows inserted,refresh time,viewname etc. Refer to the Knowledge Base article [Log column details]( for more information on the content of log files. * After that , in the Virtual DataPort Administration Tool/Web Design Studio ,create either a [Delimited File]( datasource over vdp-loadcacheprocesses.log file or if you are a valid support user, you can download [Denodo Log Custom Wrapper]( and create a data source after importing Denodo Log custom wrapper to Virtual DataPort Administration Tool. * Once the datasource is created, you can create a base view to retrieve the last cache refresh date and number of rows inserted into the cache database. Alternatively, to retrieve only cache refresh date , you can use the predefined stored procedure [CACHE_CONTENT]( Hope this helps!
Denodo Team
15-02-2022 07:43:13 -0500
You must sign in to add an answer. If you do not have an account, you can register here