Latest Activity

code

LEAD function doesn't work in Denodo 8

Hi there, when I tried to use LEAD function in Denodo 8, the color doesn't change and the error shows the Function LEAD is not executable. From the documentation, the LEAD function is available in Denodo. What I have missed? Thank you!

Analytic Functions (Window Functions)

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

BigQuery Analytic Functions (Window Functions)

code

Is it possible to track a database over a certain period of time with DENODO?

We wonder if it is possible to track a database over a given period of time, using any specific DENODO functionality, for performance analysis and operational statistics purposes.

Denodo Monitor performance Analytical Analytic Functions (Window Functions) Statistics

code

Analytic Functions at the Denodo engine level

My team has been running into quite a bit of issues with analytic functions when joining across data sources. We have experimented and worked with data movement to resolve some of these issues. However, reporting packages (like Looker) do not have the ...

Analytic Functions (Window Functions)

code

Analytic Functions (Window Functions) using denodo 8.0 Error executing view: Function row_number is not executable Any possible ways to use Analytic Functions in denodo

Analytic Functions (Window Functions) using denodo 8.0 i have added functions into datasource (oracle19c) using source_configuration still getting below error Error executing view: Function row_number is not executable Any possible ways to use Analyt...

Analytic Functions (Window Functions)