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

Dendo Design Studio's problem with Neo4J
answered 24-11-2022 03:06:10 -0500

Hello Team, I'm using Denodo 8 via Web Design Studio. I created the Neo4j datasource via HTTP configuration with post method, also making use of a Json file. I inserted the fields via the following source query: {"statements": [ \{ "statement": "MATCH ...

Answers: 1

flatten Array Neo4j JSON FLATTEN Derived views JSON Datasource WEB design Studio

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

Delete VQL 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 Subquery Derived views

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