Q&A

Hi, I need to create a pivot from a data view. I have followed the documentation https://community.denodo.com/kb/en/view/document/How%20to%20Pivot%20and%20Unpivot%20views but the solution does not meet my needs. On the other hand, I found a function t...

Hello! I am looking to create a backfill of data for dates where I can say give me all the data for a specific day and append it to each other so I have a table like 1/1/21 data data data 1/2/21 data data data ... And then have the ability to add new l...

Hi there, Is there a method where any changes made on a source table can be automatically 'enforced' on a base view table? The purpose being the ability to always keep base views in line with the LAG version of its source table? Likewise, should the s...

Related to: How to detect changes in data sources

i passed my certification today and i got it i wanted to see my name so i searched my mail in the Denodo Professional Certification Registry i got " Certifications not found for given search " is there any problem should i worry about it ?

Can a wildcard pattern be used in the search option on the Denodo Server Explorer Databases screen? If so, what is the wildcard variable pattern. For example, i would like to use a wildcard value pattern to be able to begin back databases with the dat...

what is the différence between starting the design studio and launching the design studio ?

Can DBT consume data from Denodo ? if yes how do I connect to denodo from DBT

Hi, with increasing frequency since update 20230301 we receive erros like Finished with error: View 'b5d63c4d-4787-436e-9d51-7568b89c6362' not found. This happens within the VQL shell and during deployments. We have never had errors like this and the ...

Hi , I have made a snowflake data source connection and created a base view on top of it which has a total of 1988 records . when i'm using a simple select * to execute my base view , it gives results instantly for 150 rows , but when i check the inclu...

I have configured one of my views to use Data Movement and create temporary tables on one of my SQL Data Sources (using jdbc drivers). The view executes correctly, but the tables created on the data source are not being cleaned up after the view compl...