@tenzinpro have you looked into the documentation Incremental-refreshes for materalised views with streaming tables yet? https://docs.databricks.com/aws/en/optimizations/incremental-refresh .. there's a section in there which jumped out to me:

I'd suggest reading a little more in the article to see if anything you're doing is violating an incremental-refresh requirement

All the best,
BS