Q&A

We need help here as in what could we be the ways to further optimize as it is taking forever to run. There are two branches on a high level/ Left branch - Union of 6 regions data with required customizations/joins happening for each branch (data - to...

What columns form the DB2 11 SYSCAT.ROUTINES view dose Denodo access?

Related to: Denodo Development Best Practices

Hi, is there a way to list the denodo folders for a particular denodo database via VQL? so for example: sandbox (database) - 0. Raw Data (folder) - 1. Interfaces (folder) - 2. Derived Views (folder) - 3. Final Views (folder) So i want to be able t...

Hi Team, I am connecting to an API and started getting error 429 - too many requests. Is there a way where in i can put a wait before the next request? Or any other recommendations? Thanks!

Hi, We're using a separate software to route messages between a Denodo webservice and an external webservice. What is the best option to store the replies from the external webservice? It could be both error messages and data. I tested using a separate...

Can you help me with corresponding function to ORA_HASH function in oracle. we're using Denodo 7.0

Hi Team, how denodo stores scheduler load process reports for cache jobs. how can we bring that in to denodo vdp. Thanks.

Hello Team, I have a request to expose a date for a client to this formt "yyy-MM-ddT00:00:00.000Z" the OriginalDate is like "2022-02-08T00:00:00" i used the following function but in the result the 'Z' doesn't appear: formatdate('yyyy-MM-dd''T''HH:m...

Hi Team, If I create a new view, how can I automatically add it to allusers role in Denodo. Thanks.

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.