Incremental Materialized View

What is an Incremental Materialized View?

In the Materialized View chapter, we learned how to create a Materialized View. However, when a Materialized View is refreshed, the entire query is re-executed and all data is fetched again from the source. With large data volumes, this puts a heavy load on the system.

The Incremental Materialized View is designed to solve this problem. This feature is available on the workspace pages of the Data Catalog module, so switch to the Data Catalog module to set it up. For instructions, see 2.3.4 Workspace Dataset Settings.