You can translate the question and the replies:

Restricting / slice of data to be accessed from denodo views

we would like to ensure that only a specified time interval data ( say 10 days of data) can be retrieved from denodo views. assuming that table has time series data l. we would like to accept only those queries which are selecting data within specified interval and would like to reject queries which are fetching data of more than sepcified days. Custom plicy could be oone one option but problem with user can write his queries of selecting data in many ways like using >,>=,<,<= ,in between etc. has anyone implemented similar thing ?
user
24-10-2019 05:41:22 -0400

1 Answer

Hi, Custom policies are a good way to achieve that. Besides this, you can also have a look at [Query Capabilities](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/advanced_configuration_of_views/query_capabilities) as well as on the [Resource Manager](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/resource_manager/resource_manager). Both allow managing queries with a variety of options and help you achieving your goal. Hope this helps!
Denodo Team
24-10-2019 07:10:02 -0400
You must sign in to add an answer. If you do not have an account, you can register here