Latest Activity

code

Impersonation on RESTful and GraphQL services.

We are invoking the APIs using service account from an application but need to execute the query in Denodo as the user connecting to the calling application. Can this be achieved for RESTful and GraphQL services? Impesonation only seems to be support...

code

Improper import and element showing in VDP

Hi Team, I am facing a weird issue in denodo 8 VDP. so i have 1 derived where i am doing joins . In that join i am joing base table A with table B and table C. Now i modified the derived view vql and replaced the table B with D and table C with E na...

code

long field. division

Hi Team I have a column of type 'long'. values like 20, 15, 133, 100. I have to create a new column using it which must have values like .20, .15, 1.33, 1.00 so something like long field/100. How do I do that. ? for me 'long field'/100 is returning ...

code

Is there a way to enable non admins to assign roles to users and other roles ?

Is there a way to allow users in non admin role to assign roles? They are able to create new users and roles, assign privileges but not able to assign roles and also not able to export vql with user privileges. They are admin on all databases and are a...

code

How can you access the Scheduler Log files without Client API?

We are interested in analyzing the Denodo Scheduler log data to monitor jobs, identify trends in errors/job failures, and to identify trends on when jobs are being run. From my research, it looks like the only documneted way to get this data with Denod...

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

code

Resource manager rule that blocks VDP admin tool access for some users.

Hi Team, Please suggest a Resource manager rule that blocks VDP admin tool access for some users. Tried with username and access interface but didn't work Thanks, Penchal

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

code

Is it possible to have some ODBC connections use windows authentication and others use standard?

Using VDP 8.0.20210209 I have configured the system for LDAP and Kerberos. Once I check the box in the Database Management screen "User Kerberos/OAuth for ODBC..." I can no longer use standard authentication. All ODBC connections use the credentials of...

code

Condition statement examples for resource manager rule

CONDITION ''user_name=''testusr'" can we specify like this or only True or false to restrict only for a specific user. In