I want to identify which rows were updated as part of the last refresh if it was an incremental refresh. Is there an external event log in the form of a table which could help in identifying this?
I was trying to achieve this using current_timestamp as a col in my SQL function, but then that makes it non-deterministic and so it runs as a COMPLETE_RECOMPUTE every time.