INSPECT_MV_PLAN

Learn how to use the INSPECT_MV_PLAN meta function in PlaidCloud Lakehouse. Returns the logical plan of a materialized view - with syntax and examples.

Returns the logical plan of a materialized view.

Analyze Syntax

func.inspect_mv_plan(<db>, <mv>)

Analyze Examples

func.inspect_mv_plan('mydb', 'my_mv')

┌────────┐
│ (plan)  │
└────────┘

SQL Syntax

INSPECT_MV_PLAN(<db>, <mv>)

SQL Examples

SELECT INSPECT_MV_PLAN('mydb', 'my_mv');

┌────────────────┐
│ (logical plan)  │
└────────────────┘