Skip to content

Returns refresh information for a materialized view.

func.inspect_mv_refresh_info(<db>, <mv>)
func.inspect_mv_refresh_info('mydb', 'my_mv')
┌────────────────┐
│ (refresh info) │
└────────────────┘
INSPECT_MV_REFRESH_INFO(<db>, <mv>)
SELECT * FROM TABLE(INSPECT_MV_REFRESH_INFO('mydb', 'my_mv'));
┌────────────────┐
│ (refresh info) │
└────────────────┘