Latest Activity

code

How to show implementation details from an interface?

Looking for a way to export/show implementation details from an interface. How to retrieve this data? Desired solution is a VQL script which shows for interface(s) for example a format like: | Interface name | Interface Definition Field | Interface D...

Metadata Interface

code

Interface View

Hi, I would like to define the interface which has customer_key, customer_name, order_date and sales_amount. adding a implementation to that, i need to get the customer name from customer base view and all other columns from fact_Sales view. on the ...

Interface

code

List all interfaces with field names

We're looking to get a list of all our interfaces, with field names, and preferably attributes (ex. data type, max length). The end goal is to allow report developers to be able to search for all interfaces which contain specific field names. Is this p...

names Interface statistics

code

How to query on different View?

I have 3 derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denodo ??

REST Webservice derived view Interface

code

How to query on different View using web services?

I have one Base view top of that I am creating 3 diffrent logic Derived view A, B and C. I want to pass parameter from web services like B then the query agains B derived view. If I pass C then the query agains C derived view. This is possible in Denod...

REST Webservice derived view Interface

code

How to deal with the changes on the Interface View (Implementation)

We need to change an attribute type from Array (register) to Nested object in a derived view, which impacted the dependent Interface and then the subsequent REST service. The moment we made this change the interface view model changes and the impleme...

Interface

code

Refreshing a service

I have a SOAP service as a data source. We created a base view for one of the the data providers of that service and then we created an Interface to publish our data. We now modified the service and added some more columns that we would like to publish...

Base view SOAP Interface

code

VQL for interface creation

On creating interfaces from derived views using denodo front end, I found that some decimal columns(in the derived view) were shown either as decimal or long datatype in the interface. I wish to create interfaces using vql script. Is it safe if I copy...

Interface

code

Execution output as input of another view

Hi guys! Is it possible to use the output of an interface/dv as input for another one? I want to avoid joining them, just want to use the output of the first one to filter the second one. We want just to use two views/interfaces like in a workflow i...

interface

code

Do we need to generate the statistics for Interface views

Generating statistics for base view is enough or generating statistic for interface views will also improve performance

view VDP query optimisation interface Generate stats