Q&A BY TAG 'Derived views'

You must sign in to ask a question. If you do not have an account, you can register here

Using VQL to DROP or DELETE a derived view
answered 21-07-2022 02:03:29 -0400

Is there a way to DELETE or DROP a derived view using VQL? I would like to programatically do this in python but there doesn't seem to be a VQL command (that I can find) that would allow me to have a list of views to run through and delete. Thanks!

Answers: 3

VQL Delete Derived views

dynamically create derived views based on list of multiple base views
answered 15-11-2021 16:50:51 -0500

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

Answers: 1

VQL Dynamic Derived views Loops

About Access to view vql of derived views
answered 07-10-2021 19:45:17 -0400

Some one of my team wants to exexcute one derived views that I created, and he also wants to have the read access of that derived views's vql. I grant "metedata", "execute" access of this derived view to him, I think it is the read access we mentione...

Answers: 3

access to view vql derived views

Compounding a derived view
answered 14-09-2021 12:48:18 -0400

Hello, I am working on duplicating the behavior of an API, it works pretty good, all the fields are mapped etc. However, the in-place API expose the data after structuring it : { "cat1": { "a":"toto", "b":"titi" }, "cat2" :{ "c":"tata" } } while the d...

Answers: 2

VQL REST Webservice Derived views

Joining Census data with Azure dataverse data
answered 04-08-2021 13:11:12 -0400

Hi All, This is probably mainly to get pointed in the right direction. Here's the problem. I would like to be able to geocode addresses as they appear in the Address table. My idea is 1) Create a base view for the REST API from the census. The censu...

Answers: 2

Azure Base view census geocode Derived views

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

VQL Denodo 7.0 search methods join Derived views

Building derived views that originally have subqueries in them
answered 16-02-2021 10:07:04 -0500

I have a query that I'm trying to build the logic for as a derived view. Basically, translating my view that is on a DB to Denodo as a Derived View. Trying to figure out that if we have a subquery in the from or where clause, do we have to create anoth...

Answers: 2

Denodo 8.0 Derived views Subquery

Joinin view from different data source
answered 18-11-2020 07:37:05 -0500

I have created 2 views from 2 different folder of same parent folder. Suppose parent folder name is Parent and it has 2 subfolder like subfolder1 & subfolder 2 I have created derived view by joining both views.Now challenge is when I am trying to ...

Answers: 1

Derived views

Joins in Derived Views (VS) Associations
answered 21-10-2020 07:57:58 -0400

Hello Team, I would like to understand what option is better to use in the scenario of star schemas: Only Joins in models for the derived views Only Associations in Derived views A combination of Joins and Association in Derived Views Plea...

Answers: 1

joins Associations Derived views

Need to extract the second row of a duplicate in a table
answered 20-10-2020 08:03:34 -0400

Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...

Answers: 1

row number select derived views