Latest Activity

code

Cannot setup Databricks as cache

Hi, I am trying to setup Azure Databricks + ADLS as cache. On the Linux server, logged into the docker container runnig Denodo instance, and I installed databricks-cli and configured with token. I can see the directories when executing dbfs ls, which m...

databricks Cache Azure databricks Azure Data Lake Storage Gen2

code

fetch cache details.

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

Cache

code

Remote table Vs Cache

What is the difference between remote table and cache

cache Remote table

code

Problem with Amazon Athena Cache

Hello, We have Denodo VDP 8.0 running in a Linux server. We add Amazon Athena Cache and we have a problem when try to store results in cache. The logs registered: FATAL YYYY-MM-DDTHH:MI:SS.FFF com.denodo.vdb.engine.thread.ReusableThread [] - runWork ...

Cache Error AWS S3 Athena athena Athena AWS athena Cache

code

Denodo cache got invalidated while having changes at the source level

Hi Support, I have noticed that, whenever I have any of the column/data type changes at source level of any of my developed(cached) views, My cached views got automatically invalidated? so the Question is, Is there any way to keep the cache db as it ...

cache oracle

code

Denodo Cache question

Hi Support, is it possible to use two different cache source at a same time? I mean to say to separate databases(like teradata & oracle) as cache? and If yes, then how we will synch up both at a same time? Thanks.

cache denodo

code

Cache tables storing multiple cache records

Refers to Denodo 7. One of my cache tables stores multiple caches, although it is set up to invalidate all rows. Only when calling 'clean_cache_database' the invalid rows are being removed and the table gets cleared. Other very similar cache tables nev...

cache

code

What specific value is represented by @LAST_REFRESH_DATE

Hello there, we are trying to implement a generic incremental cache load where we only update rows, that have been changed since the last time the cach load job ran. But to evaluate, whether our method is valid, we need to know, which timestamp is exa...

Incremental Load LAST_REFRESH_DATE Denodo Scheduler 8.0 Cache Loading Cache Updating Cache

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