Latest Activity

code

HTTP Client given date in request

Hi! I need to query HTTP/JSON datasource with parameters like this: /values?Name=Foobar&Start=2024-01-16&End=2024-01-17 (the previous and the current days) so I create a Base view with relative URL like this: /values?Name=Foobar&Start=@...

code

Licenses for VQL stored procedures

Can all licenses use VQL stored procedures?

code

Compatibility Concerns: i9 Laptops and Denodo Versions

Hello Denodo community, I hope this post finds you all well. I've been exploring the capabilities of i9 laptops for my work with Denodo, and I wanted to reach out to the community for insights into potential compatibility concerns. If you've had any e...

code

Rest Api - No of Records

hi all, I am using denodo vdp to create rest api. After executing I get the data but I am unable to get total number of records along with the output of data. adding $count give just total number of records, while i want both data and total number of r...

code

How to split column into more columns

Hi teams, I have one column, the content is 60 X 30 X20 mm. Now I want to split them into three columns call length, width, height. The delimiter is 'X'. How can I implement it? When I use the function SPLIT, the column includes an array. How to conve...

code

Databrick/Denodo integration (databricks as a consumer)

Do we have any documentation or any process where we can connect denodo from databricks, here databricks will work as consumer and it will pull data from denodo(source)?

code

insert into a materialized view using select

Hi there, I have 2 questions: Can you please provide a syntax for this example below. I want to add 2 more set of rows: Washington, WA, Seatle and Colorado, CO, Denver into this table 'usa_state' which has 3 fields: state, abbreviation, capital ...

code

Can Denodo MPP work with Netezza?

Can Denodo MPP work with Netezza?

code

Column order alphabetical in Explorer vs ordinal in view Summary

When expanding a view in the Design Studio (Denodo 8), we noticed that columns in the Explorer are always listed in alphabetical order, whereas looking at the summary in VQL properties, the columns are listed ordinally as designed. However, in the Den...

code

Conversion of Teradata Text Column to Decimal with Conditional Zeroing in Denodo

I am currently facing a challenge in Denodo related to the conversion of a Teradata column named "Amount" with a data type of Text. The goal is to convert this column to Decimal to do sum operations. Additionally, I want to handle cases where the colum...