Identify updated rows during incremental refresh in DLT Materialized Views
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2025 06:01 AM
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?
Labels:
- Labels:
-
Workflows