Q&A

Hi, i've been working with Denodo and Databricks (Using a JDBC connection) and i've encountered an issue with the databricks driver. It seems like when i perform a query like this: Select teammembers from some_table where (teammembers).item = 'some_v...

HI Denodo Team. I'm working with a Bigquery connection and I get an error when I define a derived view in "Virtual DataPort", when the query contains an analytic function, such as: ROW_NUMBER() OVER (PARTITION BY ...). Is it possible to push down Ana...

Hi There, Can denodo send WIth Clause Query as it is to Oracle Data source? Why denodo try to optimize With Clause into SubSQL Query? Can we pass direct With Clause to any data source via denodo ? thanks,

Hi, Denodo Team, We want to delegate the authentication of users to an identity provider using SAML. We know that this is possible in Denodo, but in our case, our applications are redirected to apache machines. The apache machines are in charge of mak...

Good day - I'm experimenting with Denodo Express on a headless Ubuntu server. Is there any way to administer the server? The article below talks about running ./vdpadmin.sh, but that doesn't do anything in a headless environment. I've tried looking for...

Haloo,, I have a data table named PlanDate, and the format of the data is timestamptz, i want to make the PlanDate is adaptive to always in the 1st day of the previous month, i created VQL statement like this : PlanDate >= trunc(addmonth(current_d...

In v8 where can I find a guild to how the catalogue search works?

Is there a way to limit users so they can be able to create Temporary tables and NOT be able to create Materialized tables in Denodo? I could only find this in the Temporary table documentation: Privileges Required The user creating the temporary t...

Greetings, Denodo community, I'm keen to delve into a discussion on the capabilities of Denodo's data virtualization technology, specifically in the context of managing and optimizing data access within a hybrid cloud environment. As organizations inc...

I'm having a performance issue on the devlopment server for one solution when running a certain query. Here are some details: The query was running OK, and suddently it has performance issue The query is an left outter join of a view to itself (e...