We have a model with a posthook that generates an output file from a source table. I want to be able to check if the output table is fresh - for example the model was already executed today- and then exclude that model based on a positive freshness - as in the contents are fresh as opposed to stopping it for data being stale.
Thoughts ? My initial idea was to give the freshness test a negative value but it does not appear that is supported.
Would love to know of any solutions out there
Thanks,
Adam