You can translate the question and the replies:

Is it possible to query only the data in the Cache of a derived view?

Hello - very new to Denodo and running into a questions I am looking for help with. Esentially, I have created an ODBC connection between our denodo databases and Alteryx. I am querying data from a denodo table, but I am only interested in returning data in the cache of a derived view table. Is this possible? Any guidance would be greatly appreciated! Thanks, Dan
user
05-04-2018 20:57:58 -0400
code

1 Answer

Hi, I would try using the noDelegateViews in the CONTEXT clause of the query to avoid delegating the query to the data source. This way the query will always hit the cache table to get the data. select * from <view_name> CONTEXT('nodelegateviews' = '<view_name>') To know more about CONTEXT clause refer to the secion ["CONTEXT clause"](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/context_clause/context_clause#context-clause) of the Virtual DataPort VQL Guide. Hope this helps.
Denodo Team
06-04-2018 08:15:25 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here