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:
explore: pdt_a persist_with: a_sql_trigger OR b_sql_trigger OR c_sql_trigger join: b join: c
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.