View materialized views
In EMR Serverless StarRocks, materialized views store precomputed query results so that repeated or expensive queries read from cached results instead of recomputing from base tables. This topic describes how to use EMR StarRocks Manager to view asynchronous and synchronous materialized views.
Prerequisites
Before you begin, ensure that you have:
An EMR Serverless StarRocks instance. For more information, see Create an instance.
View asynchronous materialized views
Go to the EMR StarRocks Manager page.
Log on to the EMR console.
In the left-side navigation pane, choose EMR Serverless > StarRocks.
In the top navigation bar, select a region based on your business requirements.
Click StarRocks Manager, or find the target instance and click Connect in the Actions column. For more information, see Use EMR StarRocks Manager to connect to a StarRocks instance.
In the left-side navigation pane, choose Materialized View Management > Asynchronous Materialized Views.
On the Asynchronous Materialized Views page, use the following tabs to inspect your materialized views:
Materialized Views: Lists all asynchronous materialized views in the current instance. Filter by name, database name, refresh type, status, or latest refresh task status. Click a materialized view name to open its basic information, tasks, and monitoring information.
Tasks: Lists all refresh tasks across all materialized views. Filter by query ID, task name, materialized view name, database name, or status. To inspect a specific task, click View Details in the Actions column to open the Import Tasks page.
View synchronous materialized views
In the left-side navigation pane, choose Materialized View Management > Synchronous Materialized Views.
On the Synchronous Materialized Views page, browse or filter synchronous materialized views by name or database name. Click a materialized view name to view its basic information and monitoring information.