Latest Activity

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

code

Scheduling Cache Problem with Base View

Hello, My base views evertime needs a session id to fetch the data(execution). SO I have used an interpolation variable for feeding session key. Session key is generated in different table to whom I usually point when I create a derived view so ...

Cache

code

Incremental cache for deleted rows

Hello, the following link https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Incremental%20Cache%20Load%20Stored%20Procedure%20-%20User%20Manual specifies that Notice that this Stored Procedure can only be used with views where...

Cache