Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime
Provides information about whether a query can be incrementalized when being refreshed for a materialized view.
To learn about materialized view incrementalization, see Incremental refresh for materialized views.
Important
EXPLAIN CREATE MATERIALIZED VIEW confirms structural eligibility for incrementalization. It does not guarantee an incremental refresh will be executed when using the AUTO policy. In that mode, the cost model still chooses a full recompute at runtime if factors like changeset size make a full refresh cheaper. The REFRESH POLICY INCREMENTAL and REFRESH POLICY INCREMENTAL STRICT policies override this cost model decision.
Syntax
EXPLAIN CREATE MATERIALIZED VIEW
AS
query
Parameters
query
A SQL query for a materialized view to be explained.
Examples
EXPLAIN CREATE MATERIALIZED VIEW
AS
select k, sum(v) from source.src_schema.table group by k;
+----------------------------------------------------+
| plan|
+----------------------------------------------------+
| == Physical Plan ==
*(2) HashAggregate(keys=[k#33], functions=[sum(cast(v#34 as bigint))])
+- Exchange hashpartitioning(k#33, 200), true, [id=#59]
+- *(1) HashAggregate(keys=[k#33], functions=[partial_sum(cast(v#34 as bigint))])
+- *(1) LocalTableScan [k#33, v#34]
|
+----------------------------------------------------