Latest Activity

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

code

How to run a vcs pull of a database through code

We have set up our denodo solution such that it is connecting to a gitlab repo. We have defined a ci/cd process that takes the files from the development gitlab repo and pushes them into uat gitlab repo. We would like to run a VCS pull command on all d...

code

Snowflake Service Account for Alation

Our organization is looking to bring on board the Alation product for data mining. To do so, Alation requires a service account in Snowflake to touch every database, every schema in Snowflake. Obviously this is very broad access and the org is concer...

code

Upgrade from Denodo driver version 8.0.20220126 to 8.0.20220815

We have been running Denodo version 8.0.20220126 for quite some time. Every day a process is executed that executes a query using the denodo driver. We are using Virtual Dataport Server 8.0.20220815. Denodo Platform 8.0 Denodo Design Studio 8....