Updated on 2025-05-29 GMT+08:00

Overview

Complete-refresh materialized view is a materialized view that supports only complete refresh. That is, old data is discarded and the entire table is recalculated for query.

The syntax for creating a complete-refresh materialized view is the same as CREATE TABLE AS. For details, see "SQL Reference > SQL Syntax > CREATE TABLE AS" in Developer Guide. You cannot specify a node group for a complete-refresh materialized view. Creating a complete-refresh materialized view inherits the constraints of GTM-Free.