Hi good people. I have a question: Is there anyway...
# questions-and-troubleshooting
s
Hi good people. I have a question: Is there anyway to see the refresh config of materialized view on Starrocks, like some UI or anythings. Sorry for my poor english
k
The easiest way is to use
SHOW 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.