Q&A BY TAG 'Derived views'
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
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
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
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
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
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
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
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
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