Q&A BY TAG 'derived view'

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

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter derived view Tableau

Denodo Training - Derived Views
answered 17-04-2018 11:45:29 -0400

Hello, I am taking the Denodo Training and i am stuck creating a derived view. Data Virtualization Developer Introduction - DEN60EDU0118LAB01 I do not understand how to convert parameters into a simple field.

Answers: 2

training derived view

How to view execution history of a view
answered 07-09-2017 09:14:34 -0400

Hi, How to see the execution history of a base/derived view. I want to see the historical execution status of a view. the run time and the status of execution. Is there any way we can get the historical statistics of the views executed in denodo. S...

Answers: 1

derived view execuion history

Creating an XML output view using the existing base/derived Views
answered 01-09-2017 09:29:26 -0400

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

Answers: 1

XML DENODO XML Data Source derived view XML request to response

SQL queries ran on native Data source in VDP
answered 29-08-2017 10:30:36 -0400

Hello there, I just a few questions, I was wondering if you could provide me with an answer. How can I edit a SQL query that I created directly on the Data Source(Hadoop)? How should the SQL query be written, names the datasource, table, and fiel...

Answers: 1

base view Hadoop Sql performance derived view

Derived view access issue from Alteryx
answered 13-07-2017 09:06:23 -0400

Hi, User wanted to connect to a derived view from Alteryx, So I have provided connect privilege for the respective database and read privilege to the derived view. Now the user is able to access the derived view from SQL editor in Alteryx but not able...

Answers: 1

access ODBC Alteryx derived view

restricting access to derived views only.
answered 10-07-2017 17:16:11 -0400

Can we provide read access for a derived view to users without providing any access to base views. User is accessing views from another tool(Alteryx) through odbc connection. Thank you Sachi

Answers: 2

Access derived view

Creating a new column in derived view
answered 12-04-2017 08:49:20 -0400

Hi team, I created a derived view from two base views. In this derived view I want to create a new column doing the following transformations to the data: I currently have this column existing column street: value: 'streetname123' I want to create a...

Answers: 1

Data Quality derived view

Field expressions guide
answered 30-03-2017 06:53:24 -0400

I'm trying to find a good guide on writing field expressions for new fields in derived views. I've looked through the admin, developer and advanced VQL guide and still can't find what I'm looking for. What I basically want to do is create a new field ...

Answers: 4

Expression derived view Regular Expressions

View Parameters and Aggregation
answered 02-03-2017 08:54:39 -0500

I am fairly new to Denodo and I have read through the Advanced VQL and VDP Administration Guide but I am not able to resolve the following issue: Sample Base View For the sake of this issue, let's consider a base with student, months and rank. ...

Answers: 4

parameter derived view Aggregate