View the original community article here
Last tested: Nov 29, 2020
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?
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.