I have an explore of a PDT that joins other PDTs with different SQL triggers. I’d ideally like cache to be cleared when either the base explore PDT is updated or any of the joined in PDTs update.
Essentially I’d like:
persist_with: a_sql_trigger OR b_sql_trigger OR c_sql_trigger
I don’t think creating one SQL trigger with let’s say max date from all 3 tables would work. For example, if max date from a is 1/1 and b is 1/3, max date is 1/3. if max date from a then changes to 1/2, sql trigger value is still 1/3.