Latest Activity

code

Denodo to Elasticsearch

Hi team, May I check if Denodo platform 8 is support the elasticsearch 8.5?

code

finding a view in migration

we are migrating a view from development to test . How can we find a revision that is created by someone else in solution manager ?

code

Why the query is not delegating completely to source when my main data source and and cache datasource , both are on Snowflake ?

Hi Team, We have setup cache DB on Snowflake, and then cached on of the view and used it in our implementation. (Cache Type being Full.) On joining this cache view with another view, which is also built entirely on Snowflake, the query is not getting...

code

Verify return results: i.e. Estimated row count. Check if base views return results (with limit clause)

In the presentation I find at some point "Verify return results: i.e. Estimated row count. Check if base views return results (with limit clause)." As far as I can understand, the Denodo Testing Tool can perform exact match, or subset/superset match b...

Related to: Testing in Denodo

code

How to select the records with the most recently updated status from duplicate records?

In the sample table below, I'd like my query to return only the rows for the records where ThingA has the status of C as updated on 15December2022 (most recent update) and ThingB as the status of B as updated on 21November2022 (most recent update). I w...

code

Creating new field in derived view using conditional logic

Hello. I have created a derived view named 'dv_1' based on a base view named bv_1. I need to create a new column named 'new_col' in the derived view 'db_1' using conditional logic. The values in the new column 'new_col' depend on the values of two a...

code

Server cannot be reached in Graphgl

in the " Lab Use Denodo GraphQL Service to query views " DEN80EDU13DS02LAB03 after using the URL provided in the LAB guide i got this message " Server cannot be reached " then i changed it to the http://<host>:<port>/denodo-graphql-service/...

code

Integration of DevOps CI/CD with Denodo?

Hi there, is it possible to integrate devops functions, like tests and linters together with the Denodo Version Control (VCS). For example, how can I integrate a linter that checks formatting of commis-messages (e.g. gitlint) with Denodo? Thanks

code

Dynamically Query a WS With Compound Values

Hello, We have a requirement in which a soap ws needs to be dynamically queried. The mandatory input parameter to query the ws is a compound type: { ROW( '', Parameter1, '' ),ROW( '', Parameter2, '' )} Is it possible to pass a text Parameter in...

code

VQL comments get removed after edit and save

Hi there, I tried to add a comment to the VQL description of a selection-query, which I created and saved. I tried different comment styles as described in the docs (#, //, / ... /). Why are the comments removed after saving the edit? Thanks