@manish1987c I developed similar project. I think the issue might because it's a materialized view prior to your last gold layer. The materialized view only contain the most recent records, not the whole logging of the table. I wonder if it works for you to change it to streaming table.

For me, a streaming table doesn't work because I need to apply some window functions to clean the data. I haven't figured out a way to fix this problem.