Sơn Bùi
06/16/2026, 10:25 AMKate Shao-Community Manager
06/16/2026, 10:46 AMSHOW CREATE MATERIALIZED VIEW <mv_name>, which will show the MV definition, including the refresh configuration. You can also use SHOW MATERIALIZED VIEWS FROM <db_name> to list MVs and see their status/basic refresh information. For refresh job history, check information_schema.tasks and information_schema.task_runs if your version supports them. There is no dedicated StarRocks UI specifically for MV refresh config; SQL is the recommended way to inspect it.