Home / Q&A / 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)?
You can translate the question and the replies:

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

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 out after 15 minutes. Is there any way to create parameterized view. For e.g. I will pass Year Parameter, let's say only 2002 to the derived view and select only sub set of the data not entire table. I would like to pass this parameter from Tableau to Denodo. In short, Tableau will pass 2002 Year to Denodo. Denodo will return 2002 year records to Tableau, Not all 5 millions records.
Parameterize Parameter derived view slow query Tableau
user
11-06-2018 16:53:16 -0400

1 Answer

Hi, Using a parameterized derived view to do this is a great idea and I think it will be very beneficial to your particular scenario. This answer [here](https://community.denodo.com/answers/question/details?questionId=9060g000000L78oAAC&title=How+to+add+by+default+values+in+the+base+view%3F) details what you can do to make this work. That answer points to the section of [Parameters of Derived Views](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/creating_derived_views/creating_selection_views#parameters-of-derived-views) as well. Hope this helps!
Denodo Team
12-06-2018 12:50:33 -0400
You must sign in to add an answer. If you do not have an account, you can register here