Identify updated rows during incremental refresh in DLT Materialized Views

ManoramTaparia
New Contributor II

Hello, every time that I run a delta live table materialized view in serverless , I get a log of "COMPLETE RECOMPUTE". I realised I was using current_timestamp as a column in my MV to identify rows which got updated in the last refresh. But that makes the MV refresh non-deterministic leading to a log of "COMPLETE RECOMPUTE" every time.

How do I perform incremental refresh and also be able to identify which rows changed as part of the refresh?