Latest Activity

code

Pivot-xfunct-Denodo 8-pivotregister

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

code

Gathering data for all dates in a range

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

code

Enforcing source alignment within base views

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

code

Denodo Developer Associate certification

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 ?

code

Denodo Server Explorer Databases Search

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

code

starting lanching the design studio

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

code

DBT connection to Denodo

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

code

Error loading view after update

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

code

query timeout issue

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

code

Data Movement Temporary Tables not deleting from SQL Server data source

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