Latest Activity

code

IP Based Access

How to give access to the user based on IP Address to view tables and capture the logs ?

code

how to change substring dollar to number order

how to change substring dollar to number order in denodo

code

Misfire on Scheduler Job

Hi, On scheduler I keep seeing Misfire result on the Job when I have Trigger scheduled. I went through the causes but it doesnt really satify the scenarios I see. Is anyone having this kind of problem? Thank you, I hope I can be more clear but dont...

code

compatibility with pymssql

We are using package pymssql (2.2.4). Is our code comaptible with Denodo as-is, or will we have to mkae changes to use a different package?

Related to: How to connect to Denodo from Python - a starter for Data Scientists

code

Extra VQL query from the view

I have developed morethan 1000 derived views I am capturing all the Metadata with dependent views stored into one view or table I want to be extract VQL Query like select e.empid,e.empname,D.deptid from emp join dept on Emp.deptid= dept.deptid ...

#VQ
code

Extract CREATE VIEW AS SELECT soruce code statement

Hi, We are trying to ONLY extract all the CREATE VIEW vql source code to be able to isolate the AS SELECT statement of it. The goal is to have a list of all views we have created and their select statement. Can the output of the feature 'Creating re...

code

Denodo upgrade(denodo-v80-update-20230301)

Hello team, We have installed the update in the Docker image and pushed it to registry also we did the helm deployment but even though we can see in pod the other update related changes, however we are not able to see the MPP changes. Even when we log...

code

Association in Denodo

Hi, i have 3 base views (A,B and C). association has been created between A and B,B and C as per documentation it says Association helps with performance so when i run my VQL query which joins A to B and B to C .how do i know if association actually im...

code

Add new columns in derived views

Hi, My data source is a mongoDB, As first step I create a collection with a sample of documents. When I add a new document with a new field, I can use "Refresh source" in the base view to have the new field appeared in Denodo, but that's not the case ...

code

Why Denodo services are going down frequently in linux box? Can any one provide the script for automation to get an alert when the denodo services are goes down?

Why Denodo services are going down frequently in Linux box? Can any one provide the script for linux automation to get an alert when the denodo services are goes down. or script for automation to check for every 5 minutes the denodo services are in sta...