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

Simulating an Update statement in Denodo
answered 18-08-2020 03:14:45 -0400

How do we simulate below statement in a derived view in Denodo update fw_denodo_table a set a.column1 = b.column2 from denodo_table2 b where a.column2 = b.column3 and a.column5 = b.column6 and a.year=2019; Please advise

Answers: 1

joins update derived view

joining multiple base view error via custom wrapper parquet file in S3.
answered 08-07-2020 11:00:56 -0400

Hi Team, I am getting below error while creating the derived view from joining multiple base view. Accessing the AWS S3 bucket data source from custom wrapper parquet file in S3. [CUSTOM WRAPPER] [ERROR] Received exception with message 'Error accessi...

Answers: 3

S3 parquet file DENODO AWS S3 derived view custom wrapper

Create a Selection View and get only the first 2 records
answered 13-02-2020 07:32:36 -0500

Hello I want to create a selection view of a derived view that has a column "date" (localdate), and in this selection view I waht to order by date desc, and I only need the first 2 records. How can I do that in denodo? I have this record: 2019-12-01 ...

Answers: 3

select derived view

To add a parameter to a derived view
answered 14-01-2020 02:37:03 -0500

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Answers: 3

Parameter View Parameter entry derived view

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

Answers: 1

subquery Execution plans Stored Procedure derived view

How to query on different View?
answered 17-07-2019 08:22:31 -0400

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 ??

Answers: 3

REST Webservice derived view Interface

How to query on different View using web services?
answered 11-07-2019 06:21:13 -0400

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...

Answers: 1

REST Webservice derived view Interface

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?
answered 22-01-2019 16:09:34 -0500

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Fi...

Answers: 1

derived view URL deployment

issue in accessing derived views in Alteryx
answered 19-10-2018 16:17:06 -0400

Hi, I have provided access for a derived view from denodo to Alteryx. The user is able to access the derived view from SQL editor in Alteryx. My question here is Can I view the list of derived views in the rightside navigation panel in the Visual Que...

Answers: 2

access ODBC Alteryx derived view alteryx

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