max_cache_age and PDTs

Knowledge Drop

Last tested: Nov 29, 2020
 

Question:

If a PDT is tied to its datagroup that’s based on ETL with a max_cache_age of 24 hrs, if the ETL table doesn’t update, should that PDT rebuild after 24 hrs?

Answer:

No, max cache age has no effect on PDTs triggering. It only applies to cached explore/look/dashboard query results. And even then, it just drops cached results after 24 hours. It doesn't fetch new data.

If you wanted a PDT to rebuild every 24 hours, use a sql_trigger_value that selects the current day.

This content is subject to limited support.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: