Knowledge Drop

max_cache_age and PDTs


Userlevel 2

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.                

 

 


0 replies

Be the first to reply!

Reply