You can translate the question and the replies:

Is there a VQL query I can run as a developer in Denodo to determine the time to live of cached views?

Hi, Is there a VQL query I can run as a developer in Denodo to determine the time to live of cached views? I have tried the following queries but it seems to only indicate whether the item is cached or not. select from catalog_views() where resultcachestatus < > 0; Select * from get_views() where database_name = 'MY DB ' and cache_status = 3 Thanks for the help
user
21-02-2023 02:28:42 -0500
code

1 Answer

Hi, As per my understanding, you’re trying to get operational and metadata information about your cached views in Denodo through VQL script. Denodo Platform has predefined stored procedures that you can use to get the cache information of your views. In your requirement, you can use the procedure called [**GET_CACHE_TABLE**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_cache_table) to get the information of your cache views like time to live, table name of where the cache is stored, etc. Other predefined stored procedures are also available, which can help you in querying information about your cache like [**GET_CACHE_CONFIGURATION**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_cache_configuration) to get cache information on database level, [**GET_CACHE_COLUMN**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/get_cache_columns) to get cache information on column level, etc. Feel free to browse the User Guide to learn more about other [predefined stored procedures](https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_procedures). Hope this helps!
Denodo Team
22-02-2023 21:04:16 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here