Latest Activity

code

Array Contains with Databricks driver.

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

code

Push down Analytical Functions to Google BigQuery

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

code

With Clause/statement

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,

code

Authentication through Headers

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

code

Administer Denodo in a headless environment

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

code

Problem with trunc

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

code

Catalogue search

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

code

Materialized Tables vs Temporary Tables

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

code

Leveraging Denodo's Data Virtualization for Optimal Data Access in Hybrid Cloud

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

code

Performance Issue when Running a query for one solution

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