My question is: can materialized views be updated incrementally. For example:

In my case, we store the data in Iron layer and it gets flattened in bronze and silver layer as separate tables. The required transformations happen from silver to gold layer.

All the Iron, bronze and silver layers are streaming tables as SCD type 2 and gets incrementally loaded. 

The Gold layer are materialized views. Every time the pipeline runs, the materialized views are fully refreshed. But we wanted to have those incrementally loaded.
Example:

SILVER        
         
Table: Client        
         
ClientIDClientNameAddressStatusCreatedDateStartDateEnddateRunDate 
1ABCFloridaNew03.15.202503.15.202503.16.202503.15.2025 
1ABCMiamiNew03.16.202503.16.202503.17.202503.16.2025 
1ABCMiamiActive03.17.202503.17.2025NULL03.17.2025 
2QWEKansasActive03.15.202503.15.202503.18.202503.15.2025 
2QWEKansasInactive03.18.202503.18.2025NULL03.18.2025 
3GHJBuffaloActive03.18.202503.18.2025NULL03.18.2025 
         
         
GOLD        
         
Materialized  View: Client       
         
IDNAMEAddressStatusCreatedDateStartDateEnddateRunDate 
1ABCMiamiActive03.17.202503.17.2025NULL03.17.2025These should also be incrementally loaded.
2QWEKansasInactive03.18.202503.18.2025NULL03.18.2025
3GHJBuffaloActive03.18.202503.18.2025NULL03.18.2025



DHARINI PARGUNAN