Latest Activity

code

How to load the cache for specific views in a job?

Hi, I have scheduled a cache job in scheduler and there are around 50 views in that job. I have scheduled it for every 2 hrs. Now the thing is that every time I do not have to load cache for all the views instead I want to load the cache for some view...

Denodo Scheduler 8.0 Cache

code

one job in scheduler to refresh multiple views

Is there a way to have one cache job that refresh multiple views? we have a process that we had to set up 26 separate refresh jobs and I am wondering if there is a better, more efficient way of doing this?

Automic scheduler custom script caching Cache

code

Incremental cache mode

Hello team, i have a blocking point regarding the incremental cache. as i red on the manual the full incremental is only used on base views , in my case my base view needs a token to be lanched , so whenever a schdeuled the cache the acces token is n...

Incremental Cache Cache

code

Bulk Data Load API error in Denodo 8.0

I have followed the below steps to configure databricks as cache and mpp in denodo 8.0 from this link https://community.denodo.com/kb/en/view/document/Configuring%20Databricks%20as%20MPP%20and%20Cache#h.df1a9s2oqcco Everything is OK but querying table...

databrick Bulk Data Load Denodo8 MPP Cache

code

If Cache Scheduler fails can it call data source directly using FULL cache mode?

Hello, I have one view and full cache mode is applied on it and it is scheduled to run everyday on 8PM, so in full cache mode view will never hit datasource, SUppose scheduler went down due to any reason, now my question is: Q. Can we call data sourc...

cache

code

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 ...

vql query LASTCACHEREFRESH Cache

code

CONTECT('cache'= 'off') is not fetching data from sources

Hi Team, I'm using Denodo 7.0. I have a derived view dv_join which has several intermediate views. Full cache mode is enabled for this view and Oracle is the cache DB. Loading the cache for this view is taking around 1 hour to complete. I want to s...

cache context

code

How do I find the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file on the support site?

I know the denodo-incremental-cache-load-{vdpversion}-{version}-jar-with-dependencies.jar file is on the support website because I found another user's question that has that bit of information in it (https://community.denodo.com/answers/question/detai...

Incremental Cache Cache Denodo Jar

code

How does Full cache work after deployment to other environments?

I have enabled a "Full" cache on a Derived view. I would like to deploy this view to Staging and Production. After importing the VQL and Properties files (deployment) in Staging and Production, do I need to manually go to "Execution Panel" -> chec...

Cache

code

Find Cache Index Tables

Hi, Can you please advise how Cache Index Tables can be found related to a Cached View. Procedure GET_CACHE_TABLE displays information about Cache Data Tables only. Thanks. User

Related to: Cache database size estimate

Cache Index Cache