INSPECT_MV_META

Learn how to use the INSPECT_MV_META meta function in PlaidCloud Lakehouse. Returns metadata about a materialized view - see syntax, examples, and output.

Returns metadata about a materialized view.

Analyze Syntax

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

Analyze Examples

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

┌───────────────┐
│ (mv metadata)  │
└───────────────┘

SQL Syntax

INSPECT_MV_META(<db>, <mv>)

SQL Examples

SELECT * FROM TABLE(INSPECT_MV_META('mydb', 'my_mv'));

┌───────────────┐
│ (mv metadata)  │
└───────────────┘